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:

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

2. Prefix settings:

3. Auto rename columns Settings:

Note: