Apatar
Encyclopedia
Apatar is an open source ETL (Extract-Transform-Load)
Extract, transform, load
Extract, transform and load is a process in database usage and especially in data warehousing that involves:* Extracting data from outside sources* Transforming it to fit operational needs...

 and data integration software application.

History

Apatar open source project was founded in 2005 . 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
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...

 and BlackDuck. Apatar, Inc., a commercial company that provides support for the Apatar open source software, was founded in 2007 .

Products

The company’s main product is Apatar, 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
Salesforce.com
Salesforce.com is an enterprise cloud computing company headquartered in San Francisco that distributes business software on a subscription basis. Salesforce.com hosts the applications off-site...

 and desktop editions of the QuickBooks accounting system.

Technology

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

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

Users and customers

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
Autodesk
Autodesk, Inc. is an American multinational corporation that focuses on 3D design software for use in the architecture, engineering, construction, manufacturing, media and entertainment industries. The company was founded in 1982 by John Walker, a coauthor of the first versions of the company's...

,. and more.

External links

The source of this article is wikipedia, the free encyclopedia.  The text of this article is licensed under the GFDL.
 
x
OK