Add data role Hi Team, I am programatically adding a data role via CLI. I am using below CLI syntax... /subsystem=teiid:add-data-role(vdb-name=AdminAPITestVDB, vdb-version=1, data-role=TestDataRole, mapped-role=t... 
Teiid is throwing java.lang.OutOfMemoryError while loading maximum data. Teiid is throwing java.lang.OutOfMemoryError while loading maximum data. When we are trying to load around 10 lacks records through Teiid. its throwing java.lang.OutOfMemoryError. We have also tried to increa... 
Insert into postgres bytea Hello, i'm trying to insert a file into postgres bytea column using teiid-client 10.2.1. If i insert via `setBytes` like this try (PreparedStatement stmt = con.prepareStatement("insert into wpp_file_co... 
Is there any limit on number of VDBs creation on Teiid when max heap size is set to 4GB? When huge number of VDBs and datasources are deployed on Teiid then at some limit it goes Out of memory. It is not feasible for us to increase the heap size or do any memory configuration everytime to handle Ou... 
teiid - EmbeddedServer - Cache issue after Spring boot migration We use the embedded server in our project with spring 4.x, running well. The server configuration is good in the above setup. EmbeddedServer server = new EmbeddedServer(); loadDeaultFactories(); Embe... 
User Roles not mapped in Security Context Hello, I am trying to build an application using Teiid's Embedded Runtime. I have been facing issues on applying the data roles to my vdb. I have been trying to map data roles to my users with specific roles t... 
Is Teiid provide any API for validating data before actual insertion? Hi Team, There is a facility of implicit and explicit casting in every database. If my target column's datatype mismatch with data I am trying to insert then teiid throws following error on runtime: Caused by... UUID type in Postgresql Hi, i'm trying to find out how to teach Postgresql datasource translator to work correctly with UUID datatype. Teiid sees it as Object instead of, for example, String datatype. It causes one can't do any ordering/whe... 
Teiid rest with nested data Hi How one can define view for rest based services with data coming as nested i.e objects layers.Sample like { "productId":10 "productName":"milk" orders:[ ... 
Model Type when to use Virtual Procedure,Foreign Procedure,View,Physical Hi Is there any guideline for defining model of different type? Like when to use VIRTUAL PROCEDURE,FOREIGN PROCEDURE and so on. What I understood for relational database we use PHYSICAL but for Rest like datas... How does Teiid consume paged OData service(s) Hi all, How would Teiid handle the consume of a paged OData service? We experience a case where a consuming odata service is running out of memory because the response holds too many objects. We want to add p... 
Http Management API - Teiid Runtime Operations Good day I need some help retrieving the metrics data about teiid specific processes. Specifically the metrics found in the Jboss 6.4.0 Runtime tab > Teiid. (or wildfly) In the CLI its easy... 
Bigquery connection taking too much time while deploying vdb Bigquery connection taking too much time while deploying vdb: We are using 10.2.1 version of teiid and to connect to Big Query we are using Simba driver and successfully able to connect to Bigquery: Using jdb... Rest with Token based authentication Hi Is there any example where I can get some idea how to define teiid model for rest based service which first execute another rest service to get a token and subsequently use that token in header for further... Limitations of Teiid... Hi, Can someone provide me with a link or site that lists limitations or restrictions of Teiid, this will help me to decide whether or not I should go for it... Thank you, Purnima Das 
Teiid in production? Hello, I am new to Teiid, however, a few days back I downloaded Denodo Express 7.0 Data Virtualization Server and implemented a test case successfully. I want features that Data Virtualization Server provides,... Incoming OData connetion doesn't work I have a running VDB which I can successfully query though Teiid's JDBC connection. I was expecting to be able to query it with OData/REST, as per this article: OData Support - Teiid 9.0 (draft) ... 
Teiid VDB XML schema Where can I get the teiid XML schema information? How to connect Teiid Designer with dockerized Teiid instance Hello, Can Teiid Designer work with dockerized standalone Teiid instance? If yes, is there any manual describing config steps in detail? Just following the same sequence of steps as with locall... Source Details for Dyanmic VDB. Hi Team, We are having a Dynamic VDB. We need to know the below details of Dynamic VDB for all the models via Java Code... 1. What are the table the model refers in source for each model. 2. What are...
Log in to follow, share, and participate in this community.