Informatica throwing the error-"Failed to create JDBC Connection:<Host_name>"
Hi,
We have recently upgraded Vertica to 7x after configuring at Informatica(9.5.1 HF4) end we are getting JDBC connection error.
I have followed all the steps provided in the Document Informatica Plugin guide(attached).
ERROR : (25242 | MAPPING) : (IS | AL_Integration) : AL_Node2811 : JAVA PLUGIN_1762 : [ERROR] Failed to create JDBC Connection: lxv1176.appl.ge.com.
ERROR : (25242 | MAPPING) : (IS | AL_Integration) : AL_Node2811 : JAVA PLUGIN_1762 : [ERROR] at com.vertica.informatica.powerconnect.server.common.ConnectionObj.init(Unknown Source)
ERROR : (25242 | MAPPING) : (IS | AL_Integration) : AL_Node2811 : JAVA PLUGIN_1762 : [ERROR] at com.vertica.informatica.powerconnect.server.common.VerticaJDBCConnection.create(Unknown Source)
ERROR : (25242 | MAPPING) : (IS | AL_Integration) : AL_Node2811 : JAVA PLUGIN_1762 : [ERROR] at com.vertica.informatica.powerconnect.server.reader.VerticaReaderSQDriver.init(Unknown Source)
I am attaching the SessionLog for your Reference.
Can someone help me here.
Thank you in Advance,
Ram
Comments
Moving to the Vertica forum, so you'll hopefully get a response.