Upgraded DBAmp and the SOQL queries don't work

Data Integration CData DBAmp
, ,
1

We upgraded DBAMp version on our SQL Server.

Followed the instructions and created a new Linked Server.

Stored procedures are running fine, but when I execute a SOQL query; we get the following error

An invalid schema or catalog was specified for the provider “MSOLEDBSQL” for linked server “SalesForce”.

Example SOQL queries

Select * from SalesForce…user__c

Select * from SalesForce…Account

2

As mentioned in our release notes here: DBAmp - Release Notes DBAmp v22 no longer supports the … notation. It needs a catalog of CData and a schema of Salesforce, ie

Select * from SalesForce.CData.Salesforce.Account

3

Thank you. This solved the problem.