Monday, May 4, 2015

Create your Data Services easily


We will be bringing you more Data Virtualization Demos, Videos and Workshops.  I wanted to start out this week  giving you some resources to easily spin up Data Virtualization on Openshift, Start a database and expose a OData REST API for the VIrtual Database.

Make sure to create your free OpenShift user account first by following the instructions here.

Next either deploy the cartridge via the OpenShift Web Console or the OpenShift command line tools.
  • Deploy the cartridge via the OpenShift Web Console . On the Applications tab, choose 'Add Application...' - then select the 'JBoss Data Virtualization 6' cartridge under the xPaaS section. Full installation instructions are provided.
  • Alternately, if you have the OpenShift command line tools installed, you can deploy the DataVirtualization cartridge via command line:
rhc app-create <myApp> jboss-dv-6.0.0
Regardless of the install method when the installation completes, you will be presented with a list of generated users and passwords similar to the screencap below. Make sure you save them!
Now that you have a Data Virtualization OpenShift Application let's setup a MySQL database.  You can follow these instructions to:

  1. Add MySQL database to your OpenShift Data Virtualization instance.
  2. Add phpMyAdmin which is the web interface for easy management of your MySQL database. 
  3. Add data to the database for testing.
Next we want to test out the WebUI to build a Virtual Database.  You can follow these instructions to create the Virtual Database.  You will then be able to access your data through REST, OData and JDBC from the URLs provided.  Below shows example endpoints.


If you want to try the latest release of Data Virtualization and the WebUI on premise the download the product and webui from jboss.org.   Then follow the instructions below to deploy and start the WebUI.

To install the WebUI :

1) Install DV61

2) After installing DV61, give the teiidUser the odata and rest roles. The user must have these roles to access the rest and odata endpoints. The roles file is 

<SERVER_DIR>/standalone/configuration/application-roles.properties the teiid user will look like this: teiidUser=user,odata,rest 

3) download the war and copy it into

 <SERVER_DIR>/standalone/deployments 

4) access the app at localhost:8080/dv-ui login with admin/admin

Now you can start building Data Services easily!