Setting up input data

Talend Open Studio for ESB Getting Started Guide

EnrichVersion
6.3
EnrichProdName
Talend Open Studio for ESB
task
Installation and Upgrade
Design and Development
EnrichPlatform
Talend ESB
Talend Studio

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.

Prerequisites:

  • You have an access to a MySQL database.

  • You have downloaded the gettingstarted.sql file by clicking here and stored it locally.

To import the customer data into a MySQL database:

  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.

    The gettingstarted database is imported in the MySQL database.