+2Does anyone have any experience with or a tutorial for extracting Salesforce data with TX SAAS? I'm trying to connect to Salesforce, getting a succesful connection message but when I synchronize the datasource, the sync task is successful but no table is shown:
Best answer by Christian Hauggaard
As discussed in the support ticket, the error was resolved by unchecking the 'Use Reports' checkbox
Response from Cdata:
“It seems the Salesforce API is throwing an exception when the driver is attempting to query the Report object, and this is likely because the user that is authenticating doesn't have API access to this object. They can either check their permissions and see if there is an issue there, or if they don't actually need the reports to be exposed by the driver, they can set the IncludeReports property to false, and we won't attempt to query them:
CData ADO.NET Provider for Salesforce - IncludeReports”
+5Hi
Which Salesforce provider are you using? Are you using the one marked below i.e. Salesforce 2023 (23.0.8771)?
Which authentication method are you using?
+2Hi
Provider is Salesforce (no suffix) v23.0.8771.0:
Auth:
I'm using the ‘User Credentials and a Security Token’ part on the CDATA web page which has been checked with the Salesforce dept. that has provided me with url, token, user, password.
+5Hi
+5As discussed in the support ticket, the error was resolved by unchecking the 'Use Reports' checkbox
Response from Cdata:
“It seems the Salesforce API is throwing an exception when the driver is attempting to query the Report object, and this is likely because the user that is authenticating doesn't have API access to this object. They can either check their permissions and see if there is an issue there, or if they don't actually need the reports to be exposed by the driver, they can set the IncludeReports property to false, and we won't attempt to query them:
CData ADO.NET Provider for Salesforce - IncludeReports”
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
