Chapter 4. Data Virtualization

Red Hat Integration 2020.Q1 provides the following enhancements for Data Virtualization:

In Java versions earlier than Java 11, regardless of whether you specify a minus sign character (-) as a prefix or suffix of a negative format pattern, the returned negative result string is preceded by a minus sign. However, in Java 11, if you append a minus sign to a negative format pattern, the result string that is returned has the minus sign appended to it.

If you obtain unexpected results for negative numbers that a parsing or formatting function returns, revise the pattern string for the function so that the minus sign precedes the rest of the pattern.

SELECT FORMATBIGDECIMAL((99 - 10000000), '#,##0;###0-')

SELECT FORMATBIGDECIMAL((99 - 10000000), '#,##0;###0-')

Depending on the version of the Operator, one of the following results is returned:

For OData clients to establish secure connections to endpoints of a virtual database, the data virtualization service must be able to authenticate security tokens that it receives from Single Sign-On. Currently, because the data virtualization service is unable to read TLS/SSL certificates from Single Sign-On, attempts to validate the tokens on a secure channel are unsuccessful.

As a temporary workaround, disable secure connections between the data virtualization service and Single Sign-On by adding the following property to the custom resource (CR) for the virtual database, and then redeploy the virtual database:

  - name: KEYCLOAK_DISABLE_TRUST_MANAGER
     value:  "true"

  - name: KEYCLOAK_DISABLE_TRUST_MANAGER
     value:  "true"

Afterwards, use a tool such as Postman to issue the OData HTTP requests to the service endpoint. Browser clients cannot connect to the endpoint.

You can migrate virtual database that you developed for JBoss Data Virtualization or Teiid deployments. For information about migrating legacy virtual databases to Data Virtualization, see Using Data Virtualization.