Knowledge base

By default, SyncHub will provide you with a cloud hosted warehouse at no cost. However, there are many reasons why you may wish to use your own:

• reduced latency
• co-location with other data warehouses used by your business
• compliance or government regulation
• access to rich data warehousing tools, such as views, triggers, stored procedures & indexes

We have an excellent write up on our BYOD functionality here, if you're interested.

Configuring your database

First of course, you need your own database. Currently SyncHub supports only SQL Server, SQL Azure and Postgres

The database can remain empty at this point

Whitelist our IP address

SyncHub works by extracting information from cloud platforms, then pushing it into your database.

Please make sure you whitelist our IP address, 20.190.109.128 on your database firewall.

Create an admin user

Create a new user with the following permissions:

• create/modify schemas
• create/modify tables
• select/update/delete/create data permissions

This is the account that SyncHub will use to dynamically create your tables, as well populate the data. When you provide us with these credentials, we encrypt them in our database and do not share them anywhere on the site (not even back to you).

Create a reporting user

Create a second user with read-only permissions across the database. These credentials are provided to other users in your site, when they want to obtain a login from your SyncHub Dashboard.

SyncHub itself may also use these credentials to execute ad-hoc read-only queries, such as your data preview.

Register your warehouse with us

Visit your Connection Dashboard, and create/edit your server, entering the credentials etc that you have created above.