Export objects from Salesforce and create Excel output

Four Stars

Export objects from Salesforce and create Excel output

Hi all,

 

I want to export some objects from Salesforce and put them in an Excel (CSV) file using Talend. The challenge is that I need the output file in a linear basis, for example:

 

- Account - Contacts: 1:n

- Account - Contracts: 1:n

 

The output should be 1 line per Account, first of all I think I need to export all 3 objects to Excel / CSV files and first denormalize the data using tDenormalize (write all related objects in 1 row, separated by a delimiter.)

 

Has anyone experience or an information how I can realize that?

 

Cheers,

Ingo

Fifteen Stars TRF
Fifteen Stars

Re: Export objects from Salesforce and create Excel output

Can you give us an example of what you expect as a result?

TRF
Four Stars

Re: Export objects from Salesforce and create Excel output

The result should be 1 Account per line, e.g.:

 

Account name, Account city, Contact person 1, Contact person 2, Contact person 3, Contract information1, Contract information 2, ....

 

The output should be an Excel / CSV file, the challenge is that Contact and Contract tables are 1-many relations to the Account, I can deserialize these objects to have all contacts in one line with the ID of the Account, but I´m not sure how to get that data exported in a good way.

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch