MapForce® 2008
|
| Top Next |
MapForce® 2008 |
MapForce® 2008 Enterprise Edition is a visual data mapping tool for advanced data integration projects.
MapForce® supports:
| • | Graphical mapping from and to any combination and any number of: |
- XML Schemas as source and target
| • | Professional Edition, additionally: |
- Flat files: delimited (CSV) and fixed-length formats as source and target
- Relational databases as source and target
Enterprise Edition, additionally:
- EDI files: UN/EDIFACT and ANSI X12 as source and target
- FlexText™ files as source and target
- Office Open XML Excel 2007 files as source and target
| • | Automatic code generation |
- XSLT 1.0 and 2.0
Professional Edition and Enterprise Edition, additionally:
- XQuery
- Java, C# and C++
| • | On-the-fly transformation and preview of all mappings, without code generation or compilation |
| • | Powerful visual function builder for creating user-defined functions |
| • | Accessing MapForce user interface and functions through MapForce API (ActiveX control) |
| • | Definition of custom XSLT 1.0 and 2.0 libraries and integration of custom C++, Java and C# functions |
| • | Support for XPath 2.0 functions in XSLT 2.0 and XQuery |
| • | Definition of user-defined functions/components, having complex in/outputs |
| • | Support for source-driven / mixed content mapping and copy-all connections |
| • | Automatic retention of mapping connectors of missing nodes/items |
Professional Edition, additionally:
| • | XML data mapping to/from databases - IBM DB2 and others |
| • | Direct querying of databases |
| • | SQL-WHERE filter and SQL statement wizard |
| • | SQL SELECT statements as mapping data sources |
| • | Project management functions to group mappings |
| • | MapForce plug-in for Eclipse |
| • | MapForce for Microsoft Visual Studio |
Enterprise Edition, additionally:
| • | Creation of SOAP 1.1 and SOAP 1.2 Web service projects and mapping of Web service operations from WSDL Files |
| • | Direct calling of Web service functions |
| • | FlexText™: advanced legacy file processing |
All transformations are available in one workspace where multiple sources and multiple targets can be mixed, and a rich and extensible function library provides support for any kind of data manipulation.
What is mapping?
Basically the contents of one component are mapped, or transformed, to another component. An XML, or text document, a database, Excel 2007 file or EDI file, can be mapped to a different target XML document, CSV text document, EDI file, Excel 2007 file or database. The transformation is accomplished by an automatically generated XSLT 1.0 or 2.0 Stylesheet, the built-in MapForce engine, or generated program code.
When creating an XSLT transformation, a source schema is mapped to a target schema. Thus elements/attributes in the source schema are "connected" to other elements/attributes in the target schema. As an XML document instance is associated to, and defined by, a schema file, you actually end up mapping two XML documents to each other.
Databases as well as EDI documents, can also be used as data sources, and map data to multiple XML Schemas, EDI documents, or other databases.
|