Talend Open Studio Foundation

Course objectives:

1. Learn how to use the environment
2. Model needs
3. Control the component library
4. Implement Jobs
5. Deploy Jobs

Target audience:

1. Project manager
2. BI Expert
3. System Engineer/DBA

Prerequisites:

Teaching Method:

Duration:

 1. Presentation:

1. Operational and Business Intelligence Integration
2. Presentation and installation of Talend Open Studio

 2. Model your needs and document a project

1. Using the Business Modeler
2. Manage Documents

 3. Use Job Designer to generate the code

1. Designing the job: Best practices
2. Generate test data sets

 4. Use input/output components

1. Manage file access (XML, positional, delimited, etc.)
2. Manage database access (ODBC, native connections)
3. Using SqlBuilder to generate and combine SQL requests

 5. Centralize the metadata in the Repository

1. Centralize your connection chains
2. Centralizeyour schema (data flow structure)

 6. Transform and enhance data

1. Using the different transformation components
2. Map data using tMap (join)
3. Qualify data using filters
4. Generate multiple outputs and handle rejections

 7. Using development features

1. Define execution contexts (development, production)
2. Inject Java code in your jobs
3. Establish error management
4. Log the execution statistics of your jobs

 8. Debug and deploy jobs

1. Generate technical documentation
2. Learn how to use the Debug view
3. Deploy jobs and expose them as web services

 9. Rely on the Talend community

1. Benefit from community support
2. Import new components from Talend Exchange