Knowledge base

You can connect to your SyncHub data warehouse via a Windows ODBC Data Connection, using these simple steps.

First, you'll need to get your database credentials.

Next, select your ODBC connections from your Start menu:

You can use the User or System DSN, but if in doubt, we recommend choosing for System:

Select the ODBC Driver for SQL Server. In our example, we have version 17 available, however, other versions should work as well. Note:

• do not select the raw SQL Server options, as these do not allow database-level access)
• if you don't see an option for ODBC Driver for SQL Server, then you may download the latest ODBC drivers from Microsoft

Enter the server name obtained from your database credentials:

Important: Use the SQL Server Authentication option for your credentials…

Also very important: Make sure you provide the database name obtained from your database credentials too:

That's it! All other options may be left as their defaults.