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.