Salesforce, Talend (tMap), Data Loading...Avoid VLookup

Saturday, February 26, 2011 by Aslam - The Alexendra
Hi All,
Today I will give you some demonstration about data loading with Talend. I am taking one special case in which generally people use VLookup function from excel to match the lookup ids and fill the records csv column and then upload. For example, you have one CSV file for Contacts which you want to insert into salesforce, that CSV contains 'Account Name'. But you need AccountId to successfully insert contact records. For solving this people generally do this approach.

1) Fetch all account names and ids from salesforce and make one csv
2) Use the VLookup function to match Account Name from csv2 to CSV1 and set the extra column in CSV1 for AccountId (generally people struggle here :) )
3) Then use final CSV1 to upload the data

So, I am here to tell you easy upload approach using Talend tMAP to avoid any VLookup headache and simply upload data successfully.




Follow this approach.
1) Create a new Job
2) Select File->tFileInputDelimited and set your CSV input file here
3) Select Business->Salesforce->tSalesforceOutputBulkExec, set your salesforce credentials where you want to upload the data
4) Select Business->Salesforce->tSalesforceInput, set your salesforce credentials from where you want to fetch the Account Ids and Account Names data, Set your query here
5) Select Processing->tMap, this is the heart of whole process
6) Double click on tMap, set the mapping here, CSV1->AccountName TO tSalesforceInput->Name. Drag relavent columns to your salesforce output file, Set the ID from tSalesforceInput to tSalesforceOutputBulkExec->AccountId
7) Now save your complete Job
8) Run the job and it will give you output as results.

Here is the Screencast to see complete process as vedio.
http://screencast.com/t/J8tUcer963u4

Here are more links which can help you to run and use Talend
http://techblog.appirio.com/2009/08/using-talend-to-export-data-from.html
http://techblog.appirio.com/search/label/Talend
http://techblog.appirio.com/2011/01/loading-data-to-salesforcecom-with-bulk.html
http://techblog.appirio.com/2009/12/performing-lookups-and-transformations.html

Hopefully this will help some people to try Talend and finding its benifits.

Thanks
Aslam Bari

7 comments:

Abdul Vahid said...

Nice Tool:)

Unknown said...

Fantastic tool Aslam...u r a genius man

Unknown said...

we will try i t for our tax data load :)

Pepe said...

Excellent stuff Aslam!

21cssIndia said...

Talend Online Training
Introduction
Introduction to Talend
Why Talend?
Talend Editions and Features
Talend Data Integration Overview

Talend Environment

Talend Environment - Overview
Repository and Pallate
Talend Design and Views

Talend Jobs Designing

Types of Components
Basic Components - Overview
Component Properties
Sample Job designing
Job Execution
Call Us +919000444287
http://www.21cssindia.com/courses/talend-online-training-160.html

21cssIndia said...

Talend Developer Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/talend-online-training-160.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Talend Developer Online Training, Talend Developer Training, Talend Developer, Talend Developer Online Training| Talend Developer Training| Talend Developer| If you’re serious about a career in IT, 21st Century would like to provide you a guidance don’t hesitate to organize a free demo session. For any further information regarding the courses once go through our website Visit:http://www.21cssindia.com | Call Us +917386622889 - +919000444287 - contact@21cssindia.com

Unknown said...

Excellent information. Thank you. Please share more information On this topic.
Visit Us for more details https://goo.gl/Gn4Swj

Post a Comment