Can you specify a schema in a query at runtime in EDS?

Solution Verified - Updated -

Issue

  • In the EDS/Teiid Designer, I want to model data but not qualify with schemas ( turn off fully qualify ). At run-time I want to provide the appropriate schema. For example: I have three schemas: dev.table, test.table and prod.table. I want to model this one time and then provide the schema name at run-time. Can this be done?

Environment

  • Red Hat JBoss Data Services (EDS) 5.3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.