• [newbie] expose tables through OData

    Hello, 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...
    Profile Photo
    last modified by luca-vercelli
  • OAuth with KeyCloak

    Hello 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  ...
    Profile Photo
    last modified by cjohn001
  • Teiid Spring Boot with IBMDB2

    Hi 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 ...
    Profile Photo
    last modified by 13_abhi
  • Wildfly 14 support

    Hi ,   Is Wildfly 14 supported? Or on the roadmap? If so, when?   Omar
    Profile Photo
    last modified by omarbkhan
  • Teiid Designer Dynamic VDB editor

    I 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...
    Profile Photo
    last modified by don.krapohl
  • Teiid Spring Boot-Multiple DB acces via ODATA

    I 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?...
    Profile Photo
    last modified by 13_abhi
  • Case when with aggregated subquery

    Hello, 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...
    Profile Photo
    last modified by mtawk
  • Problem while Connecting to MongoDB from WildFly - JBoss EAP

    Hello 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...
    Profile Photo
    last modified by sachinnaz9371
  • Support for "Numeric" datatype of BigQuery in Teiid

    Hi,   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...
    Profile Photo
    last modified by rujutas
  • 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...
    Profile Photo
    last modified by rujutas
  • update and delete with WHERE condition not working with Delimited flat file(header true)

    Hi Team,   We have observed that in case of Delimited Header True files at FTP/Sftp location, we are unable to execute update and delete queries specifically having where conditions. We are able to execute simpl...
    Profile Photo
    last modified by rujutas
  • TEIID15005 Error Calling HTTP Service - 401 Unauthorized

    Hi 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...
    Profile Photo
    last modified by pmthirumaran
  • Configuring multirow result for rest service

    Hi,   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 (   ...
    Profile Photo
    last modified by gadeyne.bram
  • OData behind reverse NGINX proxy

    We 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...
    Profile Photo
    last modified by marc.kusters
  • 401 Unauthorized in REST Web Service Source

    Using 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...
    Profile Photo
    last modified by vijayjose
  • Auto Generate Rest Service from DDL based VBD

    Hi,   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, ...
    Profile Photo
    last modified by gadeyne.bram
  • Teiid 11.2.0 / Wildfly 11.2 with SAPUI5 / OPENUI5 communication problem

    Hello 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...
    Profile Photo
    last modified by cjohn001
  • 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 ...
    Profile Photo
    last modified by lalitverma131
  • Teiid Designer: Unable to import foreign keys from mysql db

    Hello 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...
    Profile Photo
    last modified by cjohn001
  • Performance issue if linking ODBC datasource

    We 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...
    Profile Photo
    last modified by tomesc