Connecting to MySQL Database

MySQL is a fully managed database service that allows users to meet databases challenges and deploy cloud-native applications using an open source database. Astera Centerprise offers native connectivity for MySQL databases at both source and destination points. The connectivity also extends to other objects such as Database Lookup, SQL Query Lookup, SQL script task in a workflow, and database write strategies.

In this article, we will see how we can connect to MySQL as a database source in Centerprise. To establish the connection, we’ll be using the Database Table Source object.

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

01

A Database Connection window will open.

02

This is where you configure the properties to establish the connection with the database.

2. On the Database Connection screen, you will find a drop-down list next to the Data Provider option.

Select MySQL as your data provider from this list.

03

  • Put in the required credentials for your MySQL account.

04

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

05

The connection to MySQL as your database provider has been successfully established. You can now pick a source table from MySQL database and use that data in your dataflow.

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

This concludes connecting to MySQL databases in Astera Centerprise.