> ## Documentation Index
> Fetch the complete documentation index at: https://docs.skypoint.ai/llms.txt
> Use this file to discover all available pages before exploring further.

#  

# Connecting to MySQL

MySQL is a reliable, high-performance open-source database with cross-platform support for seamless deployment across operating systems. It offers robust security with SSL and access control, while its compatibility with multiple programming languages enhances its versatility for application development.

MySQL seamlessly integrates with SkyPoint AI Platform (AIP) via its inbuilt connector, enabling centralized data synchronization and management. This integration simplifies operations like managing data tables, enhances analytics and governance, breaks data silos, and ensures secure, efficient data handling for improved compliance and productivity.

This document will guide you through the process of connecting My SQL to the skyData.

## Prerequisite

You need the following details to configure and import data using the <a href="https://www.mysql.com/" target="_blank">MySQL⇗</a> connector:

* Server name
* Database name
* Port number
* Username
* Password

## To import data using the MySQL connector

Follow the below steps to create and configure a new dataflow for the MySQL import connector:

1. Navigate to **Dataflow > Imports**.

<img src="https://mintcdn.com/skypoint/TE_3JbZI8sChP2jT/static/doc_snippets/mysqlsetupdataflow.png?fit=max&auto=format&n=TE_3JbZI8sChP2jT&q=85&s=12b8fbd2966fa8184fa6a60f0611575f" alt="Alt image" width="1920" height="1089" data-path="static/doc_snippets/mysqlsetupdataflow.png" />

2. Click **New dataflow** as indicated by an arrow.

The **Set dataflow name** page appears.

<img src="https://mintcdn.com/skypoint/TE_3JbZI8sChP2jT/static/doc_snippets/mysqlsetdataflowname.png?fit=max&auto=format&n=TE_3JbZI8sChP2jT&q=85&s=720e255bf486e765d45fb3ccad61fa51" alt="Alt image" width="1920" height="1089" data-path="static/doc_snippets/mysqlsetdataflowname.png" />

3. Enter the desired name for the dataflow in the **Name** text field.
4. Click **Next** to proceed.

The **Choose connector** page appears.

<img src="https://mintcdn.com/skypoint/TE_3JbZI8sChP2jT/static/doc_snippets/mysqlsearchconnector.png?fit=max&auto=format&n=TE_3JbZI8sChP2jT&q=85&s=c8b9c656e21cad5d71158af5872fa175" alt="Alt image" width="1920" height="1089" data-path="static/doc_snippets/mysqlsearchconnector.png" />

## Add MySQL connector

1. On the **Choose Connector** page, use the **Search** feature to locate and select the **MySQL** Connector.
2. Enter the **Display Name** for your dataflow in the provided text field.
3. Optionally, add a **Description** in the designated text area.

<img src="https://mintcdn.com/skypoint/TE_3JbZI8sChP2jT/static/doc_snippets/mysqlsetdisplayname.png?fit=max&auto=format&n=TE_3JbZI8sChP2jT&q=85&s=992638bc4dedf75a1d62730e1492bef3" alt="Alt image" width="1920" height="1089" data-path="static/doc_snippets/mysqlsetdisplayname.png" />

4. Click **Next** to proceed.

The **Configuration** page appears.

<img src="https://mintcdn.com/skypoint/TE_3JbZI8sChP2jT/static/doc_snippets/mysqlconfigure.png?fit=max&auto=format&n=TE_3JbZI8sChP2jT&q=85&s=732c171cd9c64aa101356182be1f2052" alt="Alt image" width="1920" height="1089" data-path="static/doc_snippets/mysqlconfigure.png" />

## Connect to the MySQL account

1. Fill in the required details on the Configuration page.
2. Click **Connect**.

<img src="https://mintcdn.com/skypoint/TE_3JbZI8sChP2jT/static/doc_snippets/mysqlconnected.png?fit=max&auto=format&n=TE_3JbZI8sChP2jT&q=85&s=89746a2d832fc64ca0da8250ab80f436" alt="Alt image" width="1920" height="1089" data-path="static/doc_snippets/mysqlconnected.png" />

Once the connection is established, the connector can be used to import data from MySQL tables.

3. Scroll down to the **Table Details** section, select the checkboxes for the tables you wish to import, and use the dropdown menu to label them as either **Data** or **Metadata.**

<img src="https://mintcdn.com/skypoint/TE_3JbZI8sChP2jT/static/doc_snippets/mysqlselecttables.png?fit=max&auto=format&n=TE_3JbZI8sChP2jT&q=85&s=afc9ca4231069fb53a9cbbaf92c5a3fa" alt="Alt image" width="1920" height="1089" data-path="static/doc_snippets/mysqlselecttables.png" />

<Note>
  By default, all tables in the **Table Details** section are selected. You can choose to import only specific tables that are relevant to your data processing needs. For example, to import customer data, select tables containing details like name, email, address, and contact information.
</Note>

| Item        | Description                                                                 |
| :---------- | :-------------------------------------------------------------------------- |
| Purpose     | Option to assign a purpose (Data or Metadata) for each table.               |
| Data        | Loads customer data                                                         |
| Metadata    | Loads Metadata                                                              |
| File name   | Displays the name of the file that you imported.                            |
| Entity name | Displays the imported table name by default. You can rename it if required. |

4. Please scroll down to the bottom of the page to ensure all required tables are selected.

<img src="https://mintcdn.com/skypoint/TE_3JbZI8sChP2jT/static/doc_snippets/mysqlsavetables.png?fit=max&auto=format&n=TE_3JbZI8sChP2jT&q=85&s=25125e3faea05bcebf16fba6be72d6fa" alt="Alt image" width="1920" height="1089" data-path="static/doc_snippets/mysqlsavetables.png" />

5. Click **Save** to apply the changes.

<img src="https://mintcdn.com/skypoint/TE_3JbZI8sChP2jT/static/doc_snippets/mysqlnewdataflow.png?fit=max&auto=format&n=TE_3JbZI8sChP2jT&q=85&s=79ac9b5a61fd74b85ad0f67c55e318f8" alt="Alt image" width="1920" height="1089" data-path="static/doc_snippets/mysqlnewdataflow.png" />

Congratulations ! for saving the MySQL connector dataflow, which appears on the **Dataflow > Imports** page.

## Run, Edit, and Delete the imported data

Once the table is imported, you can execute, modify, and remove the imported table from the Dataflow. Follow the below steps:

1. Go to the **Dataflow** > **Imports** page.

<img src="https://mintcdn.com/skypoint/TE_3JbZI8sChP2jT/static/doc_snippets/mysqlruneditdelete.png?fit=max&auto=format&n=TE_3JbZI8sChP2jT&q=85&s=b75ef9efcb2667b75b3633293fa1e723" alt="Alt image" width="1920" height="1089" data-path="static/doc_snippets/mysqlruneditdelete.png" />

| Item              | Description                                                                     |
| :---------------- | :------------------------------------------------------------------------------ |
| Name              | Displays the name of the imported Dataflow.                                     |
| Type              | Displays connector type symbol.                                                 |
| Connector Name    | Displays connector name.                                                        |
| Status            | Indicates whether the data is imported successfully.                            |
| Tables Count      | Displays the number of tables imported.                                         |
| Created Date      | Displays date of creation.                                                      |
| Last Refresh Type | Displays the refresh value: Full or Incremental.                                |
| Updated Date      | Displays last modified date.                                                    |
| Last Refresh      | Displays the latest refresh date, which updates each time you refresh the data. |
| Actions           | Provides multiple options for managing dataflows.                               |

2. Select the horizontal ellipsis under the **Actions** column and do the following:

| If you want to                       | Then                                                                                               |
| :----------------------------------- | :------------------------------------------------------------------------------------------------- |
| Modify the Dataflow                  | Select **Edit** and modify the Dataflow. Click **Save** to apply your changes.                     |
| Execute the Dataflow                 | Select **Run**.                                                                                    |
| Bring the data to its previous state | Select **Rollback**.                                                                               |
| Delete the Dataflow                  | Select **Remove** and then click the **Delete** button. All tables in the data source get deleted. |
| See the run history of the dataflow  | Select **Run history**.                                                                            |

3. Click **Run** to execute the dataflow. Once the execution is successful, the data pipeline status will update to **Completed**, as illustrated in the figure below.

<img src="https://mintcdn.com/skypoint/TE_3JbZI8sChP2jT/static/doc_snippets/mysqldataimport.png?fit=max&auto=format&n=TE_3JbZI8sChP2jT&q=85&s=60e9e6c5f3850482d315b25e76520571" alt="Alt image" width="1920" height="1089" data-path="static/doc_snippets/mysqldataimport.png" />

<Note>
  In the Dataflow's **Run History Description,** you can view error messages related to data import failures from a data source. Additionally, you can check the status, start time, and end time of the data pipeline execution.
</Note>

## Next step

After completing the data import, start the [Master Data Management (MDM) - Resolve](https://docs.skypointcloud.com/docs/stitch.html) process to create a single, unified view of the data. With Skypoint MDM, you can ensure that your data is accurate, consistent, and reliable, making it easier to use for business processes, analytics, and reporting.