Forum Discussion
Hooking Up Old-school Informix Databases to Power BI with PowerInformixRetro
PowerInformixRetro
PowerInformixRetro is a custom connector for Power BI, written in Power Query M and developed using Visual Studio Code + Power Query SDK.
PowerInformixRetro allows Power BI to connect to IBM Informix databases prior to version 9 using the Informix ODBC driver, thereby overcoming the limitations of Power BI's default connectors.
PowerInformixRetro defines how Power BI should connect to the database, how it should authenticate the user, and how it should test the connection.
The code is intended to be simple and modular. It is designed to be easily adaptable to other database drivers.
The PowerInformixRetro.Contents function is used to establish a connection to the Informix database.
The TestConnection function is used to test the connection to the database.
The Authentication section defines the authentication methods supported by the connector.
The PowerInformixRetro.Publish section defines the connector's publishing method that's compatible with the Power BI user interface.
The PowerInformixRetro.Icons section defines the icons to be used for the connector in the Power BI user interface."