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 X Data provider:

X Provider declaration part 1

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

X Provider declaration part 2

Few sample queries:

SELECT * FROM [post_2/tweets] BODY(“{“text”:”Hello”}”)

SELECT * FROM [post_2/tweets] BODY(“{“text”:”Click to this link https://www.pcvue.com/”}”)

SELECT * FROM [post_2/tweets] BODY(“{“text”:”This is my first tweet emoji{U+1F983}”}”)

Files attached consist in the: