Knowledge base

You may connect to your SyncHub data warehouse via a Windows ODBC Data Connection, using these simple steps. First, select your ODBC connections from your Start menu:  You can use the User or System DSN, but if in doubt, we recommend going for System:  Select the ODBC Driver for SQL Server. In our example, we have version 17 available, however other versions will likely work over time too (note: do **not** select the raw _SQL Server_ options, as these do not allow database-level access):  The server name can be obtained from your [credentials dashboard](/kb/startreporting?api=):  **Important:** Use the SQL Server Authentication option for your credentials...  **Also very important:** Make sure you provide the database name from your credentials page too:  That's it! All other options may be left as their defaults.