1 answer
We are working with a vendor to test a proof of concept and it requires an ODBC connection to Salesforce. We are using the Devart ODBC driver to make this connection. We have run into a problem whereas our vendors are pointing at the issue being with Salesforce. Can anyone answer some questions and possibly point us in the right direction? The problem is that we are unable to make a "caslib" connection to Salesforce. We are able to make a libname connection using the ODBC driver and we get data but we need a caslib. The software continues to reject with statements relating to it being about the Schema. We have run the command several different ways but cannot get around the issue.Example: caslib sfclib datasource=(srctype="odbc", username="xxxxxx", password="xxxxxx", odbc_dsn="Devart Sysadmin", schema="ALL", catalog="*"); The last item that the vendor tested had to do with trying to read the Table_Scheme from a "Select *" command.Example: connect to odbc as sql1 (dsn="Devart Sysadmin", user="xxxxx", password="xxxxx");select * from sql1 They indicated we should get a result showing the schema for each of the table entries. If we run the same command against our other data sources, we get schema answers but when doing this to Salesforce (even with our sysadmin account) it does not present anything which the vendor indicates relates to the issue.
