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 Centerprise provides native connectivity to Amazon RDS databases. Data can be retrieved from and written to Amazon RDS databases through various database objects in Centerprise 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 Centerprise provides connectivity to the following Amazon RDS databases:

1. Amazon Aurora

2. PostgreSQL

3. MySQL

4. MariaDB

5. Oracle Database

6. MySQL

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

Steps to Connect to Amazon RDS Databases in Astera Centerprise

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

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.

img

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

Select MySQL as your data provider from the list.

img

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

  1. User ID
  2. Password
  3. Server Name
  4. Database
  5. Port

img

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

img

img

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 Centerprise.

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, MariaDB, Oracle Database, and SQL Server databases in Amazon RDS by following the same steps as for any database object in Astera Centerprise.

This concludes connecting to Amazon RDS databases in Astera Centerprise.

Additional Reading Links:

Connecting to MySQL Database in Astera Centerprise

Connecting to PostgreSQL Databases in Astera Centerprise

Connecting to MariaDB Databases in Astera Centerprise

Connecting to Amazon Aurora Databases in Astera Centerprise

Connecting to Oracle Database in Astera Centerprise