Log in to follow, share, and participate in this community.
Thread Embedded Teiid security based on standard XML config files
Embedded Teiid security based on standard XML config filesHi, We have been using a custom solution inside Teiid for the authentication/ authorization processes. Can we use the same config files we use in the standard version instead? We are thinking the way an AD ca...
Log4j 1 and 2 Teiid Logger implementationsHi All: I use Teiid Embedded in two projects. One with Log4j 1, and the other with version 2. I see inLogging in Teiid that Teiid supports Log4j 1 but I do not see this Logger implemetation in Teiid Em...
Thread datasource selection according to the caller user
datasource selection according to the caller userHi, Thanks for your precedent questions! Thanks to them we are making very good progresses. We are working with the embedded version of Teiid (dynamic vdb). We would like to manage the access control ...
SAP HANA DatasourceHi, We have got a very interesting task. We have to retrieve data from SAP HANA (Trial). As well as I know we do not have an sap hana translator and I tried with the oracle and hsqldb translators instead. In b...
Impala datasourceHi, When trying to retrieve data from Impala we experience that: - Teiid can connect to the 'default' database in Impala and retrieve tables from the 'default' database - Teiid can't connect to any newly cre...
Loop issue in ProcedureI'm having an issue I can't figure out if I'm doing something incorrect or there's a bug.. BEGIN DECLARE string VARIABLES.ExecSTring; DECLARE string VARIABLES.WhereClause; DECLAR...
Thread convert a comma separated string to json array
convert a comma separated string to json arrayHello, I have created a virtual view where i concat two fields and get a single comma separated field. now i am trying to convert this string to a json array value of field i have is -> "one, two" ....
Thread Access to original SQL from ExecutionFactory
Access to original SQL from ExecutionFactoryHi, Is there anyway to get hold of the original SQL sent to Teiid (parsed or unparsed) from within ExecutionFactory.createExecution? I.e. before it has been rewritten by Teiid. It may be accessible fr...
NOT IN construct behaves inconsistentlyHi everybody, I am experiencing an inconsistent behavior of the NOT IN clause when NULL values are returned by the subquery. For example, I have the following two tables defined in a PostgreSQL datasou...
How to get User IP when it logon failureWhen log in successfully to Teiid, we can see info in security.log: 2015-09-02 05:59:42,987 INFO [org.teiid.SECURITY] (New I/O worker #4:) Logon successful, created session: sessionid=bFfMzaKOOmYQ; userN...
Thread Question regarding transactional behavior while writing to VDB
Question regarding transactional behavior while writing to VDBHi, I am trying some scenarios where I am writing to a VDB. I have integrated Atomikos as the transaction manager while starting the Teiid Embedded server. When I call a commit() from my application, I can se...
Embedded Teiid authorization (dynamic mode)Hi, Previously, I got the right answer about how to create a custom authentication mechanism inside a dynamic approach, thanks. For authorization, I understand we can use the database privileges and it...
Can't resolve teiid-parent maven heirarchyHi, What do repositories must I add need to enable consumption of teiid-admin via maven? Why does a released version of teiid depend on a pre-release ancestor pom? org.jboss.as:jboss-as-parent:pom...
Embedded Teiid security (dynamic approach)Hi, In my company we are evaluating the leverage of the embedded Teiid. It looks quite promising and now we have to configure authentication and authorization. We have an Active Directory that we would like t...
Thread Data Not getting parsed for complex type in Odata
Data Not getting parsed for complex type in OdataWhile retrieving the table data from SAP using Odata, it doesn't display the data for complex type, as it is not getting parsed . It throws error Type not found "RMTSAMPLEFLIGHT.FlightDetails" After l...
Thread How to improve max socket connections for Teiid
How to improve max socket connections for Teiidwhen I use server as: 2cores 8G, the Teiid can support around 500 connections, then it will throw the connections reset error but when I upgrade server to: 8cores 16G, the connections seems are also 500 connections...
materialized views in Teiid embeddedI want to update materialized view in Teiid embedded for data addition/update in source data though listeners running with embedded teiid. Listeners would subscribe events of source data. So matarealized view update i...
Thread conversion of static vdb (xmi) into dynamic vdb
conversion of static vdb (xmi) into dynamic vdbHi all, I am starting using Teiid Embedded. I have some question. 1. Can static vdb (xmi) files be converted into dynamic vdb (xml) ? 2. Can static vdb be used/deployed in Teiid embedded server? how i...
Thread how to make a update call to a view table by odata URL
how to make a update call to a view table by odata URLHello, I am trying to update one column of a view table. I have below queries in my Select and Update tabs of my transformer editor. Select Tab- SELECT column1, column2 FROM &...
Thread TEIID16012 and TEIID16011 while retrieving data from View
TEIID16012 and TEIID16011 while retrieving data from ViewIn the attached project, I have build a view LinkFileTrain.xml with a table TrainFileView. There is a transformation query which I have written like SELECT train_id AS train_id, dst_id AS filename ...