This table shows the features included in the Enterprise, Professional, and Standard Editions of MapForce® 2008. Please use this as a guide to determine which edition is most suitable for your needs.
|
| Enterprise | Professional | Standard |
|
 | Well-formedness checking |
•
|
•
|
•
|
| Validation (XML Schema & DTD-based) |
•
|
•
|
•
|
| Enhanced, tabbed validation window |
•
|
•
|
•
|
| Text View with syntax-coloring |
•
|
•
|
•
|
| Line Number Margin |
•
|
•
|
•
|
| Text-folding Margin |
•
|
•
|
•
|
| Visual indentation guides |
•
|
•
|
•
|
| Find & Replace with enhanced XML capabilities |
•
|
•
|
•
|
| Find & Replace based on Regular Expressions |
•
|
•
|
•
|
|
| Built-in award-winning XSLT 1.0 processor |
•
|
•
|
•
|
| Built-in, schema-aware XSLT 2.0 processor |
•
|
•
|
•
|
| XPath 1.0 support |
•
|
•
|
•
|
| XPath 2.0 support |
•
|
•
|
•
|
| Text View with syntax-coloring |
•
|
•
|
•
|
| Graphical Stylesheet Designer for XML-to-XML mapping |
•
|
•
|
•
|
|
| Mapping and conversion of Excel 2007 data to other formats |
•
| | |
|
| Mapping XML, databases, flat files, EDI, and Excel 2007 to Web services |
•
| | |
| Mapping existing Web services to XML, DB, flat file, EDI, Excel 2007, and WSDL |
•
| | |
| Data mapping and transformation for XML |
•
|
•
|
•
|
| Data mapping and transformation for relational databases |
•
|
•
| |
| Data mapping and transformation for flat files (CSV, tab-separated, fixed width, etc.) |
•
|
•
| |
| FlexText utility for extremely versatile flat file parsing and integration |
•
| | |
| Data mapping and transformation for UN/EDIFACT EDI |
•
| | |
| Data mapping and transformation for ANSI X12 EDI |
•
| | |
| Data mapping and transformation for Excel 2007 (OOXML) |
•
|
•
|
•
|
| Data mapping and transformation for XML fields in IBM DB2 9 databases |
•
|
•
| |
| Data mapping and execution of existing Web services |
•
| | |
| Unique GUI for visual design of transformations |
•
|
•
|
•
|
| Support for advanced user-defined data processing functions |
•
|
•
|
•
|
| Visual function builder for creating user-defined functions |
•
|
•
|
•
|
| User-defined functions that operate on entire XML tree |
•
|
•
|
•
|
| Consuming existing Web service operations as mapping functions |
•
| | |
| SQL-WHERE filter support |
•
|
•
| |
| Support for any SQL-SELECT statement as input |
•
|
•
| |
| Aggregate functions (sum, min, avg, etc.) |
•
|
•
|
•
|
| ValueMap function to transform field values (01 to January, etc.) |
•
|
•
|
•
|
| Mapping of mixed content nodes |
•
|
•
|
•
|
| Visual cues & support for refactoring mappings when data structures change |
•
|
•
|
•
|
| Functions to deal with NULL values and absent elements |
•
|
•
|
•
|
| Generation and processing of exceptions |
•
|
•
| |
| Adding textual annotations to document mappings |
•
|
•
|
•
|
| Unlimited parameters for built-in functions |
•
|
•
|
•
|
| Interactive output preview |
•
|
•
|
•
|
| Support for complex mapping scenarios with multiple sources, multiple targets |
•
|
•
|
•
|
| Transformation input parameters |
•
|
•
|
•
|
| Multi-step transformation pipelines |
•
|
•
|
•
|
| Rich and extensible function libraries to perform data modifications |
•
|
•
|
•
|
| Generation of XSLT transformation stylesheets |
•
|
•
|
•
|
| XML Schema sources and targets |
•
|
•
|
•
|
| Database sources and targets |
•
|
•
| |
| Flat file (CSV, tab-separated, fixed width, etc.) sources and targets |
•
|
•
| |
| Options for handling empty flat file input values |
•
|
•
| |
| UN/EDIFACT EDI sources and targets |
•
| | |
| ANSI X12 EDI sources and targets |
•
| | |
| Enhanced support for modifying EDI configuration files |
•
| | |
| Excel 2007 (OOXML) sources and targets |
•
| | |
| Generation of sample XML Schema when none is available |
•
|
•
|
•
|
| Support for all UN/EDIFACT messages from versions 93a to 04b |
•
| | |
| Support for all current ANSI X12 messages |
•
| | |
| Powerful and flexible support for insert/update/delete when mapping to databases |
•
|
•
| |
| Generation of XSLT 1.0 mapping |
•
|
•
|
•
|
| Generation of schema-aware XSLT 2.0 mapping |
•
|
•
|
•
|
| Generation of schema-aware XQuery mapping |
•
|
•
| |
| Generation of both XSLT and program-code from a single design |
•
|
•
| |
| Redesigned & optimized Java, C++ and C# code generation |
•
|
•
| |
| Built-in MapForce Engine to execute complex transformations on-the-fly and preview output - even when using databases as sources |
•
|
•
| |
| Built-in MapForce Engine to execute complex transformations on-the-fly and preview output - even when using databases and EDI as sources |
•
| | |
| Combine multiple source nodes into the same target node |
•
|
•
|
•
|
| Custom XSLT-Libraries (re-use named templates from any existing XSLT file as a function library) |
•
|
•
|
•
|
| Auto-number and create-guid functions to generate default output values |
•
|
•
| |
| Overview window & navigator for complex mappings |
•
|
•
|
•
|
| Auto-connection of all child nodes based on flexible matching |
•
|
•
|
•
|
|
| Database Export/Import |
•
|
•
| |
| EDI / EDIFACT Import |
•
| | |
| Legacy data conversion (CSV/FLF text file import/export) |
•
|
•
| |
| Hierarchical Database Import based on XML Schema |
•
|
•
| |
| SQL/XML Database Import based on XML Schema |
•
|
•
| |
| Database Query window |
•
|
•
| |
| Drag & drop SQL, SQL/XML editor |
•
|
•
| |
| Support for Microsoft Access |
•
|
•
| |
| Support for Microsoft SQL Server |
•
|
•
| |
| Support for Oracle 9i and 10g |
•
|
•
| |
| Support for IBM DB2 |
•
|
•
| |
| Deep integration with IBM DB2 9 pureXML |
•
|
•
| |
| Support for Sybase |
•
|
•
| |
| Support for MySQL |
•
|
•
| |
| Support for generic relational databases via ADO |
•
|
•
| |
| Support for generic relational databases via ODBC |
•
|
•
| |
| Support for accessing Views and System Tables in all supported databases |
•
|
•
| |
| Inline Primary and Foreign Key creation |
•
|
•
| |
|
| Create a connection (ADO or ODBC) |
•
|
•
| |
|
| Using existing Web services in XML, db, flat file, EDI data mappings |
•
| | |
| Using Web services as data mapping source, target, or data processing function |
•
| | |
| Visual Web services implementation |
•
| | |
| WSDL mapping for building Web services |
•
| | |
| Java and C# code generation based on graphical Web services design |
•
| | |
| Project view for organizing WSDL mappings |
•
| | |
| Exception generation and processing for Web services |
•
| | |
|
| Command-line interface for batch execution |
•
|
•
| |
| OLE support |
•
|
•
|
•
|
| ActiveX Control |
•
|
•
|
•
|
|
| Seamless integration into Microsoft Visual Studio 2005-2008 |
•
|
•
| |
| Fully ties into Visual Studio project management |
•
|
•
| |
| Provides MapForce data mapping and Web services implementation features directly within Visual Studio |
•
|
•
| |
|
| Seamless integration into the Eclipse 3.1 platform |
•
|
•
| |
| Fully ties into Eclipse project management |
•
|
•
| |
| Provides MapForce data mapping and Web services implementation features directly within Eclipse |
•
|
•
| |
|
| Java Code Generation of data transformations from visual mapping |
•
|
•
| |
| C# Code Generation of data transformations from visual mapping |
•
|
•
| |
| C++ Code Generation of data transformations from visual mapping |
•
|
•
| |
| XSLT Code Generation of data transformations from visual mapping |
•
|
•
|
•
|
| Java code generation from visual mapping to implement Web services |
•
| | |
| C# code generation from visual mapping to implement Web services |
•
| | |
| Support for data streams for code generation |
•
|
•
| |
| Generated transformation code is royalty-free! |
•
|
•
|
•
|
|
| Configure multiple target deployment environments |
•
|
•
|
•
|
| Switch between configurations with one click |
•
|
•
|
•
|
| Define a system of resource aliases |
•
|
•
| |
