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
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:
Click Save =
You can save and test your Database= connection.
Click Next
Note: = p>
If 'SSL Encryption' is enabled for SQL DB. 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:
File Download= p>
Click the checkbox next to = span>download as local files to download into your local= system
The URL for download <= span>file directory is provided
Click the checkbox next to = span>Keep Multiple Version of Files this will assist in = keeping multiple version of the files when downloading (Will rename older v= ersion before downloading new ones)
2. Prefix settings:
Include a prefix if required = and enter the prefix details in the table below which will get populated in= to the database.
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:
= While replicating with Amazon Redshift database, please refer to the follow= ing wiki link for specific details on Replication with Amazon Redshift. http://help.mydbsync.com/docs/display/CloudRep= lication/Amazon+Redshift