Connecting to Amazon RDS Databases

Amazon RDS is a web service that manages secure relational databases in the cloud. It is easier to set up, operate, and scale a relational database in the cloud through Amazon Web Services data centers. It provides a cost-effective, resizable capacity for an industry-standard relational database for administering tasks that include computing, analysis, storage, and data networking.

Amazon RDS takes over many of the tedious and challenging management tasks of a relational database and makes it easy to administer, scalable, durable, fast, and secure. Astera provides native connectivity to Amazon RDS databases.

Data can be retrieved from and written to Amazon RDS databases through various database objects in Astera such as Database Table Source, Database Table Destination, Database Lookup, SQL Query Lookup, SQL script task in a workflow, and Database Write Strategies.

Amazon RDS is available on several database instance types and provides you with six familiar database engines to choose from. Astera provides connectivity to the following Amazon RDS databases:

1. Amazon Aurora

2. PostgreSQL

3. MySQL

4. MariaDB

5. Oracle Database

6. SQL Server

All of them can be connected to by following the same steps in Astera:

Steps to Connect to Amazon RDS Databases in Astera

In this example, we will establish connection with a MySQL database in Amazon RDS through the Database Table Source object in Astera.

To learn more about using a Database Table Source object, click here.

1. Go to the Properties of a Database Table Source object by right-clicking on the object’s header and selecting Properties from the context menu. This will open the Database Connection window on your screen.

1. Here, you will find a drop-down list next to the Data Provider option.

Select MySQL as your data provider from the list.

1. Now, enter the following required credentials for your MySQL database account in Amazon RDS:

• User ID

• Password

• Server Name

• Database

• Port

1. Test Connection to make sure that the database connection is successful and click OK.

The connection to MySQL database in Amazon RDS has been successfully established. You can now pick a source table on the next screen from Amazon RDS database and use that data in your dataflow in Astera.

To learn more about how to pick a table from a database source and specify other data reading options, click here.

You can connect to Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, and SQL Server databases in Amazon RDS by following the same steps as for any database object in Astera.

This concludes connecting to Amazon RDS databases in Astera.