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). But in short: ### Configuring your database First of course, you need your own database. Currently SyncHub supports only Sql Server or Sql Azure 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 your firewall permits our server IP addresses. SyncHub is scaled across multiple servers, so there are a number of them: 114.23.236.250 114.23.253.116 40.127.75.163 40.115.64.29 23.101.229.206 13.77.50.96 23.101.237.98 40.115.70.133 23.101.225.17 40.127.64.147 40.127.75.163 40.115.64.29 23.101.229.206 203.167.168.166 ### Create a 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, plus populate the data. ### Register your warehouse with us Visit your Connection Dashboard, and create/edit your server, entering the credentials etc that you have created above.