Syncplicity Support

Search our knowledgebase to get the help you need, today


Database connection strings

DataHub supports SQL Server, PostgreSQL, Oracle, and MySQL databases. For complex database scenarios, DataHub allows you to supply the connection string with the applicable options and format necessary for your database environment. However, these connection strings can be modified with additional platform parameters and values. See below for examples

If connectivity to the database cannot be made with default database configuration options, it may be necessary to utilize the connection string to specify the correct parameters.

  • As an example, it is a common enterprise practice to change the default SQL Server port from 1433 to another port; therefore, requiring the use of a connection string

SQL Server Connection Strings

SQL Server | Integrated Authentication (Windows Authentication)
Server=MySqlServer;Database=SkySyncV4;Integrated Security=true
SQL Server | Use Specific Credentials (SQL Authentication)
Server=MySqlServer;Database=SkySyncV4;User ID=myUsername;Password=MyPassword
SQL Server | Always On - Availability Group Listener with Multi-Subnet
Azure SQL DB Standard Connection
Server=tcp:[serverName];Database=SkySyncV4;User ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False;Encrypt=True

PostgreSQL Connection Strings

PostgreSQL Standard Connection
dbProvider=npgsql,dbConnectionString=User ID=myPostgreSqlUser;Password=MyPassword;Host=myServerName;Port=5432;Database=SkySyncV4

Oracle Connection Strings

Oracle | Integrated Authentication (Windows Authentication)
Data Source=MyOracleServer;Integrated Security=yes

MySQL Connection Strings

MySQL Standard Connection
Powered by Zendesk