Connecting to Amazon Aurora Database (MySQL and PostgreSQL)

Amazon Aurora is a fully managed relational database engine that is compatible with MySQL and PostgreSQL. It is part of Amazon’s Relational Database Service (Amazon RDS), a managed database web service that makes it easier to set up, operate, and scale a relational database in cloud.

To learn more about Amazon Aurora. click here.

In Centerprise 8.3, users can connect with Aurora MySQL and Aurora PostgreSQL as one of their database source or database destination. However, the connectivity is not just limited to a source or a destination object. Transformation objects such as DB lookup and SQL Statement Lookup as well as Database Write Strategies in dataflows and Run SQL Script task in a workflow can easily establish a connection with Amazon Aurora databases.

In this document, we will see how Aurora MySQL and Aurora PostgreSQL can be configured as a database source in Centerprise.

Connecting to Aurora MySQL

1. Drag and drop the Database Table Source onto the dataflow designer. Right-click on the object’s header and select Properties from the context menu.

![database table source](connecting-to-amazon-aurora-database.assets/database table source.gif)

A Database Connection window opens up. Here, we need to provide details to set up a connection with the required database.

0_DatabaseConnection

2. On this screen, there is a drop-down list next to the Data Provider option. Select Aurora MySQL as the data provider from this list.

1_DataProvider_AuroraMySQL

The credential options to set up a connection with the Aurora MySQL database such as User ID, Password, Server Name and Schema work exactly like the standard credentials required to connect with an SQL Server Database.

3. Fill in the required credentials for Aurora MySQL data provider account.

4_Credentials_Database

Click on Test Connection button to make sure that the database connection is successful and click OK.

8_TestConnection_AuroraMySQL

The connection to Aurora MySQL database has been successfully established.

The next step is to pick a source database table, or a destination database table in case of a Database Table Destination object, from Aurora MySQL by specifying data reading options on the next screen.

9_PickTable

Click here to learn about these options in detail.

Connecting to Aurora PostgreSQL

1. On the Database Connection window, select Aurora PostgreSQL from the Data Provider drop-down list.

2_DataProvider_AuroraPostgreSQL

The credential options to set up a connection with the Aurora PostgreSQL database such as User ID, Password, Server Name and Schema work exactly like the standard credentials required to connect with an SQL Server Database.

3. Fill in the required credentials for Aurora PostgreSQL data provider account.

6_Credentials

Click on Test Connection option to make sure that the database connection is successful and click OK.

7_TestConnection_AuroraPostgreSQL

The connection to Aurora PostgreSQL database has been successfully established.

The next step is to pick a source database table, or a destination database table in case of a Database Table Destination object, from Aurora PostgreSQL by specifying data reading options on the next screen.

9_PickTable

Click here to learn about these options in detail.

This concludes connecting to Microsoft Aurora (MySQL and PostgreSQL) in Astera Centerprise.