Step 4 (RDS): How to connect Amazon RDS Microsoft SQL Database as Data Warehouse Integration
Add Blendo Output (Destination)
A Blendo Output is any destination that you want to send your data to.
Add Amazon RDS Microsoft 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.
If it is not the first time, you will see the screen bellow. Click the drop-down arrow and then click on Add database.
On the next screen, click on the box with SQL Server.
3. Add your credentials to connect to Microsoft SQL Server.
- SQL Server Host: It will be something like [name].amazonaws.com
- SQL Server Port: Leave the default (if you haven’t changed it from your configuration)
- SQL Server Database: The name of your Microsoft SQL Server database instance.
- SSL: If you have SSL check this.
- Username: The username you chose when you setup the database
- Password: the password.
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
