Data integration basics

First steps in data integration

• Start Studio
• Creating the first job
• Running a job
• Using the component help
• Designing a job with best practices
• Documenting a job

Working with files

• Working with delimited files
• Working with hierarchical files

Working with databases

• Creating tables in MySQL databases
• Creating your first job
• Applying best practices

Repository metadata

• Using metadata for delimited files
• Using XML file metadata
• Applying best practices
• Using database metadata
• Use of generic schemas
• Updating metadata

Processing data

• Mapping data with tMap
• Connecting data with tMap
• Capturing join rejects
• Filtering data and capturing filter rejections
• Using other data processing components

Contexts and context variables

• Creating a built-in context variable
• Connecting to databases using context variables
• Creating a context group in the repository
• Loading context variables from a flow

Creating executables and Docker images from data integration jobs

• Creating a standalone job
• Creating a new version of the job
• Creating a Docker image

Controlling execution

• Managing files
• Processing files
• Managing job execution via a master job

Handling errors

• Detection and handling of basic errors
• Triggering a warning

Working with web services

• Accessing a SOAP web service

Basic knowledge of computer science, including familiarity with Java or another programming language, SQL and general database concepts

We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.

We offer seminars with a high practical relevance. The contents and exercises are geared to your daily tasks in the company and completely dispense with advertising references to other products of the software manufacturer.

All our training courses are manufacturer-independent. This enables us to offer critical considerations of the products themselves and comparisons with competitors of the manufacturer in the seminar. The course contents are our own and derived from the practical experience of our trainers in projects.

Of course, the contents of company seminars can be individually adapted to your needs. Please do not hesitate to contact us.

• Implementation guarantee - Implementation guarantee for two or more participants
• Mobile classrooms - the ideal complement for company seminars
• Free support - for questions after the seminar
• Delivery on account - no prepayment required
• Interview with the trainer / quality assurance - get to know and assess the trainer in advance
• Clarify seminar requirements - review your knowledge with the trainer
• Assistance with travel costs - we cover part of the costs of hotel accommodation
• Meals - all day cold / hot drinks and a full lunch in the restaurant
• Location of training centres - always centrally located and easily accessible
• Discount - we have attractive prices, take advantage of our additional discounts
• Remotelabs - rent our Remotelabs for your own seminars or as a complement to your company seminars