2024 is the year of the connector - vote here

Knowledge base

Bring your own database

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](https://blog.synchub.io/articles/bring-your-own-database), 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, **** 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.