Odata v2 not showing all records Currently I have the following predicament. I have a view that is comprised of multiple other views (10 to be exact). These are joined using a left outer join. The datasource is an oracle database. Whenever I ... 
Optimizations / Performance on federated scenarios Hi Guys, I was testing this amazing platform federating various datasources and I want to know if there is any standard steps to improve the performance on a scenario with multiple datasources. My execution times are ... 
Error when running Teiid Server [WildFly 9.x] I am trying to create and run a Teiid instance so that I can import and override some Teiid translators. However, when I try to run the Teiid instance I get this error: 11:27:12,352 ERROR [org.jboss.as.server] (Contr... 
Translator override breaks Teiid process When trying to override a Teiid translator to enable comments in SQL to go down to the source query (e.g. /*important info*/ SELECT 1 should show up in the source) it breaks the Teiid environment and throws an error s... 
Does Teiid Support Importing Files Under Particular S3 Bucket Dynamically? Hello, We are currently doing a POC where we have an S3 bucket. Multiple JSON files are imported into this bucket on hourly basis. The format of all the JSON files is the same. We want the newly imported JS... 
DECLARE and SET not working on VDB We are executing below on VDB: DECLARE @date DateTime SET @date = (SELECT CURRENT UTC TIMESTAMP) SET @date = dateadd(dd,-5, @date) Error Message: [Code: , SQL State: 50000] Remote org.teiid.api.exception.query.QueryPa... 
Teiid failed to deploy due to DuplicateRecordExcept We have a customer try to create virtual data source that is made of three mySQL databases. On occasion, it works, but more often than not, it does NOT work. The error says "Duplicate tables" but there do not se... 
teiid.io and docker Hi, At teiid.io I read that docker images can be obtained from https://hub.docker.com/r/teiid/teiid/ . This docker hub page does say "This image is no longer being maintained. Please utilize https://hub.docker... 
Unable to query/import multiple json loops for Rest source Hello All, Im importing Elastic Search index through Import>Teiid Connection >> Source Model>selected the data datasource Our Elastic Search index source is json file and elastic search is exposte... 
Define list of UDF in VDB definition Hi, I am trying to define multiple UDF functions in VDB definition but unable to load multiple UDF at a time, @ VDB Definition - Teiid 9.0 (draft) - Project Documentation Editor it's mentioned that we can defi... 
Data source password changes for every 90 days. Any options to have fixed login. Hello All, Q.1: We have odbc connection created on the Wildfly server and we are referencing the connection as data source. Since our odbc password changes for every 90 days, we will have to configure the conn... How to speed up TEIID loading. Hello, I have ~ 100 VDBs (most of them are just newer versions of older VDBs). All of them use just one datasource (for simpler example) - postgres database defined in standalone-teiid.xml . Why TEIID standalone (wi... 
how to configure HAProxy for load balancing with Teiid Hi, We have our teiid setup in domain mode. We want to haproxy for load balancing. TEIID40095 TEIID31079 View materialized.testViewCache is not defined by a query expression. When I tried external materialized view .I encountered a problem : 2018-07-12 16:32:31 ERROR [main] (SpringApplication.java:833) - Application run failed org.springframework.beans.factory.BeanCreationException: Erro... 
REST POST and Native Query Hi Teiid Team, 1. The oracle database supports WITHIN GROUP which is not supported by TEIID. 2. So I have written a native query which is already working. I have created CREATE FOREIGN PROCEDURE for it. 3. I... 
Jboss DV (Wildfly10.X) integration with ElasticSearch through REST Hello All, I tried to find some information online on Jboss DV integration with ElasticSearch but couldn't find any. Are there any documents or blogs that can help me to understand the Jboss DV integrati... Impersonate Oracle in the VDB Hi! I connect a vdb to oracle data base. I use a service user (or generic user) in the connection. But, I need execute some inserts with impersonate. Is it possible? Thank you. Angel 
It fails to execute Oracle database query using teiid, but is successfull with MySQL and MSSQL server database tables The below logic is good and able to connect two database tables(SQL Server and MySQL databases) using Dyanmic VDB: public static void main(String[] args) throws Exception { EmbeddedServer server = new ... 
Teiid - Deploy one table into an existing model I am using embedded Teiid 9 with Oracle translator. I have an Oracle schema with a large number of tables. I have to deploy the Oracle model at each time a new table is added and the deploy is t... 
Distinct keyword and like_regex performance is very slow I am using TEIID to connect to an nosql service, which cannot take care of distinct, so we are getting lot of records, and distinct is performed at TEIID layer. The distinct keyword and like_regex performance ... 
Log in to follow, share, and participate in this community.