Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Job ESB to RedShift

If i post this in the wrong category please move to correct.

 

When i deploy a job from ESB with a rest service that consume a RedShift Data base it returns this error:

 

[Amazon][JDBC](10100) Connection Refused: [Amazon][JDBC](11640) Required Connection Key(s): PWD, UID; [Amazon][JDBC](11480) Optional Connection Key(s): AccessKeyID, AuthMech, AutoCreate, BlockingRowsMode, ClusterID, DbGroups, DisableIsValidQuery, EndpointUrl, FilterLevel, IAMDuration, Language, loginTimeout, OpenSourceSubProtocolOverride, plugin_name, profile, Region, SecretAccessKey, selectorProvider, selectorProviderArg, SessionToken, socketTimeout, ssl, sslcert, sslfactory, sslkey, sslpassword, sslrootcert, SSLTruststore , SSLTrustStorePath, tcpKeepAlive, TCPKeepAliveMinutes, unknownLength

 

I know this is not a Redshift access because i have other job ETL with the same configuration that works fine, and this error occurs only when this job is deployed, when i try local it works.

 

I'm trying to deploy via ESB Conductor like i do when i deploy my service that uses mysql.

 

ESB <-> RedShift

0683p000009M3hV.png

 

ESB <-> MySQL

0683p000009M3hk.png

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hello,

Did you get this issue when deploy your job in runtime? Are your runtime in local server?

More information will be helpful.

Best regards

Sabrina