• Create  a JDBC Connection to SQL 2016 SP 1

    I am trying to create JDBC connection to SQL Server 2016. Got the JDBC drivers  as per the link:   Download Microsoft JDBC Drivers 6.0, 4.2, 4.1, and 4.0 for SQL Server from Official Microsoft Download Cent...
    Profile Photo
    last modified by George Varghese
  • Red Hat JBoss Data Virtualization developer forum is now read only

    Hi Everyone,   We want you to have the best experience in getting your questions answered. We believe StackOverflow's Q&A format, along with it's features and moderation, will reach a broader community of dev...
    Profile Photo
    created by Heinz Windzio
  • Creating a WSDL in Teiid

    Hello, I am new to creating Web services in Teiid, I was looking at some ways to create it and I found this documentation: Chapter 11. Web Service Wizards   I've followed all the steps and my Web Services bri...
    Profile Photo
    last modified by Cristopher Torres
  • Support in Registry Replication

    Hello, We have a table of clients in three different databases which we have integrated and created a single client table using a Select Union, as a result we have something like this:   ID   ...
    Profile Photo
    last modified by Cristopher Torres
  • Import Web Service Source (SOAP)

    Dear all, I'm trying to create a new data source starting from a wsdl file (it attached here). When i'm testing the wsdl file, Teiid Designer validate it but i don't see the endpoints and related bindings.   &l...
    Profile Photo
    last modified by Giuseppe Lastella
  • Update query to execute a method on a external Rest Controller via VDB

    Hello to all,  I developed a VDB that exposes a REST service as a Datasource. With a select on a view now I can invoke the Rest controller and get a result set. Now I'm looking for a way to invoke a method on the...
    Profile Photo
    last modified by Cristiano Limiti
  • The Primary Key must reference 1 or more columns; there are none

    Hi Experts,   I created the datasource of sqlserver 2008 in the teiid designer(jboss developer studio).   and then I selected the tables as the metadata , every tables were listed in the left sources folde...
    Profile Photo
    last modified by andy zhu
  • teiid caching and performance optimization parameters

    Hi,   I'm developing a data virtualization layer using teiid which will serve data to the front end side. I need to performance tune teiid to access large volume of data and provide the result data to the front ...
    Profile Photo
    last modified by Sanjeewa Ranasinghe
  • Ambiguos group error on query

    Hello, I have created a VDB that contains a data source (data_source.xmi) to a oracle database with JDBC connection. In the VDB there is a "metadata model" of type View that maps the JDBC data source. By running a q...
    Profile Photo
    last modified by Cristiano Limiti
  • Where to find teiid caching underliying implementation details and memory management details

    Hi,   I have fallowed teiid documentation and teiid caching guide in-order to implement caching in my VDB's. Where can I refer for more details on the underlying implementation details about teiid caching.  ...
    Profile Photo
    last modified by Sanjeewa Ranasinghe
  • Error when trying to access the buffer manager

    Hi,   I have set up teiid server in domain mode and deployed it as a container using rancher. when i try to access buffer manager in the CLI using the command "/subsystem=teiid:read-resource" i get the fallowing...
    Profile Photo
    last modified by Sanjeewa Ranasinghe
  • Teiid does not recognize "CONVERT"

    Hi, I have a problem when using "CONVERT": CONVERT (INT, FIELD) for some reason teiid does not recognize the sentence
    Profile Photo
    last modified by Cristopher Torres
  • How Create Relational Native Query Procedure

    Please.. I wish an orientation about how can I use the option "Create Relational Native Query Procedure" on Sources. I am trying to test it in diferents ways but it doesn't work. Please, do you have any simple exampl...
    Profile Photo
    last modified by Cristopher Torres
  • vault error when installing jboss-dv-6.3.0-1 (using standalone jboss eap 6.4.0)

    Hi,   New to this and trying to setup my dev env on my laptop with windows installed openjdk 8 and also jdk1.8.0_121 installed the jboss-eap-6.4.0.zip  --able to start my server   now I am trying to...
    Profile Photo
    last modified by chitra rama
  • How intrusive is the DV at the time of a consultation?

    Hello we want to see if the DV is intrusive with the source databases at the moment of making constant queries.
    Profile Photo
    last modified by Cristopher Torres
  • TEIID development for rest services without VDB

    Hi, I am a requirement to send query directly to rest service with filter without using VDB. because i have huge dataset and i dont want all data to be fetched. pls assist.
    Profile Photo
    last modified by wickram singh
  • Problem displaying date

    Hello! I am making a connection to informix, I have managed to connect and extract the data from the sources. I have already prepared the data and even modified the driver to be compatible with JDBC4 to be able to dep...
    Profile Photo
    last modified by Cristopher Torres
  • Does teiid has  ODATA support for aggregation functions. Is there any other way to pass GROUP BY {parameter} dynamically through an application request

    I want to use a group by query against a data source, but the group by {column} needs to be dynamically passed through a application request. I did not found any document regarding ODATA support for this. Is this a li...
    Profile Photo
    last modified by Sanjeewa Ranasinghe
  • Re: How to connect to MySQL data source using teiid data source builder

    Create datasource in your WildFly, then use the data source builder.
    Profile Photo
    last modified by Ramesh Reddy
  • How to connect to MySQL data source using teiid data source builder

    Hi,   I am trying to create a data services Rest API between db and application layers. Is teiid data services builder the best way to do this. then how do I connect to MySQL data source using teiid data service...
    Profile Photo
    last modified by Sanjeewa Ranasinghe