Profile Photo
Hi Guys, After implementing a solution that has worked for us for a bit more than a year using Teiid Designer & Teiid on wildfly, I am thinking about updating said application. I am inclined to go with the Teiid with Spring Boot approach, which will require redefining sources and views again in Java (probably Kotlin) I know I probably could… (Show more)
in Teiid
Profile Photo
Hi, I have a requirement to add datasource that needs to keep updating if any new table is creating or table modified in source database. Basically they want this VDB to be a gateway for multiple datasource each of which can have new tables added or modified any time and it needs to show up when queried through this VDB.   I know i can created… (Show more)
in Teiid
Profile Photo
Hi Team ,   We are using teiid-engine-9.1.1 jar in one of my project and we are getting the proj4j-0.1.0 jar as a dependency in my project. Does teiid-runtime-9.1.1 required proj4j-0.1.0 jar ?. Someone can help on this as proj4j ahs vulnerabilities and wanted to remove from application Below is the pom.xml dependency <dependency>            … (Show more)
in Teiid
Profile Photo
We are encountering an error when using insert into select under SQL Server. The source table and the destination table are from 2 different databases under the same SQL Server. The exception is reproduced in the method org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(String sql) Attached is a simple test query along with… (Show more)
in Teiid
Profile Photo
Is beetle Studio still actively in development? And is it the strategic tooling for building VDB replacing Teiid designer?   Thanks
in Teiid
Profile Photo
We need to query json data file kept at any location so can you please help us, how to connect to json file using teiid.   To connect to text,csv file we were using HXTT driver but using HXTT driver we are unable to connect to JSON file.   Could yo uplease suggect any driver using which we can connect to JSON file using ftp/sftp connection.  … (Show more)
in Teiid
Profile Photo
I am trying to insert larget number of records in Mysql database via TEIID and my request is getting cancelled. Below is a complete stacktrace. The request gets cancelled after inserting 5-7 Lakh records  in single table of about 12 columns. I am multiple teiid connection through multiple threads (2-3). Not sure if that is the cause. I am using… (Show more)
in Teiid
Profile Photo
Hi I am trying Teiid to query MongoDb, the data base has 1.5M document but with indexes. My query took a long time to return data even with accessing by indexed key fields. Teiid seems to retrieve all data from DB and then filter them in the Teiid server . I tried pushdown query syntax /*+MAKEDEP*/ but it still not helping. Does Teiid MongoDb… (Show more)
in Teiid
Profile Photo
We have an issue on running Teiid docker server which use port 8080 as http service port, but another application service already using it. How can we change Teiid to listening at different port for http service? or how can we change any Teiid service port such as 8080, 9990, 31000, or 35432 to other available ports?
in Teiid
Profile Photo
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=test)   But the syntax do not got permission details. I am trying to give read only right to all the virtual views in VDB. Please provide… (Show more)
in Teiid
Profile Photo
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_content(external_file_id, content) values (?, ?)")) {     stmt.setString(1, externalFileId);     stmt.setBytes(2, content);     int result =… (Show more)
in Teiid
Load more items