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 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 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.