Knowledge Base

Details:

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

Cassandra Provider declaration part 1

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

Cassandra Provider declaration part 2

Few sample queries:

SELECT name, occupation FROM users WHERE userid IN (199, 200, 207)
SELECT JSON name, occupation FROM users WHERE userid = 199
SELECT name AS user_name, occupation AS user_occupation FROM users
SELECT time, value FROM events WHERE event_type = ‘myEvent’ AND time > ‘2011-02-03’ AND time <= ‘2012-01-01’
SELECT COUNT (*) AS user_count FROM users

INSERT INTO NerdMovies (movie, director, main_actor, year) VALUES (‘Serenity’, ‘Joss Whedon’, ‘Nathan Fillion’, 2005) USING TTL 86400

Files attached consist in the: