2022

Page tree

Versions Compared

Key

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

...

Follow these steps to configure your database credentials with different databases like MySql, SQL Server, Oracle, DB, PostgreSQL, Cassandra, AWS Redshift, Snowflake, Sybase, and MongoDB.

...

  • Login to DBSync Cloud Replication instance

Image Removed

  • Configure Database

Image Removed

  • To configure, navigate to the Database tab.
  • Click Database icon from the top-navigation toolbar
  • To start with database credentials the user has to enter all the configuration details like host, port, username, password, database name, and schema.
  • Once, all the details entered by the user then URL details will get auto-filled. 

Image Removed

  • Click Save 

  • A pop-up confirming the Connection is Saved will appear on the screen

Image Removed

  • Click Test Connection

  • A pop-up confirming the connection is established will appear on the screen.

Image Removed

  • Click Next

  • You will be redirected to configure salesforce objects

...

  • You can save and test your Database connection.

  • Click Next

Note: 

If 'SSL Encryption' is enabled for SQL DB.
We need to add the "?ssl=true&sslmode=require;" parameter at the end of the JDBC URL.


Example:- jdbc:sqlserver://Test.com:30333;database=InstCRM_OnPrem;integratedSecurity=true;?ssl=true&sslmode=require;


Advance Settings:

This Tab primarily focuses on 3 advanced settings:

  1. File Download

Image Removed

  • Click the checkbox next to download as local files to download into your local system

  • The URL for download file directory is provided 

  • Click the checkbox next to Keep Multiple Version of Files this will assist in keeping multiple version of the files when downloading (Will rename older version before downloading new ones) 

...

  • Include a prefix if required and enter the prefix details in the table below which will get populated into the database.

Image Removed

3. Auto rename columns Settings:

  • This setting is used when you have objects or tables with more number of characters than the limit which is allowed by the database. For eg: Oracle Database allows for only 30 characters in custom fields of Salesforce and any characters exceeding that will get dropped automatically in your database. To avoid this, activate this setting in your DBSync Cloud Replication instance where any extra characters can be truncated and replaced with recognisable characters to differentiate between same database names. 

  • Click the check box next to enable auto rename columns and it will automatically update names of any objects in your Salesforce instance to be within the character limit to avoid deletion. 

Image Removed

Note:

...