Dashboard > APATAR OPERATION GUIDES > Operation Guides > Transform Operation Guide
  APATAR OPERATION GUIDES Log In | Sign Up   View a printable version of the current page.  
  Transform Operation Guide
Added by Alex Khizhnyak, last edited by Alex Khizhnyak on Feb 22, 2008  (view change)
Labels: 
(None)

Please remember that most DataMaps require the Transform module between connectors. This guide will help you learn how to configure it.

Configuration

To start with,

1. Launch Apatar and start new project.
2. Drag-and-drop the input connector to Apatar's work panel.
3. Configure it providing authorization details and the links to the source you want to extract data from.
4. Drag-and-drop Transform node to Apatar's work panel.
5. Drag-and-drop destination connector (text file, or database, or whatever).
6. Configure destination connector. (Please read other Apatar user guides, if necessary.)
7. Map the source connector with the Transform node; map the Transform node with the destination connector.

     

8. Now you need to map all corresponding data fields inside the Transform module. Double-click on it. (You will see the list of all available data fields on the left and on the right.)
9. Drag-and-drop the fields you want to extract into the Transform's work space. As well, drag-and-drop the destination fields there.
10. Then map the source and destination fields that are corresponding.

     

11. Press Ok to close the Transform window.

Preview

If necessary, you can preview data. To check the transformation results, right-click on the Transform node and choose "Preview Results".

     

Run the project

Now you can launch the transformation. To do so, either choose "Run" from Apatar File menu, or select "Preview Results" after you right-click on the destination connector.

     

Ummmm, where is an actual transformation? This step doesnt appear to actually do anything - there is no transformation actually shown!

Posted by Anonymous at Feb 13, 2008 00:55

Hello,

What step are you talking about?

The Transform module allows transforming data from one data souce (DB, app, or whatever) to another one. For instance, move data from Oracle to MySQL, or from MS SQL to Salesforce.com, or from RSS feeds to .CSV files, etc.

Is there a way to pass multiple fields (from the incomming and outcommin) to the canvas, instead of having to drag and drop each field one by one?

It appears the UI is sluggish... sometimes it drags the fields to the canvas and sometimes I have to click several times to get fields to move within the canvas area.

Regards,

I did a test to move data from salesforce to MS Access, but couldn't see any data moved into Access even though in the work panel I was able to preview the results from the destination connector. I did everything I could using the instructions, right click the destination connector and preview results, or File, Run. Each time it seemed to work fine, but when I go into my Access database, the table is always empty no matter what. What did I do wrong? Thanks.

Thanks, Daniel.

The GUI will be improved, definitely. Currently we are consolidating the ideas and selecting the possible options to ease the transformations.

Site running on a free Atlassian Confluence Open Source Project License granted to Apatar Data Integration (ETL). Evaluate Confluence today.
Contact Administrators