Use DBSync Replication with different source apps (Salesforce/Microsoft CRM) to connect a database.
Source Apps includes Salesforce and Microsoft CRM Application
The quickstart walks through how to create profile under different source applications like Salesforce and Microsoft CRM. The DBSync replication is offering you to connect the source apps like Salesforce and Microsoft CRM with different databases like MySql, SQL Server, Oracle, DB2, PostgreSQL, Cassandra, Redshift, Sybase and MongoDB.
This quickstart shows you how to get started by creating a profile under source applications and how to replicate the data with the help of DBSync from source applications to different databases.
Sign in to the DBSync Replication portal.
Start DBSync Replication console to configure the proxy settings under the global settings option on the home page.
Follow these steps to configure a proxy global settings in DBSync replication portal.
Once, you have logged in then click to "main menu" in the right hand top corner on the home page of DBSync replication portal.
Next, enter the required proxy credentials in different text boxes like proxy host, port, username and password under the global settings section.
Click on save changes button to save a global settings details.
Source application profile Includes Salesforce and Microsoft CRM. The source app profile is created within DBSync Replication platform.
Follow these steps to create a profile under source application like Salesforce and Microsoft CRM.
Click to "add profile" in the right hand-corner of the profiles section of DBSync replication portal.
Select, the required source name application from the drop down menu under the product header.
Next, enter the name of the profile like "testprofile" under the name section.
Click on save changes button to create a new replication profile.
Start with source application setup details includes Salesforce and Microsoft CRM.
The source setup applications details required to configure your Salesforce and Microsoft CRM credentials like "username" and "password".
Follow these steps to configure your source application like Salesforce and Microsoft CRM.
Click to "Salesforce and Microsoft CRM" setup tab on the left hand corner in the profiles section of DBSync Replication portal.
Don't change the "environment and soap end details", all these details are pre-filled.
Once completed, click on next button to proceed to database setup tab.
Start with advanced settings tab, to fill all the necessary details and follow the same procedure for testing and validating Advanced settings credentials.
Follow these steps to configure your Advanced settings credentials.
Click to "advanced" settings tab on the left hand corner in the Profiles section of DBSync replication portal.
Mark the checkbox to "enable database logging" to create auto created table in the database.
Next, Mark the checkbox of "email only on error" to get an email message when error will occur.
Enter an email for "email recipient" to get the notification when any run command is executed.
Click on save button to save your advanced settings details.
Once the process is completed then click on save and next button to proceed further.
Figure:8
If Database Logging is enabled, SFLOG_C table will be auto created in the database which will have useful details like timestamp and the log details as shown below.
Next, enter the "username" and "password" credential for Salesforce and Microsoft CRM.
"OR", "Other option for salesforce" click on connect to Salesforce (OAUTH) to enter Salesforce login credentials like "username" and "password" to connect the salesforce application.
Click on test connection button to validate your source application login details.
Click on save button to save your source apps login details. Figure:6
When the replication is performed notification email will be sent which will have the notification details as shown below. Figure:9
