Salesforce to Azure SQL database by COZYROC

Elevate your data integration to new heights with this COZYROC gem which effortlessly transfers Salesforce objects with your desired SQL Server tables for seamless data management and analysis.

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 Salesforce and the desired Azure SQL database instance. Once the connection is established, the gem will then pull the data from each Salesforce object specified in the Mapping parameter and send each object data to its allocated table in the Azure SQL database.

When specifying values for the Mapping parameter, please follow the format: ObjectName:"Schema"."TableName". The ObjectName and Schema.TableName are separated by a colon (:).

For example: Contact:"dbo"."tbl_Contact"

Ensure that you provide the correct object name for Salesforce, and enclose the schema and table names in double quotes.

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

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

Salesforce

• Server URL Required. Specify the Salesforce service URL.
• Username Required. Specify a username in an email-like format.
• Password Required. Specify a password to access the Salesforce service.
• Security Token Required. Specify your Salesforce service security token.
• Object List Required. This parameter accepts comma-separated values if you want to pull data from multiple Salesforce objects, e.g. Account, Contact, Case, etc.
• Batch Size Required. The default batch size is set to 200.

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 Salesforce objects and send each object data to its allocated table in the Azure SQL database, e.g. Contact:"dbo"."tbl_Contact" etc.