Who's Online

We have 10 guests and 1 member online

Subscription

RSS Feeds List RSS Feeds List

Top Developers


Patryk Szczypien
Created the CurrentTimestamp function

Top DataMap Posters

162Alexander Pipko
155Alex Khizhnyak
36Sergei
14Alan Glass
12Gerd Wohlgenannt
10Georgeann Zitkus
8murlakam mur
7maria
7FFT FFT
7Ioannis Pontikis

Proud Sponsor of

Membership


SourceForge.net Logo

Get your DataMap on ApatarForge!

ApatarForge is the catalog of Apatar DataMaps (user-created integration jobs that link data between the sources and the targets).
  1. Design a DataMap,
2. Upload it to ApatarForge,
3. Offer DataMap expertise to Apatar Community.

New to the scene? Visit our Open Source Data Integration section to find out what it's all about.

Get Started

 
DataMap of the Month
>>
Aug 28, 2009 - by Sergei - Remove a part of number from a particular position

This datamap example will help you learn how to remove special char/part of number from a particular position. Use case is described at http://www.apatarforge.org/forums/viewtopic.php?t=780&start=0...

ApatarForge News
Apatar Allows to Automatically Truncate Text to Specified Length

May 29, 2009 - by olga belokurskaya -

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.

Apatar Data Integration Parses the Text of E-mails Omitting System Information

May 26, 2009 - by olga belokurskaya -

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

Top DataMap Downloads
Apatar Data Integration/ETLApatar Data Integration/ETL
58797 downloads
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).

751MSSQL to PostgreSQL
430Extracting E-mails from SalesForce.com to .CSV File
425Migrating Contacts from GoldMine to SalesForce.com
420Text File to MySQL
361SalesForce.com to MSSQL
347PostgreSQL to MySQL
312Migrating Contacts From SalesForce.com to SugarCRM
235MS Excel File to RSS: Shopping List for My Wife
229MySQL to SugarCRM
208E-mail Verification (SFDC to .CSV)

See All Downloads
Latest Wiki Articles and Documentation

Download Now

Latest Release:
Apatar Open Source 1.12.3

Donate Now

More Stuff

Apatar On-Demand Apatar On-Demand
Web Demos Web Demos
Blogs Blogs

New DataMaps

12/15 Test Feed
12/15 Test Feed
12/15 Test Feed
12/08 Scenario 2
12/04 Aggregating RSS feeds from CNET, Google, yahoo
11/30 Aggrated news from Yahoo,CNET and Google
11/29 Test
10/13 Shopping List
08/28 Remove a part of number from a particular position
08/04 Splitting records into two destination tables

Apatar Survey Results

Most popular connectors
  • MS SQL - 14
  • MySQL - 13
  • TextFile - 10
Most popular functions
  • Concatenate - 15
  • Contain - 13
  • Is Not Null - 12
Most wanted connectors
  • ODBC - 15
  • Generic JDBC - 12
  • SAP - 10
Most wanted features
  • Creating data tables - 15
  • Database and tables replication - 15
  • Working with linked tables - 12

Recent DataMap Comments

Oracle to MySQL: how to take fou...
by a.rosati
Test Feed: this datamap ha...
by manuel
by 43 cents
 
  Terms and Conditions Privacy Policy Contact Info Comments and Suggestions ETL News