Knowledge Base

Download the latest version of the provider proposed in the table at the end of this article and unzip it to execute the msi file.

Follow the instruction given in the ADO.Net Providers installation procedure article to install this provider.

To declare a connection into PcVue, goto General -> Data connections -> Add a SQL connection and select the Data source Built-in providers, then you can choose .NET Framework Data Provider for Salesforce Data provider:

Salesforce Provider declaration part 1

Finally go to the second tab (Built-in) to configure the connection:

Salesforce Provider declaration part 2

Few sample queries:

SELECT * FROM [get_data/v55.0/query] QUERYSTRING(“q=SELECT+Codigo_GV__c,Descripcion__c,Calle__c +FROM+Promocion__c+WHERE+Identificador__c%3D%27GOB-G045%27”) MAXDEPTH(0)

SELECT [device.name] FROM [get_v1/deviceMgt/devices]
EXEC [put_v1/deviceMgt/groups/IbN89a]

SELECT * FROM [post_v1/deviceMgt/devices]
EXEC * FROM [delete_v1/deviceMgt/groups/IbN89a]

Files attached consist in the: