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

Is there a simple way to execute a SQL script in Jboss?

I want to simple execute a Sql script against a Database in Jboss. I created a Teiid project with the datasource pointing to the source table. I don't need any field mapping, just the script execution. Thanks in advance!
Fran S.
  • 29
  • 7
0
votes
0 answers

Salesforce in Teiid

subsystem xmlns="urn:jboss:domain:resource-adapters:1.0">
user8506777
  • 43
  • 8
0
votes
0 answers

Selecting server in JBDS (Teiid)

I am using wildfly 10 JBDS 10 and and Teiid Designer 10 .when I start the default server ,it has no Teiid instance,only have overview and deployment. But if I change my server to wildfly ,I will get the Teiid instance. Why I am not getting Teiid…
user8506777
  • 43
  • 8
0
votes
1 answer

Install Teiid with jboss

I have downloaded jboss EAP 7 and installed Teiid Designer 10.4 in it. I don't know how to install Teiid. What are the zip files I need to download from Teiid. How can I install them. Thanks in advance.
user8615368
  • 3
  • 1
0
votes
0 answers

teiid doesn't connect to mysql datasource

I have a problem on connecting to a mysql datasource from JBoss EAP 6.3 with Teiid 8.10.1 copied over it. I need to mention that I've copied mysql connector driver as a module for using mysql datasource. Also, when I try with JBoss EAP 6.3…
Cristi Vlad
  • 11
  • 4
0
votes
1 answer

Spring Boot JPA with not a well known database

I am trying to write Spring Boot application to connect to a Teiid database, I want to use JPA layer on it. I have configured the JDBC Data Source, but since this not well-known database in Spring JPA libraries do not autodetect this source. I have…
Ramesh Reddy
  • 554
  • 1
  • 3
  • 8
0
votes
1 answer

Support Oracle outer join operator in JDV

Oracle defines the operator (+) for outer joins. We are trying use JDV as the source of an external product (Business Object) which uses those oracle operators. We cannot change the way that product generates the queries, and it does use the (+)…
Rafael Coutinho
  • 523
  • 5
  • 11
0
votes
1 answer

Refresh Teiid's SYS.* tables

I'm using Teiid 9.0.2 for data virtualization. I've created Datasource, deployed VDB and then created new table in datasource (MySQL/Postgresql). The new table isn't listed in VDB's SYS.Tables and SYS.Columns. Is there any way to refresh these…
Stanislav Nechutný
  • 1
0
votes
1 answer

Teiid query optimization/ Virtual datasource jasper

I have a query like this: Select A.table1.atr1, ... , B.table1.atr1 from A.table1 join B.table1 on (A.table1.atr1 = B.table1.atr2) join B.table2 on (B.table1.atr2 = B.table2.atr2) ...(some similar joins) join A.table2 on (A.table1.atr1 = …
Mehno
  • 868
  • 2
  • 8
  • 21
0
votes
0 answers

teiid data roles / anonymous user/role

I want to use the teiid data roles functionality. This works as I can enable write access etc. for an admin user only for example. Accessing the data by the oData API nicely shows an login dialog and all works. Now I want other users (anonymous…
Daniel van Mil
  • 147
  • 8
0
votes
1 answer

Can't run JasperReports Server report using Teiid as datasource

I have successfully queried Teiid 9 data source using Jaspersoft Studio, but when deployed to JasperReports Server 6.2 report throws an exceptions like this: Caused by: org.teiid.core.TeiidRuntimeException: Remote javax.resource.ResourceException:…
borobax
  • 41
  • 1
  • 8
0
votes
1 answer

org.teiid.adminapi.AdminFactory missing in teiid 8.13.4?

I am migrating an existing app from teiid-8.8.1c1/jboss-as-7.2.0 to WildFly 9.0.2 Teiid 8.13.4. I have been able to update dependencies in all cases except one: I have one class getting an Admin instance from org.teiid.adminapi.AdminFactory as…
pierus
  • 283
  • 4
  • 14
0
votes
0 answers

JBoss Developer Studio crash when save the VDB

When i create a VDB, change the JNDI name then save the VDB, my JBoss Developer Studio become crash and show the following message: How to solve the problem?
Harris Adamovic
  • 87
  • 1
  • 1
  • 10
0
votes
0 answers

What does this SQL-Server syntax do? How to convert into Teiid SQL version?

This is a part of sql syntax, CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), HIADDITIONAL, 2)) -- HIADDITIONAL is varchar What is the syntax supposed to do? Update The sql is sql-server syntax. How to convert the syntax into teiid version?
reuseman
  • 21
  • 1
  • 5
0
votes
1 answer

Teiid Data Security

To make use of vault store, have created keystore to hold application sensitive info, jdbc:teiid:Test_VDB …
Humourmind
  • 91
  • 1
  • 4
1 2 3
…
10 11