Chapter 2. Getting started with data virtualization

In this tutorial we demonstrate how to create and use a "Portfolio" virtual database by completing the following tasks:

  1. Setting up our environment.
  2. Adding a Data Virtualization Operator to OpenShift.
  3. Creating a postgreSQL accounts database with a simple sample database to serve as our data source.
  4. Creating a custom resource (CR) that defines a Portfolio virtual database. The CR specifies how to integrate data from our postgreSQL database and a REST service.
  5. Running the Operator to deploy the virtual database.
  6. Demonstrating how JDBC and OData clients can access and query the virtual database.

    Note

    ODBC access is also available, but information about how to enable ODBC access is beyond the scope of this tutorial.

    Time
    30 minutes to 1 hour
    Skill
    Beginner
Important

Data virtualization is a Technology Preview feature only. Technology Preview features are not supported with Red Hat production service level agreements (SLAs) and might not be functionally complete. Red Hat does not recommend using them in production. These features provide early access to upcoming product features, enabling customers to test functionality and provide feedback during the development process. For more information about the support scope of Red Hat Technology Preview features, see https://access.redhat.com/support/offerings/techpreview/.

Prerequisites

Before you can use data virtualization to create a virtual database, you must have:

  • Access to an OpenShift 4.4 cluster with cluster-admin privileges. This can be an enterprise deployment of OpenShift (OpenShift Container Platform, OpenShift Dedicated, or OpenShift Online), or a local installation that uses Red Hat Code Ready Containers (CRC). For more information about CRC, see the article on Red Hat Developer.
  • A version of the OpenShift CLI (oc) binary that matches the version of the OpenShift server.
  • Working knowledge of SQL.
  • Working knowledge of Openshift and the OpenShift Operator model.
  • Working knowledge of git and GitHub.