Step 4 (Azure): How to connect Windows Azure MS SQL Database as Data Warehouse Integration

This guide will explain how to connect your Windows Azure MS SQL Server Database instance to Blendo in order to send your data.

Not a database yet? Read how to setup a Windows Azure MS SQL Server

If you have problems connecting check again your access permissions by reading how to setup the Windows Azure MS SQL Server permissions in our documentation.

It will take only a few minutes to connect and send your data to Azure MS SQL Database. Blendo makes it easy to send your transactional, marketing and sales data to any source from to Google BigQuery, to Postgres, to Amazon Redshift.

Add Blendo Output (Destination)

A Blendo Output is any destination that you want to send your data to.

Add Windows Azure MS SQL Server as Destination Output

Permissioning Blendo: In order to ensure Blendo will have access to your MS SQL Server please make sure to white list and allow connection from these two IP addresses: 52.18.126.160/32, and 52.213.36.20/32
If you need help go here.

Add SQL Server as Destination Output

1. Go to your Blendo Dashboard.

2. If it is the first time you login to Blendo you will see the screen bellow. 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 bellow. 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: For our example this will be the gandalfxero.database.windows.net
  • SQL Server Port: Leave the default
  • SQL Server Database: For our example this will be Myxerodb
  • SSL: In our example we do not use SSL, so leave it blank. NOTE: It is advisable to have SSL!
  • Username: For our example it is testusr
  • Password: the password
  • *Export table prefix: It is not mandatory, I used myxero_ for me to know which tables will be created inside the SQL database.

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 white list and allow connection from these two IP addresses: 52.18.126.160/32, and 52.213.36.20/32

Done that! Now What?

You may now connect data sources with it. Blendo will sync all your data from these data sources into your data warehouse.

 

Questions? Contact us!

in MS SQL Server