Apatar - Data Integration Application

Apatar is an open source data integration application to help join your desktop data with the web. Apatar effectively integrates data and applications, and provides visual job designer and mapping, joins, filtering, data cleansing and validation capabilities. Connectors include MySQL, PostgreSQL, Oracle, MS SQL, Sybase, FTP, HTTP (POST and GET), SalesForce.com, SugarCRM, Compiere ERP, Goldmine CRM, XML (local and web-based), flat files (.CSV, .TXT), Webdav, Buzzsaw, LDAP, Amazon, RSS and even Flickr; more connectors are under way.

Apatar is an open source data integration application to help join your desktop data with the web. Apatar features powerful Extract, Transform, and Load (ETL) capabilities, visual job designer and mapping, over 20 JDBC and API connectors and a job scheduling application. Users install a visual job designer application to create integration jobs called DataMaps, link data between the source(s) and the target(s), and schedule one-time or recurring data transformations in between local systems such as databases, files, flat files, and web-based applications such as SalesForce.com, Flickr, Amazon, or even RSS feeds. Users can share and re-use DataMaps over the web through a catalog at http://www.apatarforge.org/. Using Apatar on-demand web-services, users can turn their local data (such as spreadsheets) into an RSS feed. No programming or design is required to accomplish even a complex integration.

• Visual job designer and mapping enable non-developers to design and perform transformations;
• Connectivity to MySQL, PostgreSQL, Oracle, MS SQL, Sybase, FTP, HTTP (POST and GET), SalesForce.Com, SugarCRM, Compiere ERP, Goldmine CRM, XML (local and web-based), flat files (.CSV, .TXT), Webdav, Buzzsaw, LDAP, Amazon, RSS and even Flickr; more connectors are under way;
• Single interface to manage integration projects;
• Job Scheduler;
• Flexible Deployment Options (GUI, or server engine on top of JVM or embedded).

Apatar effectively integrates data and applications, and provides joins, filtering, data cleansing and validation capabilities saving time while integrating information between heterogeneous databases, files, and applications.

Online Demos: http://www.apatar.com/web_demo.html

Capabilities: http://www.apatar.com/capabilities.html

Architecture: http://www.apatar.com/technology.html

For more information, or to download a copy of Apatar and/or its source code, visit http://www.apatar.com.