Log in to follow, share, and participate in this community.
Thread [newbie] expose tables through OData
[newbie] expose tables through ODataHello, I am completely newbie to Teiid framework, and also to Wildfly. My goal is to expose a (large) number of tables of my database via OData protocol. (Tables are not and must not be mapped to any JPA class...
OAuth with KeyCloakHello Ramesh, I have some problems with the description to build the keycloak teiid adapters for oauth and do not get it running. I followed OAuth2 Based Security For OData Using KeyCloak · GitBook ...
Teiid Spring Boot with IBMDB2Hi All, I have configured my spring boot application with IBMDB2 to access data using ODATA protocol. i am able to get the metadata information using the URL, but unable to access any tables. Furnishing the ...
Teiid Designer Dynamic VDB editorI know per the roadmap we're headed toward more support for dynamic virtual databases but I don't see any jira stories for dynamic vdb (-vdb.xml) editor support. It would be an excellent feature to be able to ed...
Thread Teiid Spring Boot-Multiple DB acces via ODATA
Teiid Spring Boot-Multiple DB acces via ODATAI would like to configure multiple databases in teiid spring and need to know how to access via ODATA. For Ex: Suppose i have same table name say table 1 in DB1 and DB2, how i can differentiate ODATA urls?...
Case when with aggregated subqueryHello, I migrated lately from Teiid 9 to Teiid 10.2.1. I have the below simplified query using oracle translator that works with Teiid 9 but not with Teiid 10.2.1 The issue happens when having a case when expressio...
Thread Problem while Connecting to MongoDB from WildFly - JBoss EAP
Problem while Connecting to MongoDB from WildFly - JBoss EAPHello Team, From last few days a try to connect mongodb nosql with wildfly - JBoss EAP. Download some setup for same - a.Quick starts for http://teiid.jboss.org/ Download quick start set up from https://gith...
Thread Support for "Numeric" datatype of BigQuery in Teiid
Support for "Numeric" datatype of BigQuery in TeiidHi, I am trying to make a connection to BigQuery using Teiid, and turns out if we have a column with datatype as "Numeric" (which is a latest datatype introduced in BigQuery), Teiid throws a QueryParserExcepti...
Thread Unable to set value for YEAR datatype in MySQL.
Unable to set value for YEAR datatype in MySQL.Hi, I am trying to insert data into a column of type "YEAR" in a table in MySQL database using Teiid. When I try to string in the year field it gives me the following error :- Caused by: org.teiid.core.TeiidProcess...
Thread TEIID15005 Error Calling HTTP Service - 401 Unauthorized
TEIID15005 Error Calling HTTP Service - 401 UnauthorizedHi All, I am new the JDV and consuming the Restful web service as my data source. we are passing the 'authorization' as a key and value as 'bearer token' through the header. After import, Test the connec...
Thread Configuring multirow result for rest service
Configuring multirow result for rest serviceHi, I'm trying to configure a REST service in Teiid. I have this procedure definition: CREATE PROCEDURE restnumber()
RETURNS TABLE(
nr integer not null
)
OPTIONS (
...
OData behind reverse NGINX proxyWe got the following situation; Our servers use NGINX as a SSL terminating reverse proxy in order to handle our SSL requests. Situation sketch: Outside Interwebs 443 -> NGINX -> EAP/Teiid 8080 Thi...
Thread 401 Unauthorized in REST Web Service Source
401 Unauthorized in REST Web Service SourceUsing jboss EAP 7 and Teiid Designer 10.4 and wildfly 10. Using Web Service Source-Source and View Models(REST) How to Consume a JSON REST Web Service in Teiid Designer . REST api is workin...
Thread Auto Generate Rest Service from DDL based VBD
Auto Generate Rest Service from DDL based VBDHi, I'm wondering if this should work with a DDL based VBD. In my schema I have this to declare some virtual view. SET SCHEMA izisviews;
CREATE VIEW tv_numbers (
nr integer not null,
...
Thread Teiid 11.2.0 / Wildfly 11.2 with SAPUI5 / OPENUI5 communication problem
Teiid 11.2.0 / Wildfly 11.2 with SAPUI5 / OPENUI5 communication problemHello together, I am trying to use SAPUI5 in a Single Page App to display data from a TEIID VDB. When SAPUI5 ODATA V4 data model is bound to the odata service I run into several errors. One note on that, I connect vi...
Thread set non static parameters in the non-pushdown udfs
set non static parameters in the non-pushdown udfs Hey, we are using teiid along with some encryption code and wanted to have the support of java udfs with non-static external parameter which can change for each call of the udf. for ...
Thread Teiid Designer: Unable to import foreign keys from mysql db
Teiid Designer: Unable to import foreign keys from mysql dbHello together, I am trying to import a mysql database scheme as datasource with Teiid designer. Unfortunately, the importer always throws a warning of type=Problem "The uniqueKey is required". After import all...
Thread Performance issue if linking ODBC datasource
Performance issue if linking ODBC datasourceWe access our database with a self-written resource-adapter/translator and are using the plsqlodbc driver (v9.6.5) for MS Access. If we limit the metadata in the VDB it works fine so far, but if we provide a huge amo...