Step 1 (RDS): Connect Amazon RDS Microsoft SQL Server

This guide will explain a) how to create an Amazon RDS Microsoft SQL Server Instance. Then we will see b) how to connect your Amazon RDS Microsoft SQL Server instance as a Destination to Blendo in order to send your data.

We will see:

  1. How to set up a Microsoft SQL Server in Amazon Relational Database Service (RDS) database.
  2. Configure firewall settings to allow Blendo to send data to your RDS MS SQL Server.
  3. Connect RDS Microsoft SQL Server as a destination in Blendo.

What is Amazon Web Services (AWS)?

Amazon Web Services (AWS) is a secure cloud services platform, offering compute power, database storage, content delivery and other functionality to help businesses scale and grow. Explore how millions of customers are currently leveraging AWS cloud products and solutions to build sophisticated applications with increased flexibility, scalability, and reliability.

What is Amazon Relational Database Service (Amazon RDS)?

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, resizeable capacity for an industry-standard relational database and manages common database administration tasks.

Note: As a supplement to this guide, Amazon has created an official guide to setting up a Microsoft SQL Server.

Questions? Contact us!

in MS SQL Server