Connecting to Informix Database

[AthmanArumugam]

HI All,

Has anyone connect excel power query with BM Informix database. If yes, how have you connected.
Please let me know.

 

[vletm]

AthmanArumugam
Have You 'googled' connect informix database with excel power query?
or
Yours:

Power Query to connect with Informix Database

Hi, I would need to connect my excel power query with informix database. I dont see Informix database as the default option. Could you kindly help me if it is possible. I have the URL and credentials of Informix database

chandoo.org

 

[AthmanArumugam]

Although I search in google , I am not getting the answer whether it is possible or not. Also I am not able to see Informix database in the From Database list. Has anyone connected power query with Informix.

 

[vletm]

AthmanArumugam

 

[Chihiro]

You need to use ODBC or OLEDB connector. There's no built-in connector for Informix.

Of course, you will have to install Informix OLE DB provider. Or ODBC driver. Below links are for OLE DB.
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.oledb.doc/ids_oledb_008.htm
https://www.connectionstrings.com/ibm-informix-ole-db-provider/

 

[Chihiro]

Oh, I forgot to mention. If you directly query data from Informix into Data model. Without using Power Query.
You can see there is OLE DB Provider for Informix dialog available.


Go to Power Pivot manager. Choose Get External Data -> From Other Sources.

You should see Informix connector there.

 

[AthmanArumugam]

Thanks all for your responses. Will try and get back.