Message-ID: <131744551.86177.1711715789583.JavaMail.wiki@ip-172-26-1-188> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_86176_1029364044.1711715789581" ------=_Part_86176_1029364044.1711715789581 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Database Setup

Database Setup

Start with the database setup= tab, to fill all the necessary details and follow the same procedure for t= esting and validating your database credentials.

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

To set up you salesforce inst= ance follow the steps below:

Note: 

If 'SSL Encryption' is enabled for SQL DB.We need to add the "?ssl=3Dtrue&sslmode=3Drequire;" parameter at the e= nd of the JDBC URL.


Example:- jdbc:sqlserver://Test.com:30333;data= base=3DInstCRM_OnPrem;integratedSecurity=3Dtrue;?ssl=3Dtrue&sslmode=3Drequire;


Advance Settings:

This Tab primarily focuses on 3 advan= ced settings:

  1. File Download

2. Prefix settings:

3. Auto rename columns Settings:<= /strong>

  • 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 cha= racters in custom fields of Salesforce and any characters exceeding that wi= ll get dropped automatically in your database. To avoid this, activate this= setting in your DBSync Cloud Replication instance where any extra characte= rs can be truncated and replaced with recognisable characters to differenti= ate between same database names. 

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

Note:

 

------=_Part_86176_1029364044.1711715789581--