You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Redshift Data server connectivity issue with standalone agent in ODI 12.2.1 on windows server

Received Response
9
Views
8
Comments
edited Aug 23, 2018 7:02AM in Data Integration 8 comments

Summary

Redshift Data server connectivity issue with standalone agent in ODI 12.2.1 on windows server

Content

I have configured Redshift Data server in ODI for this i have copied the suitable JDBC drivers for Redshift in odi installed folder.

After this when I am trying to test Red shift connection from local agent it is connecting successfully. But trying to test it from standalone agent it is giving below mentioned error.

 

I have done below changes in Redhsift Dataserver and added the Jdbc drivers in below mentioned paths. Before testing the connection i have restarted Admin server and ODI Agents :

JDBC Driver

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!