Today we have an exciting update. Data Virtuality now offers a Ruby REST client. It connects you to Data Virtuality via REST (Representational State Transfer) service to consume data in any Ruby applications!

We already improved our REST API based on customer requests for Data Virtuality 2.0. This Ruby client is an additional lightweight approach to expose data to users. Our commitment is to enable you to connect to Data Virtuality not only via front-end tools like Tableau, but also to retrieve and process data from Data Virtuality in your custom application!

Our Data Virtuality Ruby REST client comes with many of the same benefits as our REST API:

• Fast and easy querying and manipulation of data on the web using HTTP 

• Use our REST API to build web services on top of Data Virtuality

But it has some additional benefits:

• Save time because there is no longer a need to read our REST API documentation 

• Less code and less implementation work 

• Consume data with any Ruby application you have

Since some of our clients have communicated the need for such a service, we wrote this REST client for you in Ruby, one of the most popular programming languages for web applications, and it’s available on Github with easy setup instructions. Better yet, you can use it as a template to to experiment with finding solutions.

What kind of use cases are possible?

Use cases for our REST client could include: 1) Use Ruby to query data quickly and easily from Data Virtuality via REST and then integrate the data as KPIs into emails for your company’s daily updates. 2) Push data from Data Virtuality directly to your backoffice system for your use in dashboards, data analysis, and any business processes.


Now, we will walk through the setup of this Ruby client with you. The instructions can be found in the on our Github repository at:

Before you install the Data Virtuality REST Client, make sure that you have Ruby installed on your current device. You can check it by typing either one of the following lines in your terminal: 

$ ruby –v 
$ ruby --version

If the terminal returns “command not found”, then you do not have Ruby installed. Please visit the official Ruby website and follow the instructions you find there to install Ruby.

Then, you should install Bundler, which helps you to manage gems, the format used to package Ruby programs and libraries, with the following: 

$ gem install bundler

Next, in your project’s root directory, find out if you have a Gemfile yet. If not, create a Gemfile either manually in your GUI environment or type the following in your terminal: 

$ touch Gemfile

Now you are ready to install the Data Virtuality REST Client. Add the following line to your project’s Gemfile with a text editor: 

gem 'datavirtuality_rest'

Or, type the following shell command in your terminal: 

$ echo “gem ‘datavirtuality_rest’” >> Gemfile

Then execute: 

$ bundle

Or install it manually: 

$ gem install datavirtuality_rest

And that’s it! Now you have the Data Virtuality REST Client installed and ready to use.

Want some usage examples?

First instantiate your client by specifying the server URL, username, and password:
> client ='', '', '')

Now you can retrieve data in two ways:

1.) Read a full table or view by specifying the full schema and path, separated by a slash:
> client.get('views/demo_view')
=> [{:id=>"438256", :date=>"2017-04-01", :hits=>331}, {:id=>"438918", :date=>"2017-04-01", :hits=>314}]

2.) Specify a customer SQL query to gain full flexibility:
> client.query('SELECT * FROM views.demo_view')
=> [{:id=>"438918", :date=>"2017-04-01", :hits=>886}, {:id=>"431936", :date=>"2017-02-02", :hits=>389}])

Now you know how to use our Data Virtuality REST client.

If you have any feedback or wishes for specific functionality, get in touch by emailing us:!