Integration Configuration Between Redshift and ServiceNow

monica190 · ‎02-18-2025

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 · ‎02-19-2025

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

View solution in original post

monica190 · ‎03-28-2025

Hi @Veer

I have configured the data source, but I have one question regarding the last run database field. Whenever I use the field provided by the third party, it causes the same error I shared in the screenshot earlier. However, if I uncheck it, everything works fine.

To validate that the issue is not on the third-party side, they provided us with a query that included this database field, and it worked fine when I tested it.

My question is: How does ServiceNow append this field when executing the SQL query, and is there anything I might be missing in the configuration of this field?