From Wikipedia, the free encyclopedia
Jump to: navigation, search
Stable release
v1.12.13 / October 25, 2010
Operating system Cross-platform
Type ETL, Data migration and SQL.
License General Public License version 2.0
Website apatar.com

Apatar is an open source ETL (Extract-Transform-Load) and data integration software application.


Apatar open source project was founded in 2005.[1] The first version of the tool was released under the GPLv2 license at www.sourceforge.net in February 2007. In April 2007, Apatar alpha version was demonstrated to its strategic partners, including MySQL and BlackDuck. Apatar, Inc.,[2] a commercial company that provides support for the Apatar open source software, was founded in 2007 [3] as a branch of Altoros.


The company’s main product is Apatar,[4][5] a cross-platform open source desktop data integration tool that provides connectivity to a variety of databases, applications, protocols, files, and many more. The tool allows developers, database administrators, and business users to integrate information between a variety of data sources and formats and provides intuitive user interface that requires no coding to set up a data integration job.

Other tools designed by the Apatar team:

Apatar Merge – an MS Word plug-in that allows for building MS documents and templates using data from Salesforce CRM.
Apatar On-Demand – a Web-based application that can integrate Salesforce CRM and desktop editions of the QuickBooks accounting system.


Programming language: J2EE
Development platform: Eclipse
Query languages: SQL, SOAP/XML
Supported Operating Systems: Windows, Linux, MacOS

Apatar data integration software is adopted for the Amazon Web Services platform.

Typical use[edit]

  • Database migration
  • Application integration
  • Database creation/update scripts
  • Cross-database operations, import/export
  • Data aggregation

Users and customers[edit]

Apatar’s user and customer base ranges from small companies and individuals to large organizations such as the World Bank Group, Thomson Reuters, John Wiley & Sons, R.R. Donnelley, Autodesk,.[6][7] and more.


  1. ^ "Apatar Crashes Data Mashup Party". SD Times. Retrieved 2007-09-24.  External link in |publisher= (help)
  2. ^ "Moving data around with Apatar"Robert Scoble interviews CEO of Altoros about launching Apatar, a data integration project
  3. ^ "Open Source Companies to Watch". NetworkWorld. Archived from the original on 12 October 2007. Retrieved 2007-09-24.  External link in |publisher= (help), Network World created a list of newcomers focused on data integration.
  4. ^ Mashup the intranet Archived February 23, 2012, at the Wayback Machine., IntranetBlog.com explains mashup technologies in their article featuring Renat Khasanshyn's expert opinion.
  5. ^ Web 2.0: Renat Khasanshyn of Apatar on Internet Growth, Mike McDonald of WebProNews interviews Renat Khasanshyn on his plans with Apatar
  6. ^ "Two Ways To Deal With SOA's Data Integration Challenge". InformationWeek. Retrieved 2007-09-24.  External link in |publisher= (help)
  7. ^ "Young software exec moves to open source model". American City Business Journals, Inc. Retrieved 2007-09-24.  External link in |publisher= (help)

External links[edit]