Version: 1.0.0
Category: Database
Tier: 2
Type: Source, Target
Authentication:
Standard Authentication:
Host
Port
Schema
Username
Database name
Password
Supported Save Mode as Target:
Append
Overwrite
See: Target Connector Save Modes
Connection Properties:
Name | Mandatory | Description |
|---|---|---|
Connection Name | Yes | Name of the connection |
Description | No | Description of the connection |
Host Name | Yes | Host or “Endpoint“ |
Port | Yes | Port number |
Schema | No | Name of schema in the database |
Database | Yes | Name of the database for the connection |
Username | Yes | Username of the database |
Password | Yes | Password of the database |
AWS RDS SqlServer connector user guide:
AWS RDS SqlServer connector user guide
Log in to your AWS account console.
On the search bar type RDS and select the RDS service
Once you are in the RDS service page, Click on Databases tab on the side bar to see all your databases.
Select your RDS SQL SERVER database
To Connect your Database to EazyDi app, you will need:
Host
Port
Username
Database name
Password
Once you have clicked your RDS SqlServer database, You will see the “ENDPOINT” which will be your HOST. And the PORT number
To Get your USERNAME and DATABASE NAME, go to the “CONFIGURATION” Tab and there you will see your DBNAME and MASTER USERNAME which you will use as your USERNAME and DATABASE NAME
Once you have all your credentials, you can now connect your database to EazyDi app. Create a connection. Select the AWS RDS SQL SERVER connector
Input all the required connection properties that you got from Step 6 and 7. The Host, Port, DBNAME, Master Username. The password is the one you set when creating your database. *Note that you will input the DBNAME in the “Database” field
Once you have created a connection, you can now select a table from the list of connection objects