Apatar Data Integration

Apatar is an open source Extract, Transform, and Load (ETL) project. Modular architecture delivers: 1. Visual job designer/mapping 2. Connectivity to all major data sources 3. Flexible Deployment Options (GUI, or server engine with JVM, or embedded).

INSTALLATION:

1. Unpack the "apatar_.tar.gz" archive into any directory (apatar_folder);

2. Change system parameters for all files with ".sh" extension in directory (for example, run this command from console: chmod 777 application.sh);

3. To start using Apatar, run any file which has the ".sh" extension. If you would like to run Apatar as a regular application (default), you need to startup the "application.sh" file.

If you would like to run Apatar as a scheduling application (scheduling), you need to startup the "scheduling.sh" file (for example, #./application.sh).

What is new in this release:

• New features:
• Support of JRE 1.6 - JRE 1.6 included in the installation package for Windows
• Bugs fixed:
• DB2 connector generates incorrect URL (http://apatarforge.org/bugs/browse/APT-714)
• base64 field type percepted as text (http://apatarforge.org/bugs/browse/APT-722)
• Comparison functions like Greater Thank, Equal To etc fixed to check both inputs types.

What is new in version 1.9.2:

• New features:
• FireBird JDBC connector added (contributed by Aamir Tauqeer).
• AS400 (IBM iSeries) database connector added.
• Replace and Replace With functions enhanced to convert null values to empty strings.
• SOQL queries enabled in Salesforce connector.
• Bugs fixed:
• Salesforce Update only inserts 200 new records.

What is new in version 1.6.8:

• New features:
• RegExp function upgrade - http://apatarforge.org/bugs/browse/APT-679
• Create UUID function - http://apatarforge.org/bugs/browse/APT-680
• Bugs fixed:
• http://apatarforge.org/bugs/browse/APT-643 - DateTimeTimestamp icons in operation configuration window looks wrong some issues on the Salesforce connector and ToBoolean function

What is new in version 1.3.2:

• New features:
• Added counter to limit number of runs for a task in the Scheduling app.
• Bugs fixed:
• Apatar is not committing transactions in Sybase (http://apatarforge.org/bugs/browse/APT-574) NOTE: unfortunately the connector doesn't yet work in the update mode. Please use just the insert mode for now.
• Next run time in Scheduler is updating only after closing and reopen scheduler (http://apatarforge.org/bugs/browse/APT-566)
• Scheduling doesn't work right (http://www.apatarforge.org/bugs/browse/APT-580)
• Global fixes in the scheduling app (http://www.apatarforge.org/bugs/browse/APT-575)