-
1. How to Configure the schema name using Teiid designer tool ?
rareddy Jan 14, 2011 10:50 AM (in response to saurendra)Saurendra,
Let me see if I understand the question right, you have database that has couple different schemas with same table structure. However, using Teiid you only want to access one of those schemas to persist you data to right? if that is case...
When you are importing the metadata from this DB using Designer, on import wizard on the last screen there is option set to import "fully qualified names", when you that it will will qualify the source queries with schema qualifier, thus avoiding any issues. See attached picture.
If this is not your issue, you need to further explain issue with error you are seeing.
Ramesh..
-
2. How to Configure the schema name using Teiid designer tool ?
saurendra Jan 14, 2011 9:17 PM (in response to rareddy)Thanks Ramesh, for your suggestion.. but my requirement was that, I have one user which has the visibility to all the schema in the data base, out of which I need to persists the data in one of the schema for Teiid, right. so in this case we need to explicitly tell Teiid to insert the data in a particular schema, but I didn't find any way where to specify the schema name in Teiid designer?
-
3. How to Configure the schema name using Teiid designer tool ?
rareddy Jan 17, 2011 6:33 AM (in response to saurendra)Saurendra,
When Teiid imports the schema metadata from the database, if you select the "Fully Qualified", then it will automatically retrieve all the information required. If you are manually modeling all the tables then, you need to edit the "Name In Source" property and fully qualify these names in the source.
Ramesh..
-
4. How to Configure the schema name using Teiid designer tool ?
saurendra Jan 19, 2011 8:39 PM (in response to rareddy)The above solution worked for me. Thanks Ramesh..