Ready to Download and Run

by arcesb | November 21, 2017

Export Records from MySQL to CSV

Fetch all records from a MySQL database and store that information in CSV files.

Download Flow

The Export Records from MySQL to CSV sample flow has pre-configured connectors for retrieving records from a MySQL database and storing them as CSV files. This example is based on the Actors table from the Sakila sample database provided by MySQL. The following connectors make up the core elements of the flow:

  • MySQL Connector: Allows you to insert or retrieve the data in these documents to or from a MySQL database.
  • CSV Connector: Converts Comma-Separated Values (CSV) files into XML, and generates CSV files from XML.

These connectors are configured to automatically move files from one connector to the next until the records from MySQL have been exported to CSV.

You can modify the automation settings for each connector in its Automation tab, or you can manually process each step in the workflow using the Send button in the connector's Input tab. You can schedule the application to poll MySQL for new data from the MySQL Connector's Automation tab, or you can manually receive data by using the Receive button from its Output tab.

If you would like to use this sample flow in your workspace, please follow these instructions:

Importing Workspace

Create Workspace

First, navigate to the Flows tab and click on the cogwheel icon in the top right corner. Choose the Create Workspace option to create a new Workspace for this sample flow.

Import Workspace

Then, from the same cogwheel dropdown, click Import Workspace. In the resulting dialog, choose the downloaded sample flow mysqlcsvexport.arcflow to import the relevant connectors and settings. You can choose to import the flow into any Workspace you like, but we recommend using separate Workspaces for distinct workflows.

Once you have successfully imported the sample flow, you can begin configuring the connectors to best suit your specific use case.

MySQL Connector

Connect to MySQL & Test the Connection

Navigate to the Settings tab of the MySQL Connector. In order to establish a connection with the database, you must enter your Server (the domain where the database is located), Port, Database, User, and Password. Click the Test Connection button to verify that you can connect to MySQL from ArcESB.

Set up your Output Mapping

After successfully setting up and testing a connection, you can choose to query MySQL for information. Exactly what data is queried is controlled by the Output Mapping configured in the Cloud Data Connector's settings. If you would like to execute all output mappings, navigate to the Output tab and click Receive to start retrieving records.

Once you configure the these connectors, the sample flow is ready for use!

Export Records from MySQL to CSV

Are You Up & Running?

If the answer is yes, congratulations for successfully configuring the Export Records from MySQL to CSV sample flow! However, if you are confronted by any issues or have any further questions, please do not hesitate to contact us.