Integration Configuration Between Redshift and ServiceNow

[monica190]

Is it possible to configure an integration between a Redshift database and ServiceNow using the provided credentials in the following format?

Host: jdbc:redshift://<hostname>.redshift-serverless.amazonaws.com

Database: <databasename>

Username: ***

Password: ***

[Veer]

@monica190 

Those are sensitive data like server name userid, passoword, port number, sql statment. your AWS Redshift team should be provide those detail. Ask Redshift team from your company / stakeholder to share those details and configure the same. 

if you find any issues let me know.

Thanks & Regards

Veer

[monica190]

@Veer I understand that. I just wanted to know which fields are required. I believe the MID server is also needed for this setup, along with the connection URL. That's why I'm asking about the necessary fields.

[Veer]

@monica190 

Yes mid Server is required. Let me give you what all field are required for this configuration.

The mid server field is not visible on the form but it is required to retrieve data from  Redshift. Without mid server it is not possible to retrieve.

Please mark this as helpful / accepted solution if it resolves your query.

Thanks & Regards

Veer

[monica190]

Hi @Veer  i am getting this error , any idea?

Import logs:

[monica190]

This was resolved by updating the Redshift backend value to the format: com.amazon.redshift.jdbc.Driver