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: ***

[Arun_Manoj]

Hi @monica190 ,

Please check the below link for more details

https://www.servicenow.com/docs/bundle/yokohama-it-operations-management/page/product/service-mappin...

please mark it as helpful. if the solution is useful.

thanks

Arun Manoj

[monica190]

Hi @Arun_Manoj , thanks for your response. However, if you review the documentation and the format I have provided, you’ll see that they are not in alignment. So, this solution may not be helpful.

[Veer · Accepted solution]

Hello @monica190 

I have integrated this functionality, you need to configure few things

1) You have to create new choice value for the format field as showed in the screenshot.

2) You have to upload the jar file, AWS redshift can help you to get that file.

3) Setup your data source by selecting format as redshift and rest of the connection details.
The important step is to restart the mid server and try test connection. this will work.

Please mark this as helpful /  accepted solution if it resolve your issue.

Thanks & Regards

Veer

[monica190]

@Veer  Thank you for the response. Can you also share the details you entered in the data source?