Alena Semeshko, Data Integration Evangelist at Apatar, started a blog on data integration, ETL, data quality, and related topics.

November 20, 2008, Chicopee, MA – Apatar, Inc., the leading provider of open source software tools for the data integration market, officially announced a new blog on the current problems and issues in the world of data integration. Ms. Alena Semeshko, Data Integration Evangelist at Apatar, provides news, tips, ideas, opinions, and thoughts on data integration, mashups, ETL, data quality, application integration (EAI), data management, business intelligence, etc. The readers will also find practical advice on the most controversial issues along with the most up-to-date information on Apatar’s progress.

New pre-built data integration solution from Apatar enables GoldMine to Salesforce CRM migration of customer activity history, prevents data loss, and ensures customer data quality, cutting development and maintenance costs.

October 28, 2008, Chicopee, MA- Apatar, Inc., a provider of open source tools for data integration, today announced the GoldMine to Salesforce History Migration solution, which migrates client activity history between GoldMine and Salesforce CRM. This pre-build solution allows Apatar users to integrate e-mails, calendar events, invitations, and other history activities from the MS SQL instances of GoldMine to Salesforce CRM, linking each to the right contact. Apatar customers can also save time and avoid loss of data by setting the solution to preserve correct links between activities and the users to which they are assigned. Implementing this solution lowers development and maintenance workload up to a factor of five compared to manual programming.

October 23, 2008, Chicopee, MA – Apatar released the white paper that aims to help organizations reduce ETL (Extract, Transform, and Load) and data integration costs. This document analyzes the Total Cost of Ownership of a typical data integration project, measures the cost structure, and identifies ways to cut each cost down. Readers will also find best practices and examples of how major companies saved on open source and data integration.

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 16, 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.

October 9, 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.

September 11, 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.

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.

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 6, 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.

Apatar Provides Connectivity to Force.com Sandbox

July 30, 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.

KID Delivers Apatar Open Source Data Integration to South Africa

July 23, 2008, Chicopee, MA – Knowledge Integration Dynamics (KID), a Johannesburg-based company that delivers high-performance business intelligence, data warehousing, data integration, and data management solutions, has concluded a system integrator partnership agreement with U.S.-headquartered Apatar to distribute its open source data integration suite in South Africa. KID will use, consult, train, and offer support services for the Apatar integration package that offers a single interface into all integration projects across Mac OS, Windows, and Linux using an open source architecture and modular applications that deliver flexible deployment options.

Apatar Team Is Refactoring Apatar Source Code and Architecture

July 17, 2008, Chicopee, MA – 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.

Apatar Launches Hosted Salesforce.com and QuickBooks Integration, Slashes Deployment Time by a Factor of Ten

Apatar reveals implementation of its hosted service takes 30 minutes or less using a browser. Apatar On-Demand was designed to automatically de-duplicate data while synchronizing accounts, opportunities, purchase orders, and invoices between Salesforce.com on-demand CRM and the QuickBooks accounting system.

July 10, 2008, Chicopee, MA – Apatar, Inc., the leading provider of open source software tools for the data integration market, today launched Apatar On-Demand for Salesforce.com CRM and QuickBooks accounting software. Apatar On-Demand Edition is a hosted service that synchronizes order data between Salesforce.com CRM and desktop QuickBooks accounting software. It was designed for business users, so the process of setting up the integration link does not require technical skills. Apatar On-Demand Edition for Salesforce.com and QuickBooks allows running one- or two-way, recurring or one-time synchronization of account, contact, order, and opportunity data, while preserving links between tables in both Salesforce.com and QuickBooks.

Apatar Data Integration Replaces Multiple Field Values

June 27, 2008, Chicopee, MA – Apatar Team announced the Replace With function that enables multiple field value substitutions. Now Apatar users can automatically traverse strings for mutliple text values and replace them at a time, rather than apply manual field-by-field replacement iterations. The new function also allows users to specify whether the replacement should be case sensitive or not and whether the part of a value or the entire string needs to be replaced.

Apatar Prevents Deceased Credit Fraud with CDYNE Death Index Data Quality Service

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 19, 2008, Chicopee, MA – Apatar, Inc., the leading provider of open source software tools for the data integration market, 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.

Apatar to Speak on Enterprise 2.0 and Data Mashups at Dr. Dobb’s Architecture & Design World 2008

Renat Khasanshyn, the founder and CEO of Apatar, will speak on the future of enterprise data mashups at Dr. Dobb's Architecture & Design World 2008 on July 24, 2008 at the Hyatt McCormick Place, Chicago, IL.

June 12, 2008, Chicopee, MA - Apatar, Inc., the leading provider of open source software tools for the data integration market, has been selected to speak at the Dr. Dobb's Architecture & Design World 2008 conference, the independent event dedicated to software architecture, design, modeling, and UML. The conference will be held on July 21-24, 2008 at the Hyatt McCormick Place, Chicago, IL, and include 75 focused sessions on real-world topics, visionary keynotes, in-depth training, and networking with peers, industry leaders, and world-class speakers.

Apatar Partners with ColourBlack to Integrate Unstructured Data into Corporate Applications

The partnership features integration of unstructured data from knowledge and document management systems into corporate data flow, as well as document conversion, search, and data restructuring.

June 4, 2008, Chicopee, MA - Apatar, Inc., the leading provider of open source software tools for the data integration market, today announced a technology and marketing alliance with ColourBlack, Ltd., a Microsoft Partner that provides enterprise solutions for data migration, integration, and enhancement for unstructured data sources. Under the alliance, the companies will support unstructured and semi-structured data from Microsoft SharePoint and other electronic document management systems as both sources and targets of data integration initiatives, all without custom coding. With this new agreement, Apatar and ColourBlack enable both developers and business users not only to link information between SharePoint Server, various document repositories, and third-party applications or databases, but also conduct searches and perform MS Office document type conversion and text restructuring.

Apatar Announces 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).

Apatar Integrates IBM DB2 Products with Third-party Applications and Cleanses Mainframe Databases

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, Inc., the leading provider of open source software tools for the data integration market, 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).

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.

Apatar Extends Customer Information with CDYNE Demographics Data

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.