question Re: Integration Configuration Between Redshift and ServiceNow in ITOM forum

Integration Configuration Between Redshift and ServiceNow

monica_detani — Wed, 19 Feb 2025 05:53:46 GMT

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

Re: Integration Configuration Between Redshift and ServiceNow

armanoj — Wed, 19 Feb 2025 05:58:10 GMT

Hi @monica_detani ,

Please check the below link for more details

https://www.servicenow.com/docs/bundle/yokohama-it-operations-management/page/product/service-mapping/reference/amazon-redshift-discovery.html

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

thanks

Arun Manoj

Re: Integration Configuration Between Redshift and ServiceNow

monica_detani — Wed, 19 Feb 2025 11:37:02 GMT

Hi @armanoj , 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.

Re: Integration Configuration Between Redshift and ServiceNow

Veer — Wed, 19 Feb 2025 11:49:40 GMT

Hello @monica_detani

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

Re: Integration Configuration Between Redshift and ServiceNow

monica_detani — Thu, 20 Feb 2025 13:19:45 GMT

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

Re: Integration Configuration Between Redshift and ServiceNow

Veer — Thu, 20 Feb 2025 14:14:16 GMT

@monica_detani

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

Re: Integration Configuration Between Redshift and ServiceNow

monica_detani — Fri, 21 Feb 2025 05:01:48 GMT

@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.

Re: Integration Configuration Between Redshift and ServiceNow

Veer — Fri, 21 Feb 2025 07:06:43 GMT

@monica_detani

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

Re: Integration Configuration Between Redshift and ServiceNow

monica_detani — Wed, 12 Mar 2025 08:24:18 GMT

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

Import logs:

Re: Integration Configuration Between Redshift and ServiceNow

monica_detani — Thu, 13 Mar 2025 06:25:58 GMT

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

Re: Integration Configuration Between Redshift and ServiceNow

monica_detani — Fri, 28 Mar 2025 09:56:51 GMT

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?