Cloud Replication
v7
v7
  • Introduction
  • Installation
    • Windows
    • Windows Zip
    • Linux
    • Increase Heap Memory
  • Key Features
    • Filter Criteria
    • Formula Field Update
    • Rename Table or Column
    • do_sync_fl
    • Salesforce Field Selection
    • Log Event Notification
    • Scheduler For Replication
    • Global prefix for Table & Column names
    • Outbound Message Setup
    • Alter Field Size in Database
    • Replication Web API
    • Cron- functionality
    • Datamasking
    • Force Property
    • Overriding Database's Datatypes
  • Security Architecture
  • Tomcat
    • Security for Tomcat Setup
  • Utilities
    • Command Line
      • testconnection
      • showlicense
      • downloadlicense
      • diffschema
      • Describe
      • verifypasswd
      • chpwd
    • Upgrade Utility
      • Run Upgrade Utility on Linux
  • Bigdata Support
    • Archive and Non-archive Mode
  • AWS Redshift
    • Amazon Redshift
    • Datapipeline
  • Azure Synapse
  • Azure Datalake Gen2
  • MINIO
  • File Replication
    • Enable and Run File Replication
  • salesforce replication
    • Introduction
    • Getting Started
    • Core Concepts
    • Running Salesforce Replication
      • Salesforce Setup
      • Database Setup
        • Azure Active Directory
      • Objects
      • Restore
      • Schedule Jobs
      • Notifications
        • Email
        • Webhooks
          • Webhooks Setup for Microsoft Teams
      • Logs
      • Metadata
      • Batch Mode
  • Dynamics 365 CRM Replication
    • Introduction
    • Getting Started
    • Running Replication
      • Dynamics 365 CRM Replication Setup
      • Configure Database
      • Configure Objects
      • Scheduling Jobs
  • Salesforce HealthCloud Replication
    • Introduction
    • Core Concepts
    • Getting Started
    • Running Salesforce Health Cloud Replication
      • Salesforce HealthCloud
      • Database
        • Azure Active Directory Setup Process
      • Objects
      • Restore
      • Schedule Jobs
      • Notifications
        • Email
        • Webhooks
      • Logs Screen
  • More information
    • Troubleshooting
      • Tomcat
      • Out of Memory Exception
      • Mismatch in Datasize
      • Unable to Create Sequence in Oracle DB
      • Single File Logging
      • Row Size greater than 64kb in MySQL
      • Secure your App using credentials
      • Update Salesforce/MS CRM Org ID
      • Incorrect Syntax Near Column Name
      • SSL Configuration in DBSync Tomcat
Powered by GitBook
On this page
  • DBSync Cloud Replication Rename Process
  • Process to Rename
  1. Key Features

Rename Table or Column

PreviousFormula Field UpdateNextdo_sync_fl

Last updated 1 year ago

DBSync Cloud Replication Rename Process

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

This function is applicable only when the name is too long for the database.

The number of characters in the table name & column name to rename varies from database to database as mentioned below. If the object with longer name is not provided with new name, the object will not be replicated. If the column with a longer name is not provided with the new name, the existing name will be shortened to fit the database column name.

Steps involved to use this feature are mentioned in this section.

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.

  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.