Servicenow Integration with Snowflake

balaji_charapal
Kilo Guru

Hi experts,

Did any one integrated ServiceNow with Snowflake?

I have referred couple of articles but i didnt fined relative information

GitHub - ajclark/snowflake: A super simple gem to interact with service-now.com configuration databa...

ServiceNow and Snowflake Integration — ServiceNow Query Component

Really appreciate your inputs.

Regards,

Balaji

7 REPLIES 7

pavelmuller
Tera Contributor

Snowflake is directly supported by SnowMirror replication tool:

https://www.snow-mirror.com/

You can replicate selected tables directly to Snowflake.

ElijahStownton
Tera Contributor

Yes, integration between ServiceNow and Snowflake is possible. This can be achieved by using platforms like Skyvia, which offer cloud data integration services to seamlessly connect and synchronize data between these two systems.

Rajdeep Ganguly
Mega Guru


Yes, ServiceNow can be integrated with Snowflake. Here are the steps to integrate ServiceNow with Snowflake:

1. **Create a Snowflake Account**: If you don't have a Snowflake account, create one.

2. **Create a ServiceNow Instance**: If you don't have a ServiceNow instance, create one.

3. **Create a JDBC Data Source in ServiceNow**:
- Navigate to System Import Sets > Administration > Data Sources.
- Click on New to create a new data source.
- Select JDBC as the type.
- Fill in the necessary details such as Name, JDBC URL (which should be your Snowflake account URL), User name, and Password.

4. **Create a Transform Map in ServiceNow**:
- Navigate to System Import Sets > Administration > Transform Maps.
- Click on New to create a new transform map.
- Fill in the necessary details such as Name, Source table (which should be the table from your Snowflake database), and Target table (which should be the table in ServiceNow where you want to import the data).

5. **Run the Import**:
- Navigate to System Import Sets > Load Data.
- Select the data source you created.
- Click on Load Data.

6. **Verify the Data**:
- Navigate to the target table in ServiceNow.
- Verify that the data from Snowflake has been imported successfully.

Please note that this is a basic integration and might need to be adjusted based on your specific requirements. Also, you need to have the necessary permissions in both ServiceNow and Snowflake to perform these actions.

Please note that the JDBC URL for Snowflake should be in the following format: jdbc❄️//.snowflakecomputing.com/?db=