DBSync Cloud Replication & CDM Version 6.x

2022

Page tree

Versions Compared

Old Version 5

changes.mady.by.user Tushar Singh

Saved on

compared with

New Version 6

changes.mady.by.user Tushar Singh

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Quick Start:

...

 Use DBSync

...

replication with different

...

databases like MySql, SQL Server, Oracle, DB2, PostgreSQL, Cassandra, Redshift, Sybase and Mongo to connect with

...

source applications like Salesforce and Microsoft CRM.

(Note: Source Apps includes Salesforce and Microsoft CRM Application)

The quickstart walks through shows how Database database to Source source applications synchronization can be performed in the same profile where in Source Applications to Database Replication source applications to database replication is configured.

DBSync Replication replication tool facilitates Database to Source Apps Replication using Control database to source apps replication using control Flag (do_sync_flag).

Log in to the DBSync

...

replication portal

Sign in to the DBSync Replication Portalreplication portal.

Fill the configuration details in

...

global settings 

Start DBSync Replication Console replication console to configure the proxy settings under the Global global settings option on the home page.

...

  1. Once, you have logged in then click to "Main Menumain menu" in the right hand top corner on the home page of DBSync Replication Portalreplication portal.
  2. Next, enter the required proxy credentials in different text boxes like proxy host, proxy port, proxy username and proxy password under the global settings section.
  3. Click on save changes button tobutton to save a global settings details.

 Figure:1

Image Modified

Create a

...

source application profile

Source Application application profile Includes Salesforce and Microsoft CRM. The Source App source app profile is created within DBSync Replication Platformreplication platform.

Follow these steps to create a profile under Source Application source application like Salesforce and Microsoft CRM.

  1. Click to "Add Profileadd profile" in the right hand-corner of the Profiles profiles section of DBSync Replication Portalreplication portal.
  2. Select, the required source name application from the drop down menu under the Product product header.
  3. Next, enter the name of the profile like Testprofile like "testprofile" under the Name name section. 
  4. Click on save changes Click on save changes button to create a new Replication Profilereplication profile.

    Figure:2

Image Modified

Source

...

application setup details

Start with Source Application source application setup details includes Salesforce and Microsoft CRM. 

The Source source setup applications details required to configure your Salesforce and Microsoft CRM credentials like "username" and "Passwordpassword". 

Follow these steps to configure your Source Application source application like Salesforce and Microsoft CRM.

  1. Click to "Salesforce and Microsoft CRM" Setup setup tab on the left hand corner in corner in the Profiles profiles section of DBSync Replication Portalreplication portal.
  2. Don't change the "Environment environment and Soap soap end details", all these details are pre-filled.
  3. Next, enter the "Usernameusername" and "Passwordpassword" credential for Salesforce and Microsoft CRM.

    Figure:3
    Image Modified

  4. "OR", "Other option for Salesforce" Click on connect to Salesforce (OAUTH) to enter Salesforce login credentials like "Usernameusername" and "Passwordpassword" to connect the Salesforce Applicationsalesforce application.

    Figure:4

    Image Modified

  5. Click on Test Connection on test connection button to validate your Source Application source application login details. 

    Figure:5

    Image Modified

  6.  Click on Save Click on save button to save your Source Apps source apps login details.

    Figure:6

    Image Modified

  7. Once completed, click on Next button next button to proceed to Database Setup database setup tab.

Configure

...

database setup details

Start with Database Setup with database setup tab, to fill all the necessary details and follow the same procedure for testing and validating your Database database credentials.

Follow these steps to configure your Database database credentials with different databases like MySQLMySql, SQL Server, Oracle, DB2DB, PostgreSQL, Cassandra, RedShift, Sybase and MongoMongoDB.

  1. Click to "Databasedatabase" Setup setup tab on the left hand corner in corner in the Profiles profiles section of DBSync Replication Portalreplication portal.
  2. Select, the required "Type nametype name" from the drop down menu options like "MySql, SQL Server, Oracle, DB2DB, PostgreSQL, Cassandra, RedshiftRedShift, Sybase and MongoMongoDB" under  under the "Database Setupdatabase setup" section.
     

    Figure:7

    Image Added
    (Note: The  The database URL can also can also be entered manually if you know your database Connection database Connection string.)
    Image Removed

  3. To start with Database database credentials user has to entered all the configuration details like Host host, Portport, Usernameusername, Passwordpassword, Database Name database name and Schemaschema.
  4. Once, all the details enter by the user then URL details will get autofilled. (Note: The database URL can also be entered manually if you know your database Connection string.) 
  5. Click on Test test Connection button to validate your Source Application source application login details. 
  6. Click on Save on save button to save your Source Apps source apps login details.
  7. Once completed, click on Next button next button to proceed to Advanced Settings tab to write to advanced settings tab to get the email Id to get the Notificationsthe notifications.

 Note       Note: 

Advanced

...

settings tab

...

details

Start with Advanced Settings 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.

  1. Click to "Advancedadvanced"  Settingssettings tab on the left hand corner in corner in the Profiles section of DBSync Replication Portalreplication portal.
  2. Mark the checkbox to "Enable Database enable database logging" to create auto created table in the database.
  3. Next, Mark the checkbox of checkbox of "Email email only on Errorerror" to get an email message when error will occur.
  4. Enter an email for for "Email Recipientemail recipient" to get the notification when any run command is executed.
  5. Click on Save save button to save your Advanced advanced settings details.
  6. Once the process is completed then click on Save & Next buttons to on save and next button to proceed further.

Figure:8

Image Modified


Source Application Objects tab

Start with Source Application Objects tab, to get synced all the objects when user will get connected to different source applications like Salesforce/Microsoft CRM.

Follow these steps to synced all objects for source application like Salesforce and Microsoft CRM.

  1. Click to "Objectsobjects" tab on the left hand corner in corner in the Profiles section of DBSync Replication Portalreplication portal.
  2. Once, user has connected to source applications like Salesforce and Microsoft CRM then objects will get synced and it will show on the Objects objects tab.
  3. Select any  Source Apps objects you want to sync into Database "source apps objects" you want to sync into database from the left Objects objects section as shown below.
    Figure:9



  4. Select the object fields you want to sync into Database database from the"Available Fieldsavailable fields"section and use"Exclude Fieldsexclude fields"section to section to filter out fields you don't want to sync into Databasedatabase. 
    Figure:10

    Image Modified

  5. Once completed, click on the "Run button" to Run the configuration for the Source Apps object.
  6. Run menu to select the required commands like Update Database Schema, Source Apps to Database update database schema, source apps to database (Clean Copy), Source Apps source apps to Database database (Incremental) to execute.
    As per the above commands options, user has to select the Database database to Source source command to replicate all the sync objects to their Source Applicationssource applications.
     Figure:11

    Image Modified
    Image Removed

  7. Include required control flags in the column do_sync_flag of Database database table where in Source App  source app data is already stored during previous runs for Source App to Database Replication. source app to database replication.
    Selection of control fags shown in the below table is illustrated with example in the topic topic do_sync_flag.
    Figure:12

    Image Added

    Values

    Description

    Y

    The record has been synchronized between Source Apps and Database

    S

    A request from an external system to indicate that the record needs to be synchronized from Database to Source Apps

    D

    Indicates that the record was deleted in Source Apps.

  8. Once user has selected and "Runrun" the Commandcommand, then it will redirect to user on the Log Screen Tab log screen tab to see the status of command is completed or not.

Configure

Scheduler Jobs

schedule jobs tab

Start with Scheduler Jobs tab, here users can schedule the sync using Scheduler Tab.

Follow these steps to schedule the sync using Scheduler tab with scheduler functionality like run commands options, Date, Month and year format settings and repeat Drop-down menu details to set   the desired duration to sync the selected objects.

  1. Click to "Scheduler Jobsscheduler jobs" tab on the left hand corner in the Profiles section of DBSync Replication Portalreplication portal.
  2. Once, user has connected to source applications like Salesforce and Microsoft CRM then objects will get synced and user can directly select select the required Process from the Command Dropprocess from the command drop-down and configure the frequency of the sync by selecting a desired duration from the Repeat the Repeat drop-down menu.
  3. Next, "Start Onstart on"  option to to select the Datethe date, Month month and Year from the Drop-down menu to year from the drop-down menu to get the objects synced for particular Date and Month format.
  4. Create a task in the   "task section" with  with all the details including Task Name task name, Actionaction, Command and Start Date and Timecommand and start, date and time.
  5. Once the process is completed then click on Save & Next buttons on save and next button to proceed further.

           Figure: 12

Image Modified