Altova MissionKit - MapForce for Data Integration
Course Overview
| ID | 2302003 |
| Duration | 2.0 days |
| Methods | Lecture with examples and exercises. |
| Prerequisites | XML basics |
| Target group | Data Engineers, XML developers |
| Vorgängerkurs | 2302001 |
Overview
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.
Dates
Zurzeit stehen keine offenen Termine zur Verfügung. Nutzen Sie alternativ die Inhouse‑Option.
Learn with customized examples and content—precisely tailored to your requirements.
Your benefits at a glance
- Flexible preferred date
- Customized content
- Intensive exchange
- High practical relevance
Description
Learn how to use Altova Mapforce to graphically transform incoming data from XML, text files, MS Excel, databases, and web services to build efficient interfaces.
Services
- Lunch / catering
- Help with hotel / travel
- Comelio certificate
- Flexible: free cancellation up to one day before
Comelio Media
Still looking for additional reading? Discover suitable specialist books in our catalog.
Content
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
Reading and processing EDIfact data - Configuring MapForce with EDI libraries - Making changes to libraries
Processing of EDI data
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
Instructor
Unser Altova XMLSpy, Mapforce und StyleVision Trainer Marco Skulschus studierte in Wuppertal und Paris Ökonomie und schloss mit einer Diplom-Arbeit zur semantischen Datenmodellierung in XML-Daten ab. Er arbeitet seit 2004 als Trainer im Bereich XML, XML Schema, XSLT und XSL-FO und zeigt, wie man die Altova XML-Produkte für Software-Entwicklung mit XML nutzen kann.
Publications
- XML: Standards und Technologien (Comelio Medien )
978-3-939701-21-7 - XSLT, XPath und XQuery (Comelio Medien )
978-3-939701-18-7 - XSL-FO (Comelio Medien )
978-3-939701-17-0 - XML Schema (Comelio Medien )
978-3-939701-22-4 - MS SQL Server 2012 – XML-Integration mit T-SQL (Comelio Medien )
978-3-939701-83-5 - Oracle, PL/SQL und XML (Comelio Medien )
978-3-939701-49-1