An Open Source Biztalk Data Integration / ETL Alternative

Having data in multiple datasources can really be inconvenient at times. Imagine having all employee information in a sql server database while their payroll information is residing in an Oracle database. If you wondering if there is a simpler way to combine and integrate data from these two different types of database, the answer is yes! The best part, it’s low in cost and open source.

Apatar Apatar is an open source data integration tool capable of challenging some of the bigger players out there like Microsoft Biztalk and Oracle Business Intelligence 10G. With Apatar you can integrate your information between on-premise or on-demand data sources and applications. Meaning, data and information from the web can now be easily mashed up with internal data via this open source data integration tool. There is also an interface which allows you to migrate, synchronize, replicate and map data without the need for coding.

The key features of Apatar includes:

Connectivity to Oracle, MS SQL, MySQL, Sybase, DB2, MS Access, PostgreSQL, XML, InstantDB, Paradox, BorlandJDataStore, Csv, MS Excel, Qed, HSQL, Compiere ERP, SalesForce.Com, SugarCRM, Goldmine, any JDBC data sources and more.
Single interface to manage all your integration projects
Flexible deployment options
Bi-directional integration
Platform-independent, runs from Windows, Linux, Mac; 100% Java- based
Easy customization, Java source code included
No coding! Visual job designer and mapping enable non-developers to design and perform transformations

Apatar visual job designer

Apatar modular open applications

Some featured Apatar users include:

Infosys
Autodesk
Arizona State University
Alcatel-Lucent
Credit Suisse

Without doubt Apatar is emerging as one of the highly reliable and trusted software utilized by large organizations to integrate and transform data and information. Give it a try today!