Altova MapForce Enterprise Edition is a scalable data mapping, integration, and ETL tool. This award-winning application lets you visually map data between any combination of XML, database, EDI, XBRL, flat file, Excel, JSON, and/or Web service, then transforms data instantly or generates royalty-free XSLT, XQuery, Java, C++, or C# code for execution of recurrent conversions.
Numerous functions come standard (filter, concatenate, sum, etc.), and you can create and save your own functions or use existing Web services to process data. The MapForce Debugger lets you single step through a mapping and see the data flow step by step from sources to target nodes. Direct file read and write gives MapForce a performance boost by streaming arbitrarily large XML, JSON, CSV, and FLF input and output files. Support for wildcard characters allows you to split data into multiple files or use file names as parameters. Once a mapping is defined, you can instantly view and save the output. Automate data transformations through the API or ActiveX control. Upload mappings to FlowForce Server for workflow automation. MapForce supports all major databases, including SQL Server, PostgreSQL, Oracle, MySQL, IBM DB2, Informix, Sybase, Microsoft Access, SQLite, and Firebird. EDI support is provided for the most prevalent standards: EDIFACT, X12, HIPAA, HL7, SAP IDoc, and IATA PADIS. The FlexText utility lets you parse structured text files to incorporate legacy data in mapping designs. Support for XBRL enables you to comply with financial reporting mandates. Tight integration with Altova StyleVision lets you render transformation output in attractive HTML, RTF, Word, or PDF reports. MapForce also integrates seamlessly with Visual Studio and Eclipse. Available in 32-bit and 64-bit versions, MapForce is indispensable for anyone facing data integration and Web services implementation challenges.