Knowledge base

To connect your SyncHub data to Microsoft Excel, simply setup a new Database Connection:

Select Data -> Get Data -> From Sql Server Database from the main ribbon:

Connect to Sql Server Database

Log in to SyncHub to obtain the connection details to your data warehouse:

Connect to Sql Server Database

Enter your server credentials when prompted:

Enter server credentials

Make sure you select Database as your crentials method, then enter the username/password for your data warehouse:

Connect to Sql Server Database

Select the table you wish to import:

Select table

And voila - here is your data!

Select table

Excel will keep your data up to date - no more copy/pasting!