Data Integration and ETL News

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

Related Links
Date and Time Settings user guide: http://apatarforge.org/wiki/display/AUG/Date+and+Time+Settings

Major Apatar Offerings

Apatar Enterprise Data Mashups (www.apatar.com)
Apatar Enterprise Data Mashups is the first open source on-demand data integration software toolset and services, which help users integrate information between databases, files, and applications. Imagine you could visually design (drag and drop) a workflow to exchange data and files between files (Microsoft Excel spreadsheets, CSV/TXT files), databases (such as MySQL, Microsoft SQL, Oracle), applications (Salesforce.com, SugarCRM), and the top Web 2.0 destinations (Flickr, RSS feeds, Amazon S3), all without having to write a single line of code. Users install a visual job designer application to create integration jobs called DataMaps, link data between the source(s) and the target(s), and schedule one-time or recurring data transformations. Imagine this capability fits cleanly and quickly into your projects. You've just imagined what Apatar can do for you.

ApatarForge (www.apatarforge.org)

Apatar Benefits
- Reduced integration and maintenance costs
- Improve data quality
- Shorten implementation time
- Eliminate custom coding
- Synchronization across multiple interfaces (on-premises, on-demand, mobile)
- The ability to personalize RSS feeds for workgroup collaboration, opportunity tracking, business and competitive intelligence, and project management
- No custom coding!
- The ability to create, publish, share, and re-use data transformations and output to RSS feeds by monitoring keywords and URLs for both internal and external systems

General Features
- Visual job designer and mapping enable non-developers to design and perform data transformations.
- Aggregating and reading RSS content
- Connectivity to Oracle, MS SQL, MySQL, Sybase, Microsoft Access, PostgreSQL, InstantDB, BorlandJDataStore, Csv, Qed, HSQL, Compiere ERP, SalesForce.com, SugarCRM, Goldmine, Microsoft Excel, XML, RSS, ATOM, FTP, POP3, LDAP, Autodesk Buzzsaw, WebDav, any JDBC data sources, Amazon S3, Flickr, EnterpriseDB, Dbase, StrikeIron Web Services
- Job scheduler
- Single interface to manage all your integration projects
- Flexible deployment options
- Bi-directional integration
- Platform-independent, runs from Windows and Linux; 100% Java-based
- Easy customization, source code included
- Real-time e-mail, phone number, and postal address verification
- Flexible custom date and time settings

About Apatar
Apatar is the leading provider of open source software tools for the data integration market. With powerful Extract, Transform, and Load (ETL) capabilities, Apatar enables its users to easily link information between databases (such as MySQL, Microsoft SQL, Oracle), applications (Salesforce.com, SugarCRM), and the top Web 2.0 destinations (Flickr, Amazon S3). Apatar provides support, training, and consulting services for its integration solutions. Headquartered in Western Massachusetts, Apatar operates a development center in Minsk, Belarus. Apatar is currently used by 3000 organizations and individuals worldwide. For more on Apatar, please visit www.apatar.com and www.apatarforge.org.

More information is available at ApatarÂs Online Press Room, found at http://www.apatar.com/newsroom/. 

The Information Difference, a strategic advice and research firm dedicated to MDM, launched.

After a slow start, master data management is starting to make headway in the public sector, helping state and federal agencies tackle identity management.

Sybase iAnywhere announced the beta availability of "Panorama," code-name for the next release of SQL Anywhere, its data management and synchronization solution.

SalesForce will be shortly making another release with new and enhanced features.

You can take a sneak peak at the new features in the Summer ‘08 Admin Preview.
Here are some highlights from the coming release as singled out in the official SalesForce blog.

Also, the latest release schedule is available at trust.salesforce.com!

And a quick reminder for those who still doubt whether they can/should integrate non-SalesForce contact data (from various databases like Oracle, MySQL etc. and/or applications like Excel, QuickBooks etc.) into SalesForce account, just one word: Apatar.

Oracle launches Oracle Universal Online Archive and Oracle E-mail Archive Service, components of Oracle Fusion Middleware

Master data management is "horses for courses" with widely-ranging adoption curves, but so far, the customer comes first; observations from our conference

Information Difference will enable companies to get the most value of their MDM projects by providing in-depth, independent analysis of MDM vendors.

CDI-MDM Summit shows inroads in data management but a large gap in data governance

IBM unveiled a complete mashup portfolio for business.