Oracle | MySQL

MySQL is an open source relational database system. MySQL uses the SQL (Structured Query Language) for querying the database.

MySQL in ADOC

ADOC provides data reliability capability for data stored in your MySQL data source. You must create a data plane or use an existing data plane to add MySQL as a data source in ADOC. Once you add MySQL as a data source, you can view the details of your assets in MySQL database in the Data Reliability tab in ADOC.

Steps to Add MySQL as a Data Source

To add MySQL as a Data source:

1. Click Register from the left pane.
2. Click Add Data Source.
3. Select the MySQL Data Source. MySQL Data source basic Details page is displayed.

4. Enter a name for the data source in the Data Source name field.
5. (Optional) Enter a description for the Data Source in the Description field.
6. Enable the Data Reliability capability by switching on the toggle switch.
7. Select a Data Plane from the Select Data Plane drop-down menu.

To create a new Data Plane, click Setup Dataplane.

8. Click Next. The MySQL Connection Details page is displayed.

9. Enter your MySQL URL in the MySQL URL field.
10. Enter your MySQL username in the Username field.
11. Enter your MySQL password in the Password field.

12. Click Test Connection. If your credentials are valid, you receive a Connected message. If you get an error message, validate the MySQL credentials you entered.

13. Click Next. The Observability Setup page is displayed.
14. Provide the name of the MySQL databases to be monitored by ADOC. To add multiple databases, click +.
15. Enable Crawler Execution Schedule: Turn on this toggle switch to select a time tag and time zone to schedule the execution of crawlers for Data Reliability.
16. Click Submit.

MySQL is now added as a Data Source. You can choose to crawl your MySQL account now or later.

You can see that a new card is created for MySQL on the data sources page. This card displays the total cost for current month, crawler status and other details of your MySQL data source.