Using jboss dv as a ETL tool? I am not sure if I read this on JBOSS or other DV tool, but there should be an option allow you set up a schedule and do the ETL work (with simple transformation) to move data from one source to another (destination),... 
Hi All, how do I do a hash join in JBOSS DV? need to do a hash join for the two tables. How do I do it, does not seem to be able to write a query like select * From A hash Join B when I edit in the sql panel. Java client throws org.jboss.jca.adapters.jdbc.WrapperDataSource is was not a ConnectionFactory implementation exception while executing sql query Jboss EAP : jboss-eap-6.4.0 Data Virtualization Platform : jboss-dv-installer-6.2.0.redhat-3 I have created a sample Teiid project using eclipse and created a sample VDB to read data from XML fi... 
Teiid MemoryBuffer: memory management and swap Hi everyone, I'll start with explaining the scenario. I need to fill a target DB (postgresql9.4) with data coming from different sources. DV is installed on a RHEL7. I am using the 8.7.1 version. ... 
getting error while starting server hi, I'm very new to Teiid. I'm trying to move data from flat file to solr using reference https://developer.jboss.org/wiki/IntegrateApacheSolrWithTeiid?_sscc=t but i'm getting below error while starting teiid server, ... 
Scope of Local temporary table. Hi, From here Temp Tables - Teiid 8.12 (draft) - Project Documentation Editor i gathered the scope of local temporary table is per session or a block in virtual procedure. So I created a Procedure AllE... 
Limiting source in union view query Hi, I have a view in Red hat virtualization which is a union of multiple sources. I want to know how can I limit the source in a single select while querying the view. Example: Following is the t... While creating source model from JDBC source, in our case, Teradata, No columns are imported from tables We should be able to see all columns of tables that we have selected in Import Database Objects wizard. From guides menu i clicked on Create source model for JDBC source Everytime we try to import Teradata Database O... 
How to achieve restriction on table/row/column using JBoss Data Virtualization? How to achieve restriction on table/row/column using JBoss Data Virtualization? We are looking to control query data based on user roles from different source like oracle db, big data or repository etc., 
MUMPS Database access I work on system integration in a healthcare environment and most of the Electronic Health Record system use Mumps (or a hierarchical document based) system to store patient data. System such Meditech. Cer... 
JBoss DV on Windows I am new to JBoss DV. Can you point me towards some material that can help me to deploy JBoss DV on Windows? Most of the videos and tutorials I found on the website are specific to Linux. Thanks in advance. 
Saving blob/varbinary to file from VDB. Hi, I am have created a vdb using SQL Server source table as a source which stores content of file in varbinary. Does Red hat virtualization has any build in functions to query the VDB and save varbina... java.lang.IllegalArgumentException: character to be escaped is missing Hello, I am trying to create a VDB to consume a REST based Web Service, using Teiid. I was able to create the view model and the view procedure, but when I try to preview the data, i get this: "ERROR: java.lan... 
Passing User ID in sys_context from Teiid to Oracle with JDBC connection I have to pass User ID from Teiid to Oracle for VPD purpose. I have code written to set logged in user ID in sys_context's os_user. How can I implement to execute that piece of code while Teiid makes connection to Ora... 
Problem with Tranformation SQL Hi I cant generate transformation in my view model. my transformation sql is BEGIN DECLARE STRING VARIABLES.qp = QUERYSTRING((('http://localhost:8080/SeguridadAD/rest/RESTEasyLdap/getPhoto' ||... 
How to get LIMIT to work as desired w/virtual procedure? Hi there, Environment: JBoss EAP 6.1.0 (bundled with Jboss DV) Teiid Version 8.7.1 MSSQL Java 1.7.0/75 Windows 7/x64 We're trying to query from a RESTful service through to a database, limiting the... 
Jboss DV working with Impala? Jboss DV working with Impala? Does anyone has something to share so I can try this out? Thanks, Allen Simple.OData.Client Exception Hi All, We are writing a simple .NET (4.5) client App, which uses Simple.OData.Client library. Teiid server is 8.11 Final deployed on Ubuntu. The data model is fairly straightforward with two related entities F... 
Unable to query : Data source - Osisoft PI Hi, I am trying to query an Osisoft PI datasource through a Virtual Database using TEIID. Now, queries to osisoft PI must always specify the time (timestamp or a set of timestamps) for picking values (since a... 
Unable to connect to Apache HBase Phoenix from Teiid Designer Hi, We have a target to virtualize a table in hbase phoenix using jboss developer studio. We have used the following software stack: On Windows 7 1. JBoss Developer Studio 8.1.0GA 2. Teiid Designer 9.0.2 on... 
Log in to follow, share, and participate in this community.