Stack Overflow
Stack Overflow

Questions tagged [teiid]

Teiid is a data virtualization system by JBoss that allows applications to use data from multiple, heterogenous data stores.

Teiid is a data virtualization system by JBoss that allows applications to use data from multiple, heterogenous data stores.

http://www.jboss.org/teiid

158 questions
1
vote
1 answer

Pass OData properties through a Teiid view into a stored procedure

I'm connecting Salesforce Lightning Connect (OData connector) to Teiid. Behind Teiid is a stored proc called getCustomers which takes 3 paraneters: @field, @operator, @value. For example, getCustomers('Last_Name', '=', 'Porter'). All calls will be…
Mike Porter
  • 33
  • 3
1
vote
1 answer

Teiid: deprecated floating-point date/time format is not supported by Npgsql

I've written a C# netcoreapp 3.1 webapi app that tries to read a Teiid VDB table via Npgsql.EntityFrameworkCore.PostgreSQL 3.1.0. Whenever my app reads any data like this: _context.Campaigns.ToList(); the following error…
Luca Castelluzzo
  • 11
  • 2
1
vote
2 answers

Connect to Cloud SQL using SSL

I am trying to connect to a CloudSQL instance using the certificates provided by google namely "client-cert.pem", "client-key.pem" and "server-ca.pem". Can someone suggest what to keep in keystore and what in truststore for SSL connection using…
Manoj Majumdar
  • 505
  • 1
  • 4
  • 23
1
vote
1 answer

executebatch() of preparedstatement not returning the number of batches added

I am trying to add batches from a prepared statement for exact to 3000 times, but when executebatch() is called, the number of affected rows returned is 2048, and this happens for values add batch call statements greater than 2048. From where is the…
Manoj Majumdar
  • 505
  • 1
  • 4
  • 23
1
vote
1 answer

How can I parse a paginated REST API as a teiid datasource?

For my job I have to expose an API that will be able to gather data from multiple datasources. That's why I have to implement some data virtualization using teiid: as I am alone on this project, designing all the classes to match every json object…
Yoiro
  • 352
  • 3
  • 15
1
vote
0 answers

Connecting Teiid with Elastic Search

I am trying to connect Teiid with Elastic Search. I downloaded wildfly and teiid.jboss.org/downloads/.I don't know what to do next .The documentation is confusing please help me.
Vijay J
  • 93
  • 8
1
vote
1 answer

JBOSS Teiid error when execute VDB. error message is "Error acquiring connection profile properties"

Recently, i work on data virtualization to integrate data across division. After search on several software i decide to use Redhat JBOSS Data Virtualization because the software is open source. I have installed JDK , JBOSS Studio and Data…
ricky16
  • 11
  • 1
1
vote
0 answers

Teiid Designer: Always getting "Service jboss.data-source-config. is already registered" error when deploying vdb

when I try to deploy a new virtual database (Teiid9TestConnection_DS is the datasource name, a local MySQL datasource for testing) I always get the following error, even at the very first deploy attempt: ERROR…
Sembee
  • 11
  • 3
1
vote
0 answers

Apche JENA's integration with data virtualization tools

Anybody did any implementation of Apache JENA on top of RDF models(using R2RML mapping) created from Virtual Databases in Data Virtualization layer. I am specifically looking for integration with JBOSS-Teiid, Apache JENA, R2RML mapping. Any…
shakti prasad mohapatra
  • 11
  • 3
0
votes
0 answers

TEIID Spring boot integration with two sql server. QueryParserException

I am getting below error when trying to fetch data from two different mssql servers: TEIID31100 Parsing error: Encountered "SELECT id, [*]parameter[*], value" at line 9, column 12. Was expecting: "char" | "date" | "time" | "timestamp" | "cast" |…
SamanthPadala
  • 41
  • 2
0
votes
0 answers

insert a large amount of data into RDB tables in Teiid

does someone know how to use SQL sentence, like "insert into table values (...) select ... " in teiid to insert large-scale data into relations/tables of RDBs as effect as jdbc batch? -Zhen In a task, I need to first use SQL select query to collect…
Zhenzhen Gu
  • 1
0
votes
0 answers

Saving file in Teiid VDB

I'm accessing a Teiid VDB and doing some queries, but I don't know how to generate a file with the contents of a single variable defined in a PL script: BEGIN DECLARE string csvLine = ''; DECLARE string csvFile = 'C:/queryResults.csv'; LOOP ON…
Renata Mesquita
  • 105
  • 1
  • 13
0
votes
0 answers

How use Hibernate Envers with Teiid

I have a problem with the integration of hibernate envers on a application that use Teiid. This one doesn't support ddl like 'create table TABLE_NAME_AUD' or sequence generation. I tried to split entity manager and tranction manager and delegate…
nick-cloud
  • 1
0
votes
1 answer

Conversion Error in TEIID during function call

I have following function defined in a java jar file within the vdb folder: public static Blob createSampleLogCurve(String indexType, String indexUnit, String curveName, String curveUnit, String curveDataType, Object depthArray, Object valueArray)…
ASAFDAR
  • 19
  • 1
  • 7
0
votes
0 answers

TEIID40007 Keepalive failed for session

I am trying to connect to federated vdb via Spotfire. I keep getting following error after fetching 200K plus records. There total of 3M records in the view TEIID session timeout has no limit. TEIID40007 Keepalive failed for session E0NBLogYqzk3 I…
ASAFDAR
  • 19
  • 1
  • 7
1
2
3
…
10 11