• Text File as a source - example including Model Project Set

    Text File as a source - example including Model Project Set   A Teiid Designer Model Project Set is attached, which demonstrates how to connect to a file data source in Teiid Designer.  Download the attachm...
    Profile Photo
    last modified by mdrillin
  • Teiid Designer - Sample Data

    Teiid Designer - Sample Data   We have compiled some test data for your convenience and made it available through the links below.  This test data may prove useful when exploring our Teiid Designer Examples...
    Profile Photo
    last modified by mdrillin
  • How to create a new Web Services Data Source (OData) connection profile

    Hi   I have a procedure getbook(TEIID Webservice model operation) . I can see that exposed on OData as follows When I try to create a OData connection profile or use importer to create models I am unable to reg...
    Profile Photo
    last modified by teiidjbossuser
  • How to create Teiid server instance and preview data

    Dear all,   I created the example ClimateZoneVIEW which is about reading the flat file ClimateZone.   However I can not get the Preview Data working . The main reason is that I do not understand what type ...
    Profile Photo
    last modified by dgaethofs
  • Teiid Designer as modeling tool?

    As you probably already know, we have extensive experience using Teiid as a data virtualization engine.  As our project matures, we are moving into the world of modeling.  In particular, we want to produce a...
    Profile Photo
    last modified by markaddleman
  • VDB Web Service WAR Generation Failed

    Hi Team,   I am facing a strange problem in using Teiid Designer in JBoss Developer Studio 7.0.0 GA. I can model VDB and generate WSDL WAR when the JB Studio is used in Windows 7 PC. But when i try to do the sam...
    Profile Photo
    last modified by ranjith123
  • Utilize the MySQL database on OpenShift Data Virtualization in Designer

    Utilize the MySQL database on OpenShift Data Virtualization in Designer This article will show you how to utilize the MySQL database on your OpenShift Data Virtualization instance.  We'll guide you through the s...
    Profile Photo
    last modified by mdrillin
  • Provision Data Virtualization on OpenShift and Connect from Teiid Designer

    Provision Data Virtualization on OpenShift and Connect from Teiid Designer This article will show to how to provision an instance of Data Virtualization 6.0 on OpenShift and connect to it from Teiid Designer / JBoss ...
    Profile Photo
    last modified by mdrillin
  • Provision Data Virtualization on OpenShift

    Provision Data Virtualization on OpenShift online This article guides you through the process of provisioning a Data Virtualization instance on OpenShift online.   1. Get your free OpenShift Account Sign up ...
    Profile Photo
    last modified by mdrillin
  • VIEWS removed

    I've recently noticed there are no longer object types of VIEW in designer I'n not sure when exactly it happened but I've only now been impacted.  When an enterprise has a metadata managment solution quite often ...
    Profile Photo
    last modified by virtualdatabase
  • Odata query to call a stored procedure

    I have imported a stored procedure from my database (lets say , abc) in my Source model in Teiid. I have created a view for this procedure (lets say , abcView), for which VDB has been created (abcViewVDB). Now i wan...
    Profile Photo
    last modified by madhurika_sharma
  • Salesforce as a REST service using Data Virtualization

    Salesforce as a REST service using Data Virtualization This article will guide you through the Teiid Designer steps to expose a select set of Salesforce data as a REST endpoint.  This article demonstrats using a...
    Profile Photo
    last modified by mdrillin
  • join query is not working in teiid designer 8.4.

    I am trying to join two tables . One table is from oracle and other is from db2. I am getting parsing error : TEIID31100 Parsing error: Encountered "db2.id=ora.id [*]_[*]__" at line 7, column 1. Lexical error. Charac...
    Profile Photo
    last modified by lx_r
  • Ability to add criteria at model level..

    Just wondering if anyone has encountered this..   When modeling I always make a 1:1 view model above the physical then I create another view model above that, where semantics come in to play. I have come to rea...
    Profile Photo
    last modified by virtualdatabase
  • Problems updating model in the designer

    When I remove one of the existing objects in a view model in VDB the designer clears out transformation and mapping for all other object in that view model and shows error.   I tried, Clear the transformation ma...
    Profile Photo
    last modified by skethire
  • Finished Teiid Designer Project - Now what?

    Hello,   I've created a project succesfully integrating several DBs. Now how do I produce a single war to deploy it to my Jboss Teiid Enabled server? Do I always have to use the whole development environment? &#...
    Profile Photo
    last modified by kondylak
  • Consume WSDL web service - Preview always returns null results

    I 'm experimenting with Teiid Designer 8.3 and I'm trying to consume a SOAP based web service. I can select the operation I need and all proceed smoothly until I decide to preview the data. It always returns NULL wher...
    Profile Photo
    last modified by kondylak
  • Teiid Designer can't create a Teiid Execution Plan for a DB2 source model

    I am getting the error: org.teiid.jdbc.TeiidSQLException: TEIID30498 Capabilities for (Source Model) were not available. The command could not be planned properly.   I used the import tool to load a DB2 table in...
    Profile Photo
    last modified by rob.t
  • Group does'nt exit error

    I have followed below steps to create Source and view model  Using teiid designer.When i used "preview data in the view model" i got the group doesn't exist error. 1)Created  Books table in Derby Database:...
    Profile Photo
    last modified by radhika03
  • Teiid 'Error Executing Statements' on join query

    I am writing the following join query in Teiid designer view to combine two different JDBC data sources (Composite Single Source and SQL Server)   QUERY SELECT * FROM   Composite_SS.dm_DailyProd_vin AS SS...
    Profile Photo
    last modified by sarvesh723