Connecting to MySQL Database

MySQL is a fully managed database service that allows users to meet database challenges and deploy cloud-native applications using an open-source database.

Astera 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 will 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.

​

A Database Connection window will open.

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

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

1. Enter the required credentials for your MySQL account:

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