Chapter 6. Running the Data Virtualization Operator to deploy a virtual database

Procedure

1. From a terminal window, type the following commands to log in to the OpenShift cluster and create a pull secret that you can use to access the Red Hat image registry:

   oc login
   oc create secret docker-registry dv-pull-secret /
   --docker-server=registry.redhat.io /
   --docker-username=$username /  

   1

   
   --docker-password=$password /
   --docker-email=$email_address
   oc secrets link builder dv-pull-secret
   oc secrets link builder dv-pull-secret --for=pull

   Copy to Clipboard Toggle word wrap

   1

   Use your Red Hat Customer Portal login credentials.

2. Log in to the OpenShift web console as a cluster administrator.
3. From the OpenShift menu, expand Operators and click OperatorHub.
4. Click Red Hat Integration - Data Virtualization, and then click Install.

5. From the Create Operator Subscription page, verify that the selected namespace matches the name of the project where you want to install the operator, and then click Subscribe.

   The Installed Operators page lists the Data Virtualization Operator and reports the status of the installation.

6. From the OpenShift menu, expand Workloads and click Pods to check the status of the Operator pod. After a few minutes, the pod for the Operator service begins to run.

7. To enable the data virtualization Operator to retrieve images from the Red Hat registry so that you can create virtual databases, link the secret that you created in Step 1 to the service account for the Operator.

   oc secrets link dv-operator dv-pull-secret --for=pull

   Copy to Clipboard Toggle word wrap

Procedure

1. From a terminal window, log in to OpenShift and open the project where you want to create the virtual database.
2. On your computer, change to the directory that contains the .yaml file that contains the CR.

3. Type the following command to run the operator to create the virtual database:

   oc create -f <cr_filename.yaml>

   Copy to Clipboard Toggle word wrap

   Replace <cr_filename.yaml> with the name of the CR file for your data source. For example,

   oc create -f dv-customer.yaml

   Copy to Clipboard Toggle word wrap

   After the deployment completes, a virtual database service is added to the OpenShift cluster. The name of the service matches the name that is specified in the custom resource.

4. Type the following command to verify that the virtual database is created:

   oc get vdbs

   Copy to Clipboard Toggle word wrap

   OpenShift returns the list of virtual databases in the project.

5. To see whether a particular virtualization is available, type the following command:

   oc get vdb <dv-name>

   Copy to Clipboard Toggle word wrap

   The deployed service supports connections from the following clients:

   • JDBC clients through port 31000.
   • postgreSQL clients, including ODBC clients, through port 5432.
   • OData clients, through an HTTP endpoint and route.