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?
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.