DBSync Cloud Replication and CDM

2022

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Shri Raksha N

Saved on

compared with

New Version Current

changes.mady.by.user Shri Raksha N

Saved on

Key

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

Available from version 6.0

DBSync Cloud Replication Rename Process

DBSync Cloud Replication allows renaming the Salesforce & MS CRM Objects & fields in Database as table & column while replicating.

...

Database

Number of Characters of Table/Column Name

Oracle

Greater than 30

MySQL

Greater than 40

Microsoft SQL Server

Greater than 50

Process to Rename

  1. First, go to the Profile Section to select the required profile.
  2. Next, go to Salesforce & MS CRM Sync Object Details tab, Table & columns with longer names will be highlighted to suggest rename.
  3. In this screen capture, there is a Salesforce & MS CRM object with a longer name. This object name is highlighted with the suggestion to rename. Once this object is selected for replication, the Rename Table field is available, in which a new name must be entered & the changes must be saved.



  4. In this screen capture, there are Salesforce & MS CRM fields with a longer name. Rename as Field(s) is available to rename.



  5. After a successful replication run, the new name for table & column will reflect in the database as shown below.



  6. This functionality is working with the previous 5x profiles as well. 
  7. Users can easily see the custom fields and Table rename from 5x Profile to the 6x Profile.
  8. Now, all the data is available in 6x versions including Column and Table rename.
  9. For all the above changes the user has to add 2 properties in the system.properties like
    1. application=salesforce
    2. adapter.type=salesforce

  10. Once these above changes are done then you can transfer the Profile data from 5x to the 6x.