Skip to main content Skip to complementary content

Setting up input data for profiling and cleansing

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 tprtbd_gettingstarted_source_files.zip from the Downloads tab 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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!