How-To import data directly from an Amazon RDS database

Jim O_Shea
Tera Expert

‎03-05-2024 08:10 PM

I used the Amazon RDS Spoke documentation to configure credentials for importing data from an Amazon RDS database.  But when I open IntegrationHub I'm not sure how to configure it?  Is there any additional documentation that I'm missing on steps to configure the database as a data source and setup the transform mappings?

 

Thanks,
Jim

  • 919 Views
3 REPLIES 3

gbdfvdfv
Giga Contributor

‎03-06-2024 12:05 PM

To configure Amazon RDS as a data source in ServiceNow IntegrationHub, follow these summarized steps:

  1. Set Up Credentials:

    • Ensure you have the correct credentials for the Amazon RDS database (username, password).

  2. Define Data Source in ServiceNow:

    • Go to Data Sources in ServiceNow.
    • Create a new data source with the type (JDBC for RDS) and input your RDS connection details and credentials.

  3. Use IntegrationHub to Configure Data Import and Mapping:

    • Install the Amazon RDS Spoke if not already installed.
    • Create a new flow in IntegrationHub, setting up triggers based on your requirements (e.g., scheduled, on-demand).
    • Add actions to connect and fetch data from Amazon RDS.
    • Define how the fetched data maps to your ServiceNow tables and fields, including any necessary data transformations.

  4. Test Your Configuration:

    • Test the integration thoroughly to ensure data is correctly imported and transformed according to your needs.
0 Helpfuls

Jim O_Shea
Tera Expert
In response to gbdfvdfv

‎03-20-2024 11:25 AM - edited ‎03-21-2024 02:10 PM

Hello gbdfvdfv,

 

Thank you so much for the configuration instructions and apologies for my delayed response.  But when defining the data source I don't have RDS as a Type option. Since the database Format is Postgres, I've added postgres as a new choice on the Format list.  But I'm unable to attach the postgresql.xxxx.jar file to the MID server JAR file record I created. I keep getting an error "postgresql-42.7.3.jar File type not permitted or mime type does not match the file content".  I feel this is my likely problem at the moment.  

 

The database hostname is also ~ 85 characters and some are truncated in the Connection URL when I save.  I've been manually updating the Connection URL though and my updates appear to be maintained even though the server name is truncated.  I'm assuming the Connection URL is what is actually used to make the connection.

 

Thanks again for your help.

Jim

0 Helpfuls

Eric159753
Tera Contributor

‎09-18-2024 01:12 PM

Where is this JDBC for RDS type?

0 Helpfuls
Related Content