topic Re: SalesForce connectino is missing module (table) in Talend Studio

SalesForce connectino is missing module (table)

Jacco_De_Zwart — Fri, 15 Nov 2024 23:40:43 GMT

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

Re: SalesForce connectino is missing module (table)

Anonymous — Thu, 30 Sep 2021 03:26:34 GMT

Hello,

Could you please clarify in which Talend Open Studio version/edition you are?

Best regards

Sabrina

Re: SalesForce connectino is missing module (table)

Jacco_De_Zwart — Thu, 30 Sep 2021 05:58:44 GMT

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

Re: SalesForce connectino is missing module (table)

Anonymous — Thu, 30 Sep 2021 07:31:03 GMT

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

Re: SalesForce connectino is missing module (table)

Jacco_De_Zwart — Thu, 30 Sep 2021 07:43:56 GMT

Hi,

Yes, that works.

Result in the attached picture.

Jacco

Re: SalesForce connectino is missing module (table)

Anonymous — Sat, 09 Oct 2021 03:52:09 GMT

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

Re: SalesForce connectino is missing module (table)

Jacco_De_Zwart — Mon, 11 Oct 2021 06:17:56 GMT

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

Re: SalesForce connectino is missing module (table)

Anonymous — Tue, 12 Oct 2021 03:10:23 GMT

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