Log in to follow, share, and participate in this community.
Thread Teiid designer does not take the overridden translator
Teiid designer does not take the overridden translatorProblem: I specified an overridden translator using the menu item Translator Overrides but Designer still use the default translator in the vdb.xml (the overridden translator in in the XML file but not be used).
Teiid Designer 9.2 What's NewHighlights Teiid Designer 9.2 introduces the following notable changes and features TEIIDDES-2343 - Support importing Dynamic VDB TEIIDDES-2401 - Add support exporting the Designer VDB as Dynam...
create REST WarI used Teiid designer to create a source model for MySQL, then a relational view model, then a procedure (REST enabled) within the view, then a VDB with source model and view model, finally created WAR. But: as I test...
Thread Prevent to_char implicit conversion for TimeStamp field in database
Prevent to_char implicit conversion for TimeStamp field in databaseI'm currently toying with the behavior of the translator for a specific TimeStamp field in my model in a Teiid 8.4/JDV 6.0 setup. The database stores this field as a TimeStamp type but very often, clients that connect...
Thread How to connect stack treace console to remote Teiid server
How to connect stack treace console to remote Teiid serverHi all Would you pls help me to connect stack treace console which i have in teiid designer to remote Teiid server which is located on external server. In my previous set-up teiid designer was installed on same mach...
Thread Duplicate security constraints, how to prevent that?
Duplicate security constraints, how to prevent that?In Teiid 8.4, I have one table that is "protected" by a row based security constraint. The corresponding role is set to be for all users that log on. I join the protected view with the tables that I want to limit the ...
Thread Unable to preview generated view in jboss data virtualization platform
Unable to preview generated view in jboss data virtualization platformHi, I am trying to create a view from an xml file using the JBoss Data Virtualization tool. I have followed all the steps outlined in the introductory videos on the JBoss website(1,2 and 3). After adding the XM...
Thread Remote connection to teiid server from designer
Remote connection to teiid server from designerHi, I'm trying to connect from teiid designer 9.1.1 to a remotely installed teiid server version 8.9.1 but I cannot get it to work. My configuration is as follows. A Windows 2008 R2 Server has Teiid de...
Article How to Consume a JSON REST Web Service in Teiid Designer
How to Consume a JSON REST Web Service in Teiid DesignerOverview In the upcoming 8.6 release of Designer, we have introduced features for consuming JSON REST web services and exposing them as relational sources. This article will describe how to accomplish this and ...
Non-whitespace character foundHi, As I have indicated before the help in this forum is much appreciated. I have a CSV with data to be inserted into MySQL. Some of the data is successfully inserted but some of the data generates the follow...
Thread Transformation query not generated after ddl view import.
Transformation query not generated after ddl view import.Hello, I am using TEIID designer 9.0.2. We exported the existing source and view model separately into ddl file. We imported source model ddl successfully without any issue. But while importing the view mo...
Teiid parsetimestampHi all, Your help is much appreciated. I am using parsetimestamp to export data from CSV into MySQL. An example of date format on CSV is "Mar 17 2009 9:00PM" On teiid designer I h...
Thread Execute a virtual procedure from within another virtual procedure
Execute a virtual procedure from within another virtual procedureHi, Much appreciate you all for your reliability and help. I have created a Teiid virtual procedure which I want to execute from within another procedure, as follows; CREATE VIRTUAL PROCEDURE BEGIN ...
Thread Teiid - Consume JSON tree from REST web service
Teiid - Consume JSON tree from REST web serviceI am trying to consume the JSON data returned by REST WS, Essentially this data is a array with each element of array may be having one or more array with few attributes at each level. A sample data is attached with...
Thread suggestion for installation procedure teiid designer
suggestion for installation procedure teiid designerHi, Just a small suggestion. In the Download and Install page for teiiddesigner in Luna, it says Install Teiid Designer 9.1. Might I suggest to explicitly indicate to install the runtime and clients? I first i...
Article Intro to VDB Builder - command line creation and editing of your VDBs!
Intro to VDB Builder - command line creation and editing of your VDBs!Intro to VDB Builder This article provides an introduction to our new VDB Builder command line interface (cli). VDB Builder allows you to create, edit, import and export dynamic VDBs - all from the command lin...
Thread Teiid designer 9.1 exception String Index out of bounds
Teiid designer 9.1 exception String Index out of boundsHi, I 've installed teiid designer 9.1. When I open an old project I get some errors for virtual procedures. eg: java.lang.StringIndexOutOfBoundsException: String index out of range: 1 ...
Article Producing and Consuming OData in Teiid and Teiid Designer
Producing and Consuming OData in Teiid and Teiid DesignerIntroduction The OData protocol is an increasingly popular RESTful interface for data access. It was originally introduced by Microsoft, but is now in the process of becoming an OASIS specification. Red Hat, SA...
Deploy and Activate VDBHi, Thank you all for your support. I have a procedure on my Teiid designer that loops on data from a CSV and inserts to MySQL. I needed to automate the process so I used AdminShell to insert t...