Profile Photo
Hello together, I am trying to implement a full text search with Teiid, preferable in a materialized table. I have a mysql database below Teiid which supports FULLTEXT indexes which are used with a MATCH ... AGAINST syntax. When extracting the db schema with Teiid Designer, Designer seems to generate a standard index for the relevant text field… (Show more)
in Teiid
Profile Photo
Hello together, I am currently trying to understand how to deal with exception handling and would like to ask for some advice as it seems I do not get exceptions from the underlaying datasource forwarded. Here is an example from a view in which I have tried to implement exception handling     CREATE TRIGGER ON Diary INSTEAD OF DELETE AS    … (Show more)
in Teiid
Profile Photo
Hello together, I am trying to add the Teiid Wildfly console to my docker image. I follow the docker file from Ramesh at   teiid/Dockerfile at master · jboss-dockerfiles/teiid · GitHub   and added the console overlay by   COPY --chown=jboss:jboss dist-$TEIID_CONSOLE_VERSION-overlay.zip $JBOSS_HOME RUN cd $JBOSS_HOME \     && bsdtar -xf… (Show more)
in Teiid
Profile Photo
Hello together, I am trying to create a fine grained access priviledge for the following table:   CREATE FOREIGN TABLE UserDefinedProducts (      fkProduct long NOT NULL OPTIONS(NAMEINSOURCE '"fkProduct"', NATIVE_TYPE 'BIGINT'),                                     # foreign key to some product id in Products table      fkProfile long NOT NULL… (Show more)
in Teiid
Profile Photo
Hello together, I recently read this article about future development of Teiid https://teiid.io/blog/post-11-20-18/  and I am wondering if Teiid Wildfly in the meantime provides a metrics interface to be scraped with Prometheus or if there might be a plugin available  which implements such an interface. Thanks for the info.   Best regards,… (Show more)
in Teiid
Profile Photo
Hello together, following the description here MySQL Translators · GitBook I am trying to set the useCursorFetch property on a XA datasource. Unfortunately I have not found a description yet how to do this. I solved the topic for an non-XA datasource as follows:     $JBOSS_CLI --connect --command="data-source add \     --name=${DB_NAME} \    … (Show more)
in Teiid
Profile Photo
Hello together, I am currently trying to get stored procedures via odata working. I am not sure if I am doing something wrong or if I am hitting a bug in TEIID. I ran into one issue as described below and have a couple of questions regarding stored procedures via Teiid Odata in general. I hope you guys can shed some light to the context.   1.… (Show more)
in Teiid
Profile Photo
Click to view larger imageHello together, as I am currently having problems to get expand operations efficiently working with Teiid ontop of a mysql database, I tried to create a view table which holds the joined data to let mysql handle the join operation rather than Teiid. Unfortunately, when using "Teiid Connection >> Source Model" the view table from my database is… (Show more)
in Teiid
Profile Photo
Hello together, I  have some trouble to get a query working, maybe someone can help me with the syntax   I have two Tables here   Diary - idDiaryEntry -fkIdProductCode (which is the foreignKey to the primary key of an Item in second table)   FDBProducts -idCode (primary key) -product_name   The expansion via the navigation property… (Show more)
in Teiid
Profile Photo
Hello together, I have a question regarding security in stored procedures. I have written a stored procedure which should update some configuration values of a user. Let"s assume the following example. I have a table with configuration records. Each user has 7 records for each day of the week in this table which has a column param that can take… (Show more)
in Teiid
Profile Photo
Hello together, I have a question regarding the usage of Teiid Designer. When I import a source model from my database  I do this via Import / Teiid Connection >> Source Model The dialog which opens has an option "Import Indexes" which by default is set to false. I never switched it to true so far. However, the indexes in my model are so far… (Show more)
in Teiid
Load more items