Questions tagged [talend]

Talend is a company making data integration tools.

Filter by
Sorted by
Tagged with
0 votes
0 answers
32 views

Can you update an object based on the external Id of a lookup in Talend?

I have created some jobs in Talend in order to retrieve some information from from a DB, transform it and upsert it into Salesforce. I am trying to update OrderItem records based on the external ID of ...
Alejandro Martínez Infante's user avatar
0 votes
1 answer
927 views

AccountContactRelation: making AccountId and ContactId Updateable

we use Talend to upsert a bunch of Accounts and Contacts(from the old archive) each night. Now im trying to also upsert the Account-Contact Relation. Sadly my Talent Job always gives me this error: &...
Alex's user avatar
  • 3
0 votes
0 answers
66 views

Talend Select Query doesn't work properly

I'm trying to select the last created closed won opportunity for an account, this is my query used in talend: SELECT Id, Name, CreatedDate, AccountId, StageName FROM Opportunity WHERE StageName = '...
Hajar BL's user avatar
0 votes
1 answer
464 views

Salesforce - Talend Integration: API limits

We have created a API only user in our org, and are using Talend job (auth through this user) to login every 5 min and checking for any new opportunity created. If yes, then that opportunity is ...
KLab's user avatar
  • 177
0 votes
0 answers
58 views

Connect Talend to Salesforce using OAuth JWT Flow in Talend v6.2 [duplicate]

I followed the steps exactly mentioned here https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/a8jLl7sBZvEIsAkL1wTiGA for connecting Talend v6.2 to salesforce. The documentation states that we ...
Ajinkyasd's user avatar
  • 325
3 votes
1 answer
467 views

Connect Talend to Salesforce using OAuth JWT Flow

I followed the steps exactly mentioned here https://help.talend.com/reader/4cgA8~D~pdi5biHRfSvg_Q/ZoXS~zBdrcuQAx427Yv6Gw for connecting Talend to salesforce. I have done the configuration in Talend ...
Ajinkyasd's user avatar
  • 325
2 votes
1 answer
2k views

Enabling State and Country/Territory Picklists

Currently we are using text field to store state and country. Now we want to enable State and Country/Territory Picklists to maintain data quality in salesforce. If I enable the picklist, what all ...
Ajinkyasd's user avatar
  • 325
0 votes
1 answer
332 views

Error updating custom metadata types through Talend

I am trying to update a custom metadata type record through the standard Salesforce connectors in Talend. But I receive an error that says "unable to update entity type". Are we able to update these ...
Venkataraman's user avatar
1 vote
0 answers
419 views

[Talend SF Connection JWT]runtime exception https status 400-bad request message {"error":"invalid_grant","error_description":"audience is invalid"}

I am facing an error while trying to establish the Oauth connection (JWT) between talend ETL tool and salesforce : runtime exception https status 400-bad request message {"error":"invalid_grant","...
Donald's user avatar
  • 385
0 votes
1 answer
760 views

Talend to Salesforce: IOException: [LoginFault [ApiFault exceptionCode='INVALID_LOGIN'

I am trying to connect Talend to Salesforce. I complete the Salesforce connection settings in Talend: User Id Password Security Token And then try to test the connection, and I get this error ...
Robs's user avatar
  • 9,336
1 vote
1 answer
2k views

Talend - IOException: com.sforce.sw.ConnectionException: Failed to get next element

I have been using Talend for about two years to load data into Salesforce from files and have not had an issue. All of a sudden, over the weekend it has stopped working with about 20 of my standard ...
Kris Moyse's user avatar
1 vote
1 answer
554 views

Query deleted records using talend

I want to query deleted records in Salesforce and retrieve the LastModifiedDate of these records. My query: "Select LastModifiedDate FROM Custom_Table__c WHERE customFields = '456_0_1' ALL ROWS" ...
OiRc's user avatar
  • 127
1 vote
0 answers
296 views

Trouble with Talend Data Integration

We are trying to migrate data from one DeveloperPro Sandbox to another Developerpro Sandbox. We are in the POC phase trying to migrate data from Opportunities. Even after removing the System Fields ...
achilles3339's user avatar
1 vote
0 answers
521 views

Talend to connect to the Marketing Cloud SOAP API

Has anyone used Talend to connect to the Marketing Cloud SOAP API? They have Salesforce components, I guess, and Marketo, but I don't see any for Marketing Cloud. How/can you connect Talend to the ...
victorcorey's user avatar
  • 1,808
2 votes
0 answers
1k views

Error: failed to send request to https://test.salesforce.com**** when using Talend

I am trying to upload attachments (more than 500 attachments) from talend to Salesforce, It works for the first few 10, 20 attachments and then it crashes, i run the job multiple times and always get ...
user28829's user avatar
  • 694
1 vote
1 answer
77 views

Cannot see chatter feed when a field is updated by ETL

I have enabled tracking on some fields of product table, and would like to receive a chatter feed when I follow a record and there is a change in those fields. If I change manually the data I ...
user41687's user avatar
1 vote
0 answers
281 views

Import Users in Salesforce Error when User licenses limit exceeded

With Talend Open Studio for Data Integration, the tSalesforceOutputBulkExec component is used to import users in Salesforce. I tested the import of 1000 new users whith only 30 user licences ...
Henri's user avatar
  • 61
0 votes
1 answer
944 views

Extract data from salesforce/exacttarget views using talend

I would like to know if it is possible to migrate data from a ExactTarget/Salesforce view directly to an Amazon s3 bucket, without having to create a DataExtension, using an ETL tool like Talend. If ...
ponygirl's user avatar
0 votes
1 answer
148 views

Best free Talend learning resource?

Does anyone have any recommendations for Talend tutorials/training? Specifically I am looking for Salesforce data integration/updates if possible. I am completely new to the tool.
Jay's user avatar
  • 676
1 vote
0 answers
311 views

API Call exceeded in tSalesforceOutPut

I have a talend job with version 5.2. We imported the same job in talend version 6.2 to insert about 4000+ records. In talend version 6.2 when I run the job API limit is getting exceeded as for every ...
Swapnil Kale's user avatar
0 votes
1 answer
677 views

Talend and Dynamic SOQL

Does anyone know if Talend can use dynamic soql so that a 'only retrieve sobjects that have systemmoddate > last time we synced' retrieval can be done ? I've tried using variables but the connector ...
CloudHugger's user avatar
  • 1,759
4 votes
1 answer
129 views

Data Loading Sequence for Account ParentId

I would like to know the proper data loading sequence. I know to start with Accounts then Contacts and so forth. I used an External_Id__c field for the id pulled from prod. So how do I map the ...
kwiknick's user avatar
  • 359
2 votes
0 answers
2k views

INVALID_FIELD:Foreign key external ID: 0032000001ucgknaah not found for field Sandbox_Migration_Id__c in entity Contact:--

I am facing a weird behavior with talend. I am trying to migrate events using talend bulk components. I have migrate 99% of the data, but for the few left records, i get the following error: ...
Alex's user avatar
  • 91
1 vote
1 answer
2k views

Upsert to Salesforce with External ID references Not Working

I have the following objects with the respective fields in Salesforce: Prospect__c Data_Migration_ID__c (External ID) Marketing_Source__c Data_Migration_ID__c (External ID) Lead_Source__c ...
tmoore82's user avatar
  • 121
-2 votes
1 answer
2k views

When Connecting to SQL Server using Talend Tool, Connection fail and Getting Error

When Connecting to SQL Server using Talend Tool, Connection fail and Getting the following Error: Connection failure. You must change the Database Settings. java.lang.RuntimeException: java....
Murali Mohan Mandadi's user avatar
0 votes
1 answer
462 views

When Migrating data from salesforce to SQL server using Talend tool getting Error

I want to migrate data from salesforce to SQL Server using Talend Tool. so I have created a job in talend tool and when run the job i got following error: java.lang.UnsupportedClassVersionError: org/...
Murali Mohan Mandadi's user avatar
2 votes
1 answer
1k views

Copy Opportunities with LineItems with TalenD

One way to solve the datamigration challenge in Salesforce seems to be the usage of ETL-Tools. Looking around for a free and powerful approach, I found here at SFSE some recommendations of TalenD - It ...
Uwe Heim's user avatar
  • 28.4k
7 votes
3 answers
3k views

Datamigration Salesforce to Salesforce with TalenD - Best Practice for Self-Referreces

Assuming metadata is already identical, the data-transfer of complex models can still take hours or even days of manual work. Fortunately there are free tools like TalenD which can help to automate ...
Uwe Heim's user avatar
  • 28.4k