Stack Overflow
Stack Overflow

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
0
votes
1 answer

Does function NTILE exist in JDV

I am trying to work with percentiles in Teiid, but I get the following error Query execution failed Reason: SQL Error [30068] [50000]: TEIID30068 Remote org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'ntile(ALL…
Norbert Funke
  • 36
  • 3
0
votes
1 answer

How can I specify a user or for a data source that is expecting kerberos

Scenario: User connects to JDV without Kerberos (just name and PW) jndi datasource is defined to connect with domain security jndi datasource needs different user that is kerberos aware how do I define the user at the datasource, when its on…
Norbert Funke
  • 36
  • 3
0
votes
1 answer

no user principal ad TEIID JDBC in custom translator

I have a succesful JDBC connection to TEIID using a kerberos ticket. I like to get the default principal that is in the ticket Ticket details: Ticket cache: KEYRING:persistent:6003:6003 Default principal: nfunke@FUNKE.HK Valid starting Expires…
Norbert Funke
  • 36
  • 3
0
votes
1 answer

JBoss DataVirt -- 6.4 -- connection support to MapRDB?

Is there support available or forthcoming to use MapRDB as a datasource for JBoss DataVirt?
C Carpenter
  • 21
  • 2
0
votes
1 answer

How to use ELB URLs for teiid clustering

I have configured a teiid cluster with a master and slave node where master and slave resides in two different hosts. so far I have used IP addresses of the hosts for 'management IP', 'public IP', 'unsecure IP' and in the slave host controller to…
Sanjewa Ranasinghe
  • 15
  • 1
  • 8
0
votes
2 answers

How to configure Read Only Datasource in Jboss teiid

I have configured a Redshift Datasource in Jboss teiid. I want to know how to make my Datasource Read Only. I know how make Read Only resources on VDB level using Dataroles (Ref:-…
Sanjewa Ranasinghe
  • 15
  • 1
  • 8
0
votes
1 answer

"Response is committed, can't handle exception" Error When sending the same Rest API request twice

I am using teiid Virtual Procedure to create a Rest API and expose my data. I have enabled result set caching using Cache Hints. When I send the same API request twice I get no data in the second attempt and teiid console logs the bellow exception.…
Sanjewa Ranasinghe
  • 15
  • 1
  • 8
0
votes
1 answer

Teiid Query engine modifies the optimize version of my Query to a un-optimized query when executing

I am executing fairly large SQL select queries against a redshift DB using teiid. I have optimized my query to give a better response time by avoiding using inner queries and inner select statements in my query. How ever when I execute the query,…
Sanjewa Ranasinghe
  • 15
  • 1
  • 8
0
votes
1 answer

Teiid execute immediate gives a parsing error when executing long queries

I'm using virtual procedures to expose a REST API using teiid. In my virtual procedure i am using execute immediate to execute SQL queries which takes input parameters from the virtual procedure as filters to the where clause (dynamic where cluase).…
Sanjewa Ranasinghe
  • 15
  • 1
  • 8
0
votes
1 answer

Teiid Redshift Translator does not support some of the Redshift SQL constructs

I have configured a redshift datasource in teiid using redshift traslator. But some of the SQL functions in redshift doesn't have support when using with teiid. for an example I get the fallowing error when deploying the VDB TEIID30068 The function…
Sanjewa Ranasinghe
  • 15
  • 1
  • 8
0
votes
1 answer

Teiid Transaction support in Virtual Procedures

I'm trying to execute few SQL SELECT statements inside a teiid Virtual Procedure. Does teiid have transaction support for virtual procedures. If so does it guarantee that the same database connection from the connection pool is used to execute all…
Sanjewa Ranasinghe
  • 15
  • 1
  • 8
0
votes
1 answer

Teiid generated Swagger Json file is corrupted

I have deployed several VDBs on a teiid Master slave setup in the domain mode. for an example AirFlights-vdb.xml, Customer-vdb.xml ...etc are deployed with several procedures which are exposed as REST APIs in each VDBs.I use IP:8080/AirFlights_1/api…
Sanjewa Ranasinghe
  • 15
  • 1
  • 8
0
votes
1 answer

How to get JSON response from a teiid REST service

I am issuing a SQL SELECT query against a MySQL data source from teiid and trying to get the SQL response in the JSON format. I was able to get the response in the XML format but having trouble when I'am trying to get the response in JSON format. it…
Sanjewa Ranasinghe
  • 15
  • 1
  • 8
0
votes
1 answer

What will replace RH Data Virtualization governance?

RH Data Virtualization 6.3 developer guide Volume 2 states that the governance component is deprecated. As we are interested in MDM/governance features, we would like to know if this component will be replaced or just dropped. If dropped we are…
Jim van Dam
  • 1
  • 1
0
votes
1 answer

SQL Server Linked server for data federation

I am familiar with SQL server as a product and want to use this to do data federation across a wide range of data sources that can be accessed trough linked servers. My data volumes are rather limited. However I am interested how would this approach…
OverflowStack
  • 259
  • 1
  • 3
  • 17
1
2
3