Apatar Data Integration/ETL / News: Recent posts

Apatar Automatically Truncates Text to Specified Length

The Apatar Team announced the Crop Right function that enables to automatically cut off text strings from the right side. Users may specify a desirable number of characters from the left to remain, and all the rest will be cropped. This may be especially useful when migrating text to a field with limited number of symbols allowed.

Look for the user guide here: http://www.apatarforge.org/wiki/display/FUN/Crop+Right+Function... read more

Posted by Olga Belokurskaya 2009-05-29

Apatar Parses E-mail Body Omitting System Information

The Apatar Team announced the Parse E-mail Body function, which outputs the text of an e-mail body, removing the headers and other system information. The function may be of use, for instance, when migrating contact e-mail history from one CRM system to another or saving customer messages in a legible form. Users also may find it easy to configure the access to a desired mail box and choose the type of messages to be processed (incoming or outcoming).... read more

Posted by Olga Belokurskaya 2009-05-26

Apatar Honored Most Active Community Members of 2008

January 9, 2009, Chicopee, MA — The Apatar Team launched the Apatar Community Awards (ACA) program that will be held annually in the following three nominations: Top Apatar Developer, Top Datamap Contributor, and Top Forum Member. The awards, created to pay tribute to the efforts and input of Apatar community, will be decided based on the number of features, datamaps, and posts submitted by the most active community members.... read more

Posted by Alena 2009-01-09

Apatar Integrates SugarCRM with 3rd-Party Applications

New Apatar connector enables companies to integrate SugarCRM suite with databases, flat files, other CRM/ERP applications, and top Web 2.0 destinations, all without coding.

October 17, 2008, Chicopee, MA – Apatar, Inc., the leading provider of open source software tools for the data integration market, today officially announced connectivity to the SugarCRM open source suite. The new SugarCRM connector is designed to integrate data between the popular customer relation management system and a variety of 3rd-party data sources, allowing for this data to be filtered, validated, and cleansed. Provided with Apatar’s drag-and-drop interface, the SugarCRM connector does not require coding skills and can be deployed by almost any business user.... read more

Posted by Alena 2008-10-17

Apatar Controls Number of Scheduled Integration Launches

October 10, 2008, Chicopee, MA – The Apatar Team added a counter to limit the number of transformation launches within the Scheduling application of the Apatar Open Source Data Integration solution. The new feature allows Apatar users to specify how many times the transformation should run before it stops. Apatar users will find the new feature particularly useful whenever synchronization needs to occur multiple times throghout a specified time interval. That way, instead of having Apatar run constantly and check the same data over and over, users can set synchronization to run only whenever it is convenient and/or there is a need for it.... read more

Posted by Alena 2008-10-10

Apatar Data Integration Sums Up Multiple Field Values

September 12, 2008, Chicopee, MA – The Apatar Team announced the Sum function that enables adding multiple field values and creating total sum combinations. The new function allows Apatar users not only to find the sum of multiple field values automatically, but also to add up any given integer constant to a specified field value. Apatar users will find the new function particularly useful in generating reports, when a total of data from different fields needs to be found.
See the user guide to learn more about the Sum function: ... read more

Posted by Alena 2008-09-12

First Step of Apatar Refactoring Is Completed

August 15, 2008, Chicopee, MA – The Apatar Team announced today that the first step of Apatar refactoring is now completed. You may find a brief summary below.

Apatar refactoring: change log

1. Dependency between com.altoros.octoslave.thirdparty and com.altoros.octoslave.salesforcecom was eliminated.
2. Plug-ins were sorted by category: core, rich_ui_framework, connectors
3. funstion plug-in was renamed to functions
4. generaljdbs plug-in was renamed to ldap
5. All packages with names com.altoros.octoslave.PACKAGE_NAME were renamed to com.apatar.PACKAGE_NAME
6. Paths to plug-ins were simplified: com.apatar. was deleted from plug-in category folder names
7. mysql plug-in was divided into two: mysql and mssql
8. Unused msutil.jar library was deleted
9. postgresql plug-in was divided into two: postgresql and enterprisedb
10. xml plug-in was divided into two: xml and rss
11. OctoslaveMain class was renamed to ApatarUiMain
12. Node interface was analyzed and commented. Methods related to only the UI or only the code were defined.
13. Node interface was divided into two: Node and Node UI. Node UI now includes methods related only to UI. The node now includes methods related only to core.
14. AbstractReadWriteXMLDataActions class was added. This is the class that UI classes responsible for processing situations that require interactivity during loading or saving a project should be inherited from.
15. Exception class ApatarException was added.
16. ReadWriteXMLData class was refactored:
a) all writeXMLDate methods were renamed to writeXMLData
b) public static File writeXMLData(String fileSrc, Project project, boolean autoReplace) method now gives the following exception:
public static File writeXMLData(String fileSrc, Project project, boolean autoReplace) throws ApatarException
c) updatePane method was moved to com.apatar.ui.UiUtils
d) all readXMLDate methods were renamed to readXMLData
e) readXMLData method now returns file.getName() to caller. New method signature is:
public static String readXMLData(String fileSrc, Project project) throws SAXException, IOException This method now redirects IOException handling to caller code
This method now returns file.getName() string to set Application title
f) setDateAndTimeSettings method was renamed to loadDateAndTimeSettings
g) loadDateAndTimeSettings method is no longer static. It is called by a class instance.
h) public void writeXMLData(Project project, Writer writer) method is no longer static.
i) saveDocumentToFile methods are no longer static. Duplicate code was deleted from these classes.
j) public static Document loadDocument(String xmlSrc) method was deleted
k) public static boolean isValidDbXmlFile(String srcFile) method was deleted
l) Errors processing was deleted. Exceptions should be caught by a caller.
17. The ReadWriteXMLDataUi class was added. It calls ReadWriteXMLData class methods.
18. ProxySettings class was deleted
19. InsertComent class was deleted
20. ETLFileFilter class was renamed to ApatarFileFilter and moved to UI package
21. ApatarRegExp class now passes exceptions to caller level
22. ClipboardTool class was moved to UI package
23. Added inheritance from Ipersistent interface to Condition class
24. FunctionCategory list moved to UI package
25. GetInputs class moved to UI package
26. ProgressBarRelated class moved to UI
27. RegisterRannable interface renamed to RegisterRunnable
28. RegisterRunnable interface moved to UI package
29. com.apatar.ui.JProgressDialog class deleted
30. Added AbstractProcessingProgressActions class implementing methods during datamap processing
a) Added public abstract void beforeStart(AbstractNode debugNode) event to the above class
31. Added ProcessingProgressActions class implementing AbstractProcessingProgressActions class methods
32. Errors processing moved to caller
a) public AbstractProcessingProgressActions processingActions parameter (a link to the object implementing GUI actions before datamap processing) added to public void Run(Collection nodes, OperationalNode debugNode) method
33. AbstractETLFunction class renamed to AbstractApatarFunction
34. ETLFunction class renamed to ApatarFunction
35. IPersistent interface implementation added to IntValueAbstractETLFunction class
a) IntValueAbstractETLFunction class renamed to IntValueAbstractApatarFunction
36. IntValueAbstractETLFunctionBeanInfo class renamed to IntValueAbstractApatarFunctionBeanInfo
37. JprogressDialog class moved to UI package
38. JdbcParamsBeanInfo class moved to UI package
39. MainETLPlugin class renamed to MainApatarPlugin
40. ValueAbstractETLFunction class renamed to ValueAbstractApatarFunction
41. ValueAbstractETLFunctionBeanInfo class renamed to ValueAbstractApatarFunctionBeanInfo
42. Added AbstractMainApatarPluginActions abstract class declaring methods for event taking place at application start
a) AbstractMainApatarPluginActions class inherited from IApatarActions interface
b) AbstractMainApatarPluginActions renamed to AbstractApatarActions
43. IPersistent interface implementation added to AbstractNode class
44. AbstractProcessingProgressActions class inherited from IApatarActions interface
45. Added ApatarActions class implementing UI events at nodes configuration
46. public static List getAllFieldFromTable(JdbcParams params, String tableName, DataBaseInfo bi, boolean withMessage) throws SQLException, ClassNotFoundException method deleted
47. IPersistent interface implementation added to DateAndTimeSettings class
48. Added IapatarActions interface declaring events
49. Added MainApatarPluginActions class implementing events
50. Node interface inherited from IPersistent interface
a) public void edit(Window win); public boolean realEdit(Window win); public void afterEdit(boolean editRsult); methods signatures changed to public void edit(AbstractApatarActions actions); public boolean realEdit(AbstractApatarActions actions); public void afterEdit(boolean editRsult, AbstractApatarActions actions);
51. ImageIcon getConnPointIcon() method deleted
52. IPersistent interface implementation added to SchemaTable class
53. IPersistent interface implementation added to TableInfo class
54. AbstractApatarActions action parameter implementing interactive UI functions added to protected boolean registration method
55. fileFilter class replaced with ApatarFileFilter class
56. Constructor without parameters that sets the default extension to aptr added to ApatarFileFilter class
57. Added DatamapConverter class for conversion of datamaps created by earlier application versions
58. .apatar.ui.datamapconverter package implements datamap conversion wizard
59. Method checking datamap version added to readXMLData method in ReadWriteXMLDataUi class
60. The isDatamapOlderThan12 method checking datamap version was added to the ReadWriteXMLData class.
61. Method for reading files as strings was added to CoreUtils class
62. Method for writing a file from a string type variable was added to CoreUtils class
63. SalesForcePasswordString class was deleted... read more

Posted by alex 2008-08-18

Apatar and Vertica Accelerate Corporate Data Analysis

New Apatar connector allows users to extract/load data from/to Vertica® Analytic Database, to improve data quality without any custom coding, and to deliver integrations across multiple data sources just in time.

August 7, 2008, Chicopee, MA - Apatar, Inc., the leading provider of open source tools for data integration, today announced connectivity to the Vertica Analytic Database, a high-performance, grid-based column-oriented database management system used for analytics and business intelligence. The new connector enables both developers and business users to migrate data between the Vertica Analytic Database and third-party applications without any custom coding and allows for this data to be filtered, validated, and cleansed.... read more

Posted by Alena 2008-08-07

Apatar Provides Connectivity to Force.com Sandbox

July 31, 2008, Chicopee, MA – The Apatar Team announced connectivity to Force.com Sandbox, which is a separate on-demand application environment where developers can build, test, and deploy Salesforce-related applications. The team confirmed that Apatar Data Integration can now successfully process Sandbox’s data using the connector for Salesforce.com.

Sandbox is commonly used by Salesforce.com customers for testing new customizations or features before rolling them out to users, trying out applications from the AppExchange directory, creating a development environment for building applications, and providing a training environment for employees. For more, please visit: http://www.salesforce.com/platform/application-development/development-and-test-enviorment/... read more

Posted by Alena 2008-07-31

Apatar Team Is Refactoring Apatar Source Code / Architecture

The Apatar Team started refactoring the code and architecture of the Apatar Open Source Data Integration application to optimize its core structure and improve user experience. With having both architecture and code revised, Apatar will make it easier to work with the source code in Java IDEs, create custom connectors, implement new functionality, and release builds. It will also minimize the risk of producing new bugs after implementing new features or fixes.... read more

Posted by Alena 2008-07-21

Apatar Prevents Deceased Credit Fraud with CDYNE Death Index

New Apatar data quality connector for CDYNE Death Index Web service checks customer information against U.S. Social Security Administration database and prevents using deceased person’s details

June 30, 2008, Chicopee, MA – Apatar team today announced the CDYNE Death Index connector for the Apatar Open Source Data Integration toolset. The new connector verifies the Social Security number against the U.S. Social Security Death Index database and returns whether the customer is departed, eliminating the possibility to use a deceased person's identification or deliver goods to individuals who do not exist. Using the CDYNE Death Index Web service, Apatar checks the legitimacy of social security numbers extracted from corporate applications (such as Salesforce.com and SugarCRM) or databases (MySQL, Microsoft Access, Oracle, etc.) and allows for this data to be filtered or cleansed.... read more

Posted by Alena 2008-06-30

Apatar Integration with InnoDB Storage Engine for MySQL

May 29, 2008, Chicopee, MA – The Apatar project announced connectivity to InnoDB, an ACID-compliant transactional storage engine for MySQL. Now Apatar’s MySQL connector for the Apatar Open Source Data Integration toolset allows migrating, reading and writing data from/to InnoDB tables. Now Apatar users can link MySQL InnoDB information between files (CSV/TXT), other databases (MySQL, Microsoft Access, Oracle), applications (Salesforce.com, SugarCRM), and the top Web 2.0 destinations (Flickr, Amazon S3, RSS feeds).... read more

Posted by AlecP 2008-05-30

Apatar Integrates DB2 Products w/ Third-party Applications

New Apatar connector allows users to read/write data from/to DB2 tables, create integrations using multiple data sources, and improve the quality of data extracted from or written to IBM DB2 family products.

May 23, 2008, Chicopee, MA - Apatar innitiative today officially announced connectivity to IBM DB2, a family of relational database management system products from IBM that are widely used in enterprise applications, corporate ERP systems, and mainframes. The new connector for the Apatar Open Source Data Integration toolset allows reading and writing of data from/to DB2 tables and improves the quality of data during migration or integration, all without custom coding. With this new release, Apatar enables both developers and users to easily link DB2 information between third-party applications (Salesforce.com, SugarCRM), other databases (Oracle, Microsoft SQL, MySQL), flat files (CSV/TXT), and the top Web 2.0 destinations (Flickr, Amazon S3, RSS feeds).... read more

Posted by Alena 2008-05-27

Apatar Allows Custom Date and Time Formats Integration

May 16, 2008, Chicopee, MA – Apatar team announced the ability to set custom date and time formats within Apatar Open Source Data Integration application. With this new feature, Apatar users can write and compare records of date and time formats that differ from their default system settings or other user formats. As a result, Apatar provides users with more compatibility and flexibility during integration of data that contans date and time records, especially within cross-cultural environments and applications. One does not need to know the exact format of date and time stored in the database or stick to the formats defined by other users. Instead, Apatar users can work with dates and time records using the formats that are common within their native countries or regions.... read more

Posted by Alena 2008-05-16

Apatar Extends Customer Information with CDYNE Demographics

New Apatar data quality connector for CDYNE Demographics Web service enriches customer database by integrating contacts with their statistical socio-economic data

May 8, 2008, Chicopee, MA - Apatar, Inc., the leading provider of open source software tools for the data integration market, today officially announced the CDYNE Demographics connector for the Apatar Open Source Data Integration toolset. The new connector delivers statistical data about customers and allows organizations to identify the ethnic and socio-economic makeup of their current customer base or purchased marketing lists. Apatar’s CDYNE Demographics connector can be used with any contacts database to determine the age, race, income, as well as type of residence, median income, median house value, or median number of vehicles, all without coding.... read more

Posted by Alena 2008-05-08

Apatar Announces Validation with Regular Expressions

May 1, 2008, Chicopee, MA – Apatar team announced the ability to validate and filter data using specified regular expressions within Apatar Open Source Data Integration application. With the new Match RegExp function, Apatar users can filter out records that do not match the criteria specified by regular expressions. Users can set the rules or a template for string formats, such as e-mail addresses, phone numbers and codes, or IP addresses, to match. The new feature will be useful in determining the validity of any formatted data and ridding database of bad entries.... read more

Posted by Alena 2008-05-01

Apatar Maximizes Data Quality with CDYNE Phone Verification

April 17, 2008, Chicopee, MA - Apatar, Inc., the leading provider of open source software tools for the data integration market, today officially announced the CDYNE Phone Verification connector for the Apatar Open Source Data Integration toolset. The new connector quickly and accurately determines the validity of any U.S. or Canadian phone number using CDYNE Web Services, all without coding. Now Apatar enables any business user to verify and filter customer phone numbers extracted from databases (such as MySQL, Microsoft SQL, Oracle), files (Microsoft Excel spreadsheets, CSV/TXT files), applications (Salesforce.com, SugarCRM), and the top Web 2.0 destinations (Flickr, Amazon S3, RSS feeds).... read more

Posted by Alena 2008-04-23

Apatar Announces Complex Search with Regular Expression

April 15, 2008, Chicopee, MA – Apatar team announced an ability to perform complex search within the Apatar Open Source Data Integration application using Regular Expressions. With the new RegExp function, Apatar users can specify patterns for complex string search and get substrings that match a custom Regular Expression limited by the pair of brackets. Users can also specify the rules for a set of possible strings (sentences, e-mail addresses, etc.) to match and create string substitutions. The new function can be used for validating e-mails, grouping and identifying pieces of the matching substring, and more.... read more

Posted by Alena 2008-04-15

Apatar Announces StrikeIron US Address Verification Service

Chicopee, MA – Apatar Team announced the official release of its new StrikeIron US Address Verification connector for the Apatar Open Source Data Integration toolset. Using StrikeIron’s US Address Verification Web service, the new feature relies on United States Postal Service-certified technology to verify, correct, and enhance any address in the United States with live data. It cleans customer data before it gets into CRM/ERP systems, databases, flat files, and RSS feeds by correcting extracted addresses, adding ZIP+4 data, specifying congressional districts, carrier routes, and much more.... read more

Posted by Alena 2008-04-10

Apatar Enables Long Text Data Types

April 04, 2008, Chicopee, MA - Project Apatar has announced a new data type, Long Text, for the Apatar Open Source Data Integration application. The new feature enables you to use text strings of unlimited length when working with Apatar. The Long Text data type also makes Apatar compatible with other large-sized text data types, such as Long Varchar, that involve fetching more characters than regular text strings.... read more

Posted by Alena 2008-03-17

Apatar Announces StrikeIron Email Verification Service

March 11, 2008, Chicopee, MA - Apatar, Inc. announced a new StrikeIron Email Verification data quality service. The new connector is designed to instantly determine the validity of an e-mail address or domain using StrikeIron Web Services.
With this service, Apatar enables users to cleanse customer data by validating and filtering e-mails extracted from databases (such as MySQL, Microsoft SQL, Oracle), files (Microsoft Excel spreadsheets, CSV/TXT files), applications (Salesforce.com, SugarCRM), and the top Web 2.0 destinations (Flickr, Amazon S3, RSS feeds).
Apatar is the first company to release open source tools for non-technical staff and customers to access the application data they need to do their jobs more effectively. Apatar provides support, training, and consulting services for its integration solutions. ... read more

Posted by Alena 2008-03-11

Apatar Enables Custom SQL Queries During ETL Process

December 28, 2007 - Chicopee, MA - Apatar, Inc., a provider of open source data integration software, has announced an ability to perform custom SQL queries during ETL (Extract, Transform, and Load) process. This new feature gives DBAs and Apatar users more flexibility and allows to enhance ETL features that are not implemented in the native Apatar application code.

Apatar is the first company to release open source tools for non-technical staff and customers to access the application data they need to do their jobs more effectively. Apatar provides support, training, and consulting services for its integration solutions. ... read more

Posted by alex 2007-12-28

Apatar Announces Connectivity to Microsoft SQL 2005

November 21, 2007, Chicopee, MA - Apatar, Inc. announced connectivity to Microsoft SQL 2005. The improved MS SQL connector allows now reading and writing data from/to MS SQL 2005 tables. Now Apatar enables its users to easily link Microsoft SQL 2005 information between files (CSV/TXT), databases (such as MySQL, Microsoft Access, Oracle), applications (Salesforce.com, SugarCRM), and the top Web 2.0 destinations (Flickr, Amazon S3, RSS feeds).... read more

Posted by alex 2007-11-21

Apatar Enables Data Sync Between SFDC and 3rd Parties

October 25, 2007, Chicopee, MA - Apatar, Inc., the leading provider of open source software tools for the data integration market, announced data synchonization with Apatar software between SalesForce.com and 3rd-party data sources. The new feature allows users to have their SalesForce.com data synchronized with a number of databases (such as MySQL, Oracle, Microsoft SQL, MS Access), applications (SugarCRM), and files (.CSV/.TXT). Using the synchronization mode, it is possible to automatically update or delete records in SFDC account, once the information is changed at the data source.... read more

Posted by alex 2007-10-25

Apatar Data Integration Announces RSS Aggregation

August 8, 2007, Chicopee, MA - Apatar, Inc., the leading provider of open source software tools for the data integration market, announced Aggregation module for Apatar Open Source Data Integration software. The new feature allows aggregating data from multiple sources and enables Apatar users to easily aggregate information between RSS feeds, files (such as Microsoft Excel spreadsheets, CSV/TXT files), databases (MySQL, Oracle, Microsoft SQL, MS Access), applications (Salesforce.com, SugarCRM), and the top Web 2.0 destinations (Flickr, Amazon S3).... read more

Posted by alex 2007-08-08