Power Bi to Informix - DRDA issue.

[Anonymous]

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

[MFelix]

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?

[Anonymous]

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

[Syndicate_Admin]

Good morning I also have the same problem, someone has been able to solve it? Thank you.

[v-xuding-msft]

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

[v-xuding-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.

[Anonymous · Accepted solution]

Hi @v-xuding-msft 

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.