Apatar Open Source Data Integration v1.12.3 has been released. It features the ability to retrieve deleted records from Salesforce CRM, increased data processing speed by providing bulk migrations, the Delete mode for JDBC-based connectors, as well as a number of bug fixes.

Working with Salesforce CRM 10x Faster and Retrieving Deleted Records

1. The enabled Bulk API feature within the connector for Salesforce CRM allows now Apatar users to insert, update, or delete a large number of SFDC records 10x faster than earlier.

2. To allow Apatar users retrieve deleted records that are still in the Salesforce CRM’s recycle bin, the returnDeletedRecords configuration parameter has also been implemented. Feel free to browse the user guide at

http://www.apatarforge.org/wiki/display/GUI/Apatar+Connector+for+SalesForce.com

Delete mode added to JDBC-based connectors

This mode allows for for matching records based on the primary key and deleting them from data sources. To see the example of how the Delete mode works, look through Apatar user guides:

http://www.apatarforge.org/wiki/display/INT/Table+Update

Bugs fixed

1. In the connector for AS400, the bug related to the Numeric data type has been fixed:
http://apatarforge.org/bugs/browse/APT-781
2. There was an issue with saving queries within the connector for ODBC that has been fixed:
http://apatarforge.org/bugs/browse/APT-774

3. CMD commands did not work in “Application no Apex”:
http://apatarforge.org/bugs/browse/APT-773

4. Another problem was associated with the Currency data type, which is not supported in SugarCRM:
http://apatarforge.org/bugs/browse/APT-757

5. In the connector for DB2, the bug related to the VARCHAR(50) FOR BIT DATA type has been fixed:
http://apatarforge.org/bugs/browse/APT-746

6. In the connector for MS Access, there was a problem with the SELECT statements that reverted to "SELECT *" after opening a datamap:
http://apatarforge.org/bugs/browse/APT-709

7. Another bug was related to the INSERT SQL operator working with the connector for MS Access. The connector failed to complete the operation after facing a single quotation mark.
http://apatarforge.org/bugs/browse/APT-692

8. The “Filtration” title that appeared upon the Validate operation was found confusing by Apatar users, so the window title has been changed to Validate.
http://apatarforge.org/bugs/browse/APT-690

9. When configuring the connector for Salesforce CRM, the SOQL query area did not appear in the Record Source window:
http://apatarforge.org/bugs/browse/APT-671

10. In the connector for EditGrid, the “Invalid login” message was displayed twice. The issue has been fixed.
http://apatarforge.org/bugs/browse/APT-614

11. In the connector for SugarCRM, the problems with missing Opportunity fields have been fixed.
http://apatarforge.org/bugs/browse/APT-552

12. The issue with opening the wrong guide within the connector for MS Excel has also been fixed:
http://apatarforge.org/bugs/browse/APT-541

13. The bug related to the Greater or Equal function returning unhandled number format exception has been fixed:
http://apatarforge.org/bugs/browse/APT-537

14. Some bugs have been fixed within the connector for HTTP, including misspellings and value limitations in the list of parameters (any value can now be entered):
http://apatarforge.org/bugs/browse/APT-522

15. When working with the connector for MySQL, the records were not updated at preview. The problem is eliminated now:

http://apatarforge.org/bugs/browse/APT-787

Download

http://apatar.com/download.html