Questions tagged [redhat-datavirt]

For development issues encountered while using Red Hat JBoss Data Virtualization

Red Hat Data Virtualization is a tool that brings operational and analytical insight from data dispersed in various business units, apps, and technologies.

Click here for free development subscription which allows you to download Red Hat JBoss Data Virtualization for development use https://developers.redhat.com/downloads/

32 questions
1
vote
1 answer

How to join on JDV and not to push down join to data source

Problem: I am trying to create a wide view (~5000 columns), which works across data sources fine JDV. However, when I try to create the view with a join on 2+ table from data source, the optimizer pushes down the join to the source. The current…
1
vote
1 answer

Extending JBoss Data Virt ws translator to handle paginated source

What is a good way to extend org.teiid.translator.ws to read a complete set of records by iterating over all pages returned by a paginated webservice?
natskvi
  • 125
  • 2
  • 9
0
votes
1 answer

JBAS010473: Failed to load module for RA [webservice] and SSL configuration isn't working

I've been trying to work out how to retrieve data from a RESTful webservice in Red Hat JBoss Data Virtualization. Specifically I have to connect to a webservice that requires 2-way SSL/TLS. (2-way SSL is required since we are working with…
JBlok
  • 1
0
votes
1 answer

Unable preview data for Flat files in Jboss developer studio

I just installed JBoss developer studio devstudio-11.2.0.GA-installer-standalone.jar on my Mac. When I am trying preview data for a local flat file, I am getting a following error. org.teiid.runtime.client.TeiidClientException: …
0
votes
1 answer

JBoss Data Virt Access Using SSL

I have Data Virt running via the standalone.sh script, and can log in with my username and password. My next task is configuring it so that it automatically runs whenever the instance is up and running (without having to execute standalone.sh), and…
PyNerd
  • 645
  • 2
  • 9
  • 19
0
votes
1 answer

Getting DataVirt to Run when Instance is Started

DataVirt runs as it should when I execute standalone.sh in the DataVirt instance. Is there a way to fire it off automatically when the instance is started, so that executing standalone.sh will not be required? I believe there is a way to do this,…
PyNerd
  • 645
  • 2
  • 9
  • 19
0
votes
0 answers

DataVirt Error "MSC000001: Failed to start service jboss.web.deployment.default-host Start Exception in service jboss.web.development.default-host./"

I am trying to deploy JBoss DataVirt on a Linux site. The standalone.sh script works until it gets to the "$JAVA" JVM_OPTVERSION command after the moves of the logs to backup files. I get the error: MSC000001: Failed to start service…
PyNerd
  • 645
  • 2
  • 9
  • 19
0
votes
1 answer

Some date values off by a day in JDV

When querying a source model in a VBD, with the source database being Informix 11, the values for a date column are sometimes returned as the prior day. For example, the actual value in Informix is Oct 10, but value shown when querying JDV source…
0
votes
1 answer

is there a function to concatenate all columns in teiid?

I am trying to do a checksum for change detection on rows, so I can compare 2 tables. One way I have done in the past is by concatenation of all columns and then do a hash. How can I concat all columns? SELECT concat(*) form TABLE; does not work I…
0
votes
1 answer

Does teiid have a hash function such as md5?

I need to compare two tables of changed records, in the past I have used md5 or other hash functions on concatenated records to compare. Is the a hash/md5 function available?
0
votes
1 answer

Configuring a Data Virt resource adapter to handle an F5 redirect

How do I configure the resource adapter and/or the vdb for a url that sits behind an F5? Suppose that my resource adapter and vdb are configured to read data from https://foo.org/data?cat='pricing'&page=1&rows=20 If this is a direct hostname then…
natskvi
  • 125
  • 2
  • 9
0
votes
1 answer

Possible to reveal parameters in SQL of teiid-command log when query catalog?

I am trying to debug a tools (black box to me), that is querying the Sys catalog but not getting the metadata that it needs to. While looking into the tepid-command log I find a lot of queries with parameters shown as "?" Is there a way to reveal…
0
votes
0 answers

Extending Pagination from OData Translator to Web Services Translator

I am trying to extend the Web Services translator to have pagination like that of the OData translator, which uses the $top variable to choose the top number of results to choose, and $skip variable to choose how many results to jump over. Even…
PyNerd
  • 645
  • 2
  • 9
  • 19
0
votes
1 answer

Authentication fail using LDAP Login Module for Teiid VDB Data Virtualization

we are currently running into issues when configuring LDAP authentication for a deployed VDB, we would like to enter our active directory username and password when authenticating. We have successful configured LDAP authentication for admin console,…
0
votes
1 answer

Extending JBoss Data Virt ws translator to handle JSONP

What is the best way to extend org.teiid.translator.ws to connect to a webservice that returns JSONP (whose mediatype is usually application/javascript)? The existing ws translator can read only JSON or XML. In general, was the translator designed…
natskvi
  • 125
  • 2
  • 9
1
2 3