Solved: Connecting to Informix: Port 9089

hailcaesar · ‎07-19-2017

HELP …

We are evaluating PowerBI for deployment to our 3,300 clients. In attempting to connect PowerBI to our Informix database. The first issue we had was PowerBI wanted to connect over port 9089. Which we have restricted

So we added the preferred port number to the end of the server name …

and we got the following message ... Help?

v-yuezhe-msft · ‎07-20-2017

@hailcaesar,

The Microsoft Connector for Informix only supports DRDA. Please make sure that you have configured the Informix server to be “DRDA enabled” and to listen on the 1543 “DRDA port”. And if firewall is turned on, please make an exception for the listening port that is used by Informix.

There is also a similar thread for your reference.
http://community.powerbi.com/t5/Desktop/Connecting-to-Informix/td-p/122729

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yuezhe-msft · ‎07-20-2017

@hailcaesar,

The Microsoft Connector for Informix only supports DRDA. Please make sure that you have configured the Informix server to be “DRDA enabled” and to listen on the 1543 “DRDA port”. And if firewall is turned on, please make an exception for the listening port that is used by Informix.

There is also a similar thread for your reference.
http://community.powerbi.com/t5/Desktop/Connecting-to-Informix/td-p/122729

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Connecting to Informix: Port 9089

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024