This tutorial performs the load by
- Defining a source schema based on a delimited text file (CSV),
- Defining a target schema based on a relational table (MySQL), and
- Using the tMap component to map the source fields to the target fields.
NOTE: As I was preparing the demo, I deleted and re-created the source and target metadata several times over. The initial project I created was scrapped, because I was unable to create the source and target metadata. The files were there, it just wasn't appearing in the IDE. After deleting the entire workspace and creating a new workspace and project, everything worked well and Open Studio was responsive.
I recommend running the Generation Engine in the foreground to avoid this. The initialization procedure, which took 4-5 minutes on my laptop, was only run once at the start of the workspace and project creation. After that, I didn't have to wait.
If you'd like to recreate the demo, here is the data file of sample contacts and here is some MySQL DDL for the table.