Setting up input data for profiling and cleansing - 7.2

Talend Open Studio for ESB Getting Started Guide

Version
7.2
Language
English (United States)
Product
Talend Open Studio for ESB
Module
Talend ESB
Talend Runtime
Talend Studio
Content
Design and Development
Installation and Upgrade

The example in this document assumes that the customer data you want to look up is stored in a MySQL database.

If you want to replicate the example and use the exact input data, you can download the gettingstarted.sql file of the customer data and then import it in a MySQL database.

Before you begin

  • You have an access to a MySQL database.
  • You have downloaded tos_esb_gettingstarted_source_files.zip from the Downloads tab in the left panel of this page, and stored the source file gettingstarted.sql locally.

Procedure

  1. Open the MySQL Workbench to launch an instance of the database.
  2. From the menu bar, select Server > Data Import to open the import wizard wizard.
  3. Select the Import from Self-Contained File option and browse to where you have stored the gettingstarted.sql file.
  4. Select the schema to which you want to import the data, or click New... to define a new schema.
  5. Click Start Import in the lower right corner.

Results

The gettingstarted database is imported in the MySQL database.