Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I don't know if I'm the right place, but I have a question regarding the SalesForce connection.
Right now I'm evaluating Talend open studio and as a means of testing I want to retrieve data from SalesForce. I am able to get the connection working and I can get a list of modules (tables) in SalesForce.
But I'm missing (at least) one module/table in that list. That is the OpportunityLineItem module/table. When I use DBeaver (with an odbc connection to SalesForce) I am able to see the table, but not with Talend Open Studio.
What can there be wrong?
Thanks in advance and sorry if this question doesn't belong here.
Jacco
Hello,
Are you able to use tSalesforceInput and perform a manual query with OpportunityLineItem module/table? Try to connect the tSalesforceInput to a tLogRow and let us know if there is any result.
Best regards
Sabrina
Hello,
Could you please clarify in which Talend Open Studio version/edition you are?
Best regards
Sabrina
Hey Sabrina,
I use Talend Open Studio (for Data Integration) 7.3.1
And the plugin version of SalesForce is 7.3.1.20190624_1017
Jacco
Hello,
Are you able to use tSalesforceInput and perform a manual query with OpportunityLineItem module/table? Try to connect the tSalesforceInput to a tLogRow and let us know if there is any result.
Best regards
Sabrina
Hi,
Yes, that works.
Result in the attached picture.
Jacco
Hello,
We are supposing that you have checked the online documentation about: TalendHelpCenter: Centralizing Salesforce metadata
Please check it to see if there is any case sensitive issue for your module.
Best regards
Sabrina
Sabrina,
When I use the SalesForce Metadata, I'm not able to find the OpportunityLineItem table (or module). I don't think it has anything to do with case sensitive or something like that.
Here is a screenshot of DBeaver showing the table in SalesForce (using 64-bit ODBC Devart driver)Here is a screenshot of Talend showing all tables with Opportunity
This shows all tables in Talend with Line, doesn't show OpportunityLineItem
This shows what I was looking for, but could not found.
So, I don't think it's a case sensitive issue. I allso wasn't able to find the table Product2 in de metadata list (yes, the Product2 is the right name). But that can be because it has something to do with custom table which is made for our SalesForce implementation.
Jacco
Hello,
Feel free to create a jira issue of DI project on talend bug tracker and our developer will make a further investigation on it.
https://jira.talendforge.org/secure/Dashboard.jspa
Best regards
Sabrina