search

OpenInformix / IfxPy

Informix native Python driver for scalable enterprise and IoT solutions.
Other
46 stars 22 forks source link

Informix to AWS Glue #60

Open obulrdy6881 opened 3 years ago

obulrdy6881 commented 3 years ago

I was trying to connect the Informix with AWS Glue using JDBC. I installed the Informix Developer version in my windows system and created an instace assigned with host ip and port. After I uploaded the informic jdbc jar file in s3 and tried to connect with AWS glue. It is not working. My informix server instance is running and the port is on, but still something I went wrong.

Can any help me with this issue what is the actual process for it.

jsagrera commented 3 years ago

Before trying to connect with JDBC I suggest to try a simple telnet to the machine:port (informix port). That will tell you if there is connectivy between the client machine and the server, and if the port can be reached. Obviously a telnet to the informix server (ip:port) will fail with an error on the server side (something like "Invalid message type received") but it is the simple way to test if a client can reach the Informix service. If you get a timeout from your telnet, it means something is blocking the connection, like a firewall.

It may be better to ask in stackoverflow.com (tag it as informix) as this git project is just for the Informix Python module.