ServiceNow data to Azure SQL database by COZYROC

This gem ensures that data stored in ServiceNow can be seamlessly transferred to Azure SQL Database for further processing, reporting, or analytics, leveraging the strengths of both platforms.

This gem will require you to connect and expose your Azure SQL Database to the COZYROC Cloud for seamless data integration and management. To find out how to expose your Azure SQL database to COZYROC Cloud, please refer to KB Article Expose Azure SQL Database to COZYROC Cloud

Setup Guide

This gem will establish a connection between ServiceNow and the desired Azure SQL database instance. Once the connection is established, the gem will then pull the data from each ServiceNow table specified in the Mapping parameter and send each table data to its allocated table in the Azure SQL database.

When specifying values for the Mapping parameter, please follow the format: NowTableName:"SqlSchema"."SqlTableName". Here the NowTableName and SqlSchema.SqlTableName are separated by colon (:).

For example: Incident:"dbo"."tbl_Incidents"

Note: This gem will assume that the destination tables are already created.

To run this gem and connect ServiceNow to the Azure SQL database instance, you need to configure the parameters that are mentioned below.

ServiceNow

• Server Host Required. Specify the correct instance in the server host URL.
• Username Required. Specify the username.
• Password Required. Specify the password.
• Batch Size Required. The default is set to 200.
• Query Parameter Optional. Multiple query parameters are separated by a new line.

Azure SQL Database

• Server Name Required. Specify the server name.
• Database Required. Specify the database name.
• Username Required. Specify the username.
• Password Required. Specify the password.

Mapping

• Mapping Required. This parameter accepts comma-separated values if you want to pull data from multiple ServiceNow tables and send each ServiceNow table data to its allocated table in the Azure SQL database, e.g. Incident:"dbo"."tbl_Incident" etc.