Presentation
- Data integration ETL solutions.
- TOS: Installation, user preferences. Reference documentation.
- Product philosophy. Designing a job.
Hands-on work
Getting started with the tool. Overview of the specifications of the generic project.
Model the need, design a first job
- Business Modeler. Job Designer.
- Main connections. CSV and XML components.
- Simple transformation components.
- Viewing the generated code, executing a job.
Exercise
Developing a job that sorts a CSV source, filtering data, and storing the result in an XML file.
Optimize job development
- Configuring reusable connections using metadata.
- Updating the metadata and propagating it to jobs, importing/exporting metadata.
- Configuring jobs with contexts.
- Externalizing context variables in “.properties” and “.ini” files.
- Creating and managing your own variables.
- Generating data sets for tests.
Exercise
Refactoring a job using metadata and contexts. Generating a test data set for this job.
Working with databases
- Supported databases and main components.
- Configuring operations on tables.
- Metadata and context of connecting to a database schema.
- Sharing connections and managing transactions.
- Creating queries using SQLBuilder.
Exercise
Reading and updating a data repository hosted on a MySQL server.
Working with multisource data
- Overview of the tMap component.
- Configuring input flows, creating joins.
- Carrying out more transformations using variables, expressions and joins.
- Qualifying data using filters.
- Generating multiple outputs, managing rejects.
Exercise
Consolidating multisource data and generating a warehouse.
Add-ons
- Breaking a job down into sub-jobs, using tRunJob. Launching jobs in the command line. Periodic execution.
- Debugging a job, tracking execution statistics
- tJasperOutput reporting.
Exercise
Generating a Jasper Report from a warehouse.
3d
- 21h00 
