Forum Discussion
Power Bi to Informix - DRDA issue.
Hi Guys,
I did look for but i couln't find the awnser here.
I have to connect my power bi to informix database, power bi uses DRDA.
I don't have access to informix database to allow DRDA port is there anyway that I could set this up on my Power BI?
Thank you
Fab
Not yet, my action was to raise a ticked with IBM to enable the drda port.
For now my solution it's been using ODBC connector.
6 Replies
Hi Anonymous ,
In the past I linked to an Informix table using an ODBC conection, so not directly to the Informix database but having a link trough OBDC, also because of limitations on connections.
Are you abble to have an ODBC conenction?
Hi MFelix
Yes, I'm trying to use the odbc connector too, however when connected I can't see any tables.
It just shows me "dns=ODBC" and nothing else.
Fabricio
Hi Anonymous ,
There are a few similar threads about this issue.
https://community.powerbi.com/t5/Desktop/ODBC-connection-to-Informix-no-tables/td-p/962691
(Though the user resolved it using the SQL Server Linked server via SSRS eventually, you could reference the answer of v-deddai1-msft to have a try. Maybe it works for you.)
https://community.powerbi.com/t5/Desktop/Connecting-to-Informix/td-p/53829
https://community.cisco.com/t5/unified-communications/microsoft-powerbi-with-cuic/td-p/3018267
