Generic Microsoft SQL Server: Permissioning Blendo

This guide considers that you already have a Microsoft SQL Server instance setup behind a firewall and connected in the network.

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: 52.18.126.160/32, and 52.213.36.20/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:

  • 52.18.126.160. In case you need the CIDR version then you may add: 52.18.126.160/32.
  • 52.213.36.20. In case you need the CIDR version then you may add: 52.213.36.20/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.

ETL data into your data warehouse

If it is not the first time, you will see the screen below. Click the drop-down arrow and then click on Add database.

Load data into Google BigQuery

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
  • SSL
  • Username
  • Password

Setup Azure MS SQL Server Integration

4. Click Validate & Save

Schema Selection

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: 52.18.126.160/32, and 52.213.36.20/32

Questions? Contact us!

in MS SQL Server