Altova MapForce 2015.3 SP 1

Graphical data mapping, integration, and ETL tool

Altova MapForce is a powerful scalable data mapping, integration, and ETL tool that helps you visually map data between any combination of XML, database, EDI, XBRL, flat file, Excel, JSON, and/or Web service and transforms data instantly or generates royalty-free code for execution of recurrent conversions. Direct file read and write gives MapForce a performance boost by streaming arbitrarily large XML, JSON, CSV, and FLF input and output files. The support for wildcard characters allows you to split data into multiple files or use file names as parameters. Many functions come standard and you can create and save your own functions or use existing Web services to process data. Once a mapping is defined, you can instantly view and save the output. Also, you can automatically generate turnkey applications in XSLT 1.0, XSLT 2.0, XQuery, Java, C++, or C# from your mapping designs.

It supports all major databases, including SQL Server, PostgreSQL, Oracle, MySQL, IBM DB2, Informix, Sybase, Microsoft Access, and SQLite. EDI support is provided for the most prevalent standards: EDIFACT, X12, HIPAA, HL7, SAP IDoc, and IATA PADIS.