Division in MSSQL View materialization I'm using Teiid 9.0.0 with MSSQL translator. I'm materializing a simple view containing division: select Field1/Field2 as DivField From mytable Teiid query resultset metadata is returning the data type... 
Teiid embedded:Custom Translator - Access to SQL query or parsed SQL Query? In a custom translator, is it possible to get access to the original SQL query or even some sort of Object tree which represents the parsed query? The use case is that I'd like to utilize the predicates specified in t... 
How to Set Up teiid_rel:ALLOW_MATVIEW_MANAGEMENT property in Teiid Designer based VDB Hi All , How to Set Up teiid_rel:ALLOW_MATVIEW_MANAGEMENT property in Teiid Designer based VDB ? Regards Raghu 
Internal Materialization : Dependent materialized views are not getting updated consistently Hi Guys, I have a view(ex: VIEW_TOPLEVEL) in which Internal Materialization is enabled with TTL as 5 Minutes, this view is referring 3 other views (ex: CHILD_VIEW1,CHILD_VIEW2,CHILD_VIEW3) in which Internal Ma... Mongodb - criteria on ObjectId I'm using Teiid 9.0.0 with mongodb translator I'm adding a criteria over ObjectId value: select * from "testModel_gq"."Customer2" "Customer2" where "Customer2"."_id" = 'a59e3722dcfd3f5879563cf8' &... Teiid Embedded - Add new Mongodb collection I'm using Teiid 9.0.0 I'm connected to Mongodb and Teiid have successfully extracted the existing collections and add them to Teiid metadata. I need to add a new Mongodb collection to the existing ones. What is the... Teiid Embedded connect to Mongodb I'm using Teiid 9.0.0 Embedded and trying to connect to Mongodb. My Mongodb Model Meta Data deployed successfully. Is there a dynamic way to get Mongodb collections into Teiid metadata? If not, what is the best pra... odata4 navigation Hi, After implementation of TEIID-4298 it is possibile the reverse navigation using the FK. Example: Standard odata4: http://services.odata.org/V4/Northwind/Northwind.svc/Categories(7)/Products ... 
Is Teiid using XML Streaming for this View definition My view definition is as follows: CREATE VIEW TestADFView (Product_name VARCHAR(102), Date_ TIMESTAMP, Unit_price DOUBLE) AS SELECT A.Product_name, A.Date_, A.Unit_price FROM (EXEC AdfcoreSource.executeProfi... VDB to process WebService data source which responds with XML inside a String field as CDATA Hello I am trying to get hands on JBoss VDB for first time. I have a use case where need to consider a webservice as a data source. This webservice returns the data inside a String field as a CDATA. ... 
Using Teiid JDBC client driver with Teiid Embedded I have been using Teiid Embedded version in local Java Application without wildfly. Is it possible to use Teiid Embedded version with Teiid JDBC client driver? Ifo so, where can find an example? Thanks. 
org.teiid.jdbc.TeiidSQLException: Group does not exist: employee Hi, I am exploring teiid in embedded, version 9.1. vdb file: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="nothwind" version="1"> <model name="... 
How to manipulate Where clause (Condition) for query? Hello, I wanted to add a virtual column for table to show data in JSON Format. Its a common feature required for connector workflow and ended up implementing it as Delegate translator. Where i added the new Column de... 
JDBC translator treat MariaDB int/integer data type to long in importing the Metadata Create table in MariaDB like CREATE TABLE TEST_TABLE(time integer); but the teiid treat integer to long in loading the metadata and a exception thew in vdb deploying org.teiid.deployers.VirtualDatabaseException: TEII... 
.war file is throwing error while deploying why ? Hi , I have successfully created View and virtual Procedure in my project.I want the result of the procedure to be published as an API which takes an input. The screenshots are given below: The output of the prev... 
Preview Data step in Jboss Data virtualization throwing error TEIID31100.Why? The Eap 6.4 server is up and running.Test connection is also successful. The error that is thrown is also shown here. Only the address table is showing all the data but rest all the tables is not showing. The server... client failover connection settings for odbc and jdbc If using a clustered Teiid configuration, how do you specify alternate host/ports to the ODBC and JDBC connections? I've looked at both the Teiid JDBC manual and the PostgreSQL ODBC manual and can't fin... 
Execute connector methods directly Hi, I would like to execute the implemented methods of a certain teiid connector directly, without defining VDB or using a Datasource or JDBC connection. Did someone do this? Is there an example available or would yo... 
Running into issue: TEIID40095 TEIID31071 Invalid table; Table SugarCRMDataSourceJNDI_public.accounts_bugs_pkey has no columns defined I am running to issue using teiid, TEIID40095 TEIID31071 Invalid table; Table SugarCRMDataSourceJNDI_public.accounts_bugs_pkey has no columns defined. Is it a way to skip table with has no columns defined, inste... How to calculate N root of X in query Hi all, I want to calculate n√X (n root of X) in Teiid query. S= n√X Where n= 1.89 & x is any input value Looking at internet article I wrote below query Nth root of...
Log in to follow, share, and participate in this community.