IT / Programming / Altova / Altova MissionKit / Mapforce
| ID | 2757626 |
|---|---|
| Classroom | 2 days 9:00-16:30 |
| Webinar | 4 days 9:00-12:30 |
| Method | Lecture with examples and exercises. |
| Prequisite | XML basics |
| Audience | Programmers, Web developers |
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.
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
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
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
Creating Web Service Projects from WSDL Files - Calling Web Services
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
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.
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.
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.
