Generic Microsoft SQL Server: Permissioning Blendo
Permissioning Blendo: In order to ensure Blendo will have access to your Microsoft SQL Server instance please make sure to white list and allow connection from the following IP addresses: 220.127.116.11/32, and 18.104.22.168/32
For more instructions please continue bellow.
Generic Microsoft SQL Server permissions
There may be the case that you host Microsoft SQL Server in a different service than AWS or Azure, In that case, you will still need to configure your firewall ports or access rules to allow Blendo to write into it.
Allow incoming connections from:
- 22.214.171.124. In case you need the CIDR version then you may add: 126.96.36.199/32.
- 188.8.131.52. In case you need the CIDR version then you may add: 184.108.40.206/32.
Now we need to add MS SQL Server as Destination Output,
Add SQL Server as Destination Output
1. Go to your Blendo Dashboard.
2. If it is the first time you log in to Blendo you will see the screen below. Click on the box with SQL Server.
If it is not the first time, you will see the screen below. Click the drop-down arrow and then click on Add database.
On the next screen, click on the box with SQL Server.
3. 3. Add your credentials to connect to Microsoft SQL Server.
- SQL Server Host
- SQL Server Port
- SQL Server Database
4. Click Validate & Save
You can also select the Schema where the data will be stored to. This is something that is done during the setup of your data warehouse but instead during the creation of a pipeline. There you can select at which Schema the data from source will be stored at (with public schema as default).
Permissioning Blendo: In order to ensure Blendo will have access to your MS SQL Server please make sure to whitelist and allow connection from these two IP addresses: 220.127.116.11/32, and 18.104.22.168/32