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

Error in executing query in JBDS (Teiid)

I am using JBDS 10.4 with WildFly 10,Teiid Designer 10. Successfully made a VDB by following the link: https://developer.jboss.org/wiki/SalesforceAsARESTServiceUsingDataVirtualization?_sscc=t When running on browser getting notfound error…
Vijay
  • 53
  • 5
4
votes
1 answer

Join multiple concatenations of attributes with node values using xpath In Teiid

This is a very copy of my question posted here I only need to notice that this is happening in the XMLTABLE of the teiid engine. I'm parsing the following xml content:
Eugene Bykov
  • 133
  • 8
2
votes
1 answer

Wildfly + SQL Server connections closing randomly and not recovering

I'm getting random "connection is closed" in Teiid 13.1.0 to SQL Server: 2021-01-08 10:20:23,949 DEBUG [org.teiid.COMMAND_LOG.SOURCE] (Worker513_QueryProcessorQueue9800) Cz9nti5G/vUr ERROR SRC COMMAND: endTime=2021-01-08 10:20:23.949…
Mike Porter
  • 33
  • 3
2
votes
1 answer

How to connect to teiid VDB in python

I need to connect to teiid datasource in Python and execute procedure, are there any libraries to connect to teiid VDB?
Vaibav
  • 77
  • 1
  • 7
2
votes
1 answer

Not able to run command (Teiid)

Not able to run this command after started server in Teiid Designer. /bin/jboss-cli.sh --file=bin/scripts/teiid-standalone-mode-install.cli Is there any other methods to add Teiid. I am also not getting the Teiid instance in…
user8506777
  • 43
  • 8
2
votes
1 answer

Adding Teiid to JBDS

I am trying to connect JBDS with wildfly server. I am not getting the Teiid instance in JBDS. What are the values for username and password in managment login credentials? What are the values for username and password under JDBC connection. Do I…
user8506777
  • 43
  • 8
2
votes
0 answers

How to use a war for Rest API in wildfly

I have a war file consisting of my spring programs. I want to use it in wildfly 10. Deployed it in server successfully. What are the next steps to be followed to use the war file. I am using Wildfly 10 Jboss AS 7.1.1 JBDS 11
Vijay J
  • 93
  • 8
2
votes
2 answers

How to return count from ODATA result set

I am trying to get a count of my records from an Olingo ODATA (version 2) result set similar to the one below: http://services.odata.org/OData/OData.svc/Categories/$count The above url returns 3, and there are 3 'values' as you can see if you remove…
Ben Taliadoros
  • 7,003
  • 15
  • 60
  • 97
2
votes
2 answers

How to expose Stored Procedure in Teiid OData

I have created a virtual procedure in JBoss Teiid ,i want to call it using odata protocol. I have tried to call it by .....url/odata/PROCEDURE NAME It is not working . Can anyone please tell me the corect syntax to call stored procedure in odata.
madhurika
  • 191
  • 1
  • 8
2
votes
2 answers

Viewing SYS schema tables of JBoss EDS/Teiid VDB

Can someone help me understand how to expose the SYS schema objects of a JBoss Teiid Virtual Database when connected via an ODBC-JDBC bridge ? The client is connecting to ODBC side of the bridge and the JDBC side of it is connecting to the Virtual…
vbchin2
  • 21
  • 1
1
vote
0 answers

Multi-tenancy using Teiid Spring Boot

I am working on a Teiid Spring Boot application and would like to implement Multi-tenant architecture. Teiid Spring Boot is able to connect to two different datasources DS1 and DS2 but as Teiid vdb gets deployed during startup, I have to pass…
Hemant Rajput
  • 259
  • 2
  • 14
1
vote
1 answer

How to configure a ODBC connection to teiid on rhel8? GSSAPI negotiation fails

I have a default Teiid 12.2 installation on RHEL 8. Now I'm trying to configure an ODBC connection that would be used by PHP. This always results in an error "[unixODBC]received invalid response to GSSAPI negotiation: R" This is my ODBC…
gadeynebram
  • 725
  • 2
  • 6
  • 22
1
vote
1 answer

Unaccent() function alternative in TEIID

We have a need for accent ignoring search in our application for Europian audience. Does TEIID offer an alternative to the function mentioned here? TEIID doesn't recognize this function: TEIID30068 The function 'unaccent(text)' is an unknown form.…
Martin Maťko
  • 21
  • 2
1
vote
1 answer

Using default values in TEIID throws TeiidSQLException

I'm getting following error: Caused by: org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "insert into \"form\".\"form_insertdefault_1\" [*]default[*] values" I need to fill table with only default values and manual insert…
Martin Maťko
  • 21
  • 2
1
vote
1 answer

Teiid - Changing behavior of User Defined Functions after created

I'm with difficult to work with User-Defined Functions in Teiid. The issue is about changing the behavior of the functions and reply to Teiid. It did this function in PostgreSQL. create or replace function test() returns varchar language plpgsql as…
Rebelo
  • 11
  • 1
1
2 3
…
10 11