IT / Programming / Altova / Altova MissionKit / Mapforce

Altova MissionKit - Mapforce

Details

ID 2757626
Classroom 2 days
Webinar 4 days
Method Lecture with examples and exercises.
Prequisite XML basics
Audience Programmers, Web developers

Services:

  • Lunch / Catering
  • Assistance for hotel / travel bookings
  • Comelio certificate
  • Flexible: Free cancellation up until 10 days before the training

Summary

Altova MapForce is an any-to-any graphical data mapping, conversion, and integration tool that maps data between any combination of XML, database, flat file, EDI, Excel, XBRL, and/or Web service, then transforms data instantly or autogenerates royalty-free data integration code for the execution of recurrent conversions. It provides powerful, visual XML mapping functionality for instantly transforming XML data from one XML format to any another XML format based on XML Schema or namespace aware DTDs, and can even generate an XML mapping component from an XML instance file. It includes the FlexText utility for parsing and converting text files such as mainframe text reports, text-based log files, and other legacy text file types in mapping designs. With its visual interface, FlexText lets you insert an existing text file and extract the portions you want to convert in the MapForce mapping interface. This training shows you in many hands-on labs how to develop mapping solutions for the above-mentioned combinations and to make the most of MapForce.

Training Dates

  • 2020-Nov-09 - Nov-12
  • 2021-Jan-18 - Jan-21
  • 2021-Mar-29 - Apr-01
  • 2021-Jun-07 - Jun-10

590 EUR +VAT

Location | Enrollment


Agenda

XML Mapping

MapForce User Interface - Mapping between Components - Multiple XML Files from Single XML Source File, Excel Rows or per Table - Filtering - Sorting - Loops, Groups and Hierarchies - Code Generator

Database Mapping

Setting up the XML-To-Database Mapping - Table Preview Customization - Components and Table Relationships - Database Actions: Insert, Update, Delete, Ignore - Generating Database Output Values - Table Actions - SQL WHERE / ORDER Component - SQL SELECT Statements as Virtual Tables - Stored Procedures - Querying Databases Directly - Database Query Tab

Text Mapping

Mapping CSV and Text Files: Mapping CSV Files to XML / XML to CSV, Creating Hierarchies From CSV and Fixed Length Text Files, CSV File Options, Mapping Fixed Length Text Files (to a Database) - MapForce FlexText: Creating Split Conditions, Defining Multiple Conditions per Container/Fragment, Using FlexText Templates in MapForce, Using FlexText as a Target Component

Web Services Mapping

Creating Web Service Projects from WSDL Files - Calling Web Services

General Functions

Global Resources - Dynamic Input/Output Files per Component - Intermediate Variables - User-Defined Functions - Built-In Functions - Using the Command Line - Project Management - Chained Mappings / Pass-Through Components - Sequence of Processing Mapping Components - Merging Multiple Files into One Target - Documenting Mapping Projects

Trainer

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling in XML, shortly before any of the current Semantic Web standards had been adopted. He started working as lecturer and consultant in 2002.

Publications
  • XSLT, XPath und XQuery ISBN 978-3-939701-18-7
  • XSL-FO ISBN 978-3-939701-17-0
  • XML Schema ISBN 978-3-939701-22-4
  • XML: Standards und Technologien ISBN 978-3-939701-21-7
  • MS SQL Server – XML und SOAP-Webservices ISBN 978-3-939701-03-3
  • Oracle, PL/SQL und XML ISBN 978-3-939701-49-1
Projects

He works as an IT-consultant and project manager. He developed various XML-based applications with his team in India and is regularly involved in complex import/export scenarios / data integration projects and in XML-based reporting solutions.

Research

He led several research projects for business partners concerning expert systems, ontology-based software, and also online questionnaires. Nearly all of these projects were based on a complex XML-data model or made use of XML-based rule sets.