Start with the database setup tab, to fill all the necessary details and follow the same procedure for testing and validating your database credentials.
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.
To set up you salesforce instance follow the steps below:
Login to DBSync Cloud Replication instance
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.
Click Save
You can save and test your Database connection.
Click Next
Note:
Advance Settings:
This Tab primarily focuses on 3 advanced settings:
File Download
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)
2. Prefix settings:
Include a prefix if required and enter the prefix details in the table below which will get populated into the database.
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.
Note:
While replicating with Amazon Redshift database, please refer to the following wiki link for specific details on Replication with Amazon Redshift. http://help.mydbsync.com/docs/display/CloudReplication/Amazon+Redshift
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;
