Exporting Data to MySQL via ODBC in Automated Flows

The ODBC integration in Dengage allows users to export data from the Automated Flow module to various database systems, including MySQL.With the latest enhancements, users can now export data directly to their MySQL databases by defining an ODBC connection.

📘

Important:

MySQL is not listed as a standalone Remote Target option. However, it can be used seamlessly by configuring it under the ODBC type using the appropriate MySQL ODBC driver.

Prerequisite: Defining ODBC for MySQL

To export data to MySQL, you must first define it as an ODBC Remote Target.

1. Navigate to Remote Targets:
   Settings > Integrations > Remote Targets
2. Add a New Remote Target:
   Click Add to open the configuration window.
3. Enter Remote Target Details:
   • Name: Enter a recognizable name (e.g., MySQL_Export).
   • Type: Select ODBC.
   • Driver: Choose the appropriate MySQL ODBC driver.
   • Provide the necessary server information and user information.
4. Save:
   Click Save to register the connection.

How to Access

Navigation Path:
Data Space > Data Management > Automated Flows

1. Go to Data Space.
2. Click Data Management.
3. Open the Automated Flows section.

This is where you create and configure flows that export data to remote systems.

How to Use

1. Create a New Automated Flow

• Click the New button and choose Automated Flow.
• Enter a name, Start Date, and End Date.
• Click Next.

2. Add a Trigger

• Drag the trigger node to the canvas.

3. Add a Data Export Node

• Drag the Data Export node under the Actions section.
• Click the node to begin configuration.

4. Select Data Type

• Choose the desired data type.
• Click Next.

5. Choose Remote Target: MySQL via ODBC

You will not see “MySQL” as a standalone option.
Instead:

• Select the ODBC remote target previously configured with MySQL credentials.
• Click Next.