Stack Overflow
Stack Overflow

Questions tagged [teiid]

Teiid is a data virtualization system by JBoss that allows applications to use data from multiple, heterogenous data stores.

Teiid is a data virtualization system by JBoss that allows applications to use data from multiple, heterogenous data stores.

http://www.jboss.org/teiid

158 questions
0
votes
0 answers

JBoss Teiid both source model table preview and VDB test failed

Sorry, I'm no Java person. Currently I'm playing with JBoss Teiid hoping that the tool can provide us a data virtualization layer among multiple data sources. I managed to install Teiid 10.2.1 on Wildfly 11. I started to set up various source models…
dinky
  • 1
  • 1
0
votes
1 answer

Can I push down a comment in Teiid to the source query?

Is it possible to push down comments to the source database query? Given example Teiid query: select /* 'request_id' */ columnA, sum(columnB) from tableA I'd like to see the comment pushed down to the source database so that I can capture the…
user1359256
  • 15
  • 1
  • 4
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 SQL Exception - Field not Present in Groupby Clause

I have a query that uses a date_time column to produce an hour aggregation. The date_time column in aliased and present in the group by but I receive the following error: ': org.teiid.jdbc.TeiidSQLException: TEIID30492 Remote …
foobarbaz
  • 508
  • 1
  • 10
  • 27
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

Using JSON array in teiid

I am using teiid for calling REST. If one output response have a JSON array of contacts with different feilds like id,first-name lastname. What should I write in the procedure to get the JSON array. An example with my details will be very…
user8615368
  • 3
  • 1
0
votes
0 answers

Using Jboss Fuse, Is there a way to persist a flat file into a DB?

I have to persist flat file data into a MySql Db, I've tried Teiid but it just let me create the virtual DB; I want to import the file and persist it in the same process. Any idea?
Fran S.
  • 29
  • 7
0
votes
1 answer

Using ddl data in teiid

Using jboss EAP 7 and Teiid Designer 10.4 and wildfly 10. I have DDL file of MySQL .how can I make VDB using that. Can I run it using teiid? when I tried to import ddl data as Teiid ddl ,it showed parsing error,but the same was able to import as…
user8615368
  • 3
  • 1
1 2 3
…
10 11