-
1. Re: Uanble to import metadata from Oracle database
jdoyle Oct 15, 2010 1:39 PM (in response to balaji.seshadri)From the jpg of the importer it doesn't appear that you've expanded through the Product schema. Does it not expand at all?
Also, what did you select on the previous page of the importer?
~jd
-
2. Re: Uanble to import metadata from Oracle database
balaji.seshadri Oct 15, 2010 1:44 PM (in response to jdoyle)I did select the type of object i want to import,please see the jpgs attached.
-
page 2 after connection.jpg 45.6 KB
-
3. Re: Uanble to import metadata from Oracle database
jdoyle Oct 15, 2010 1:58 PM (in response to balaji.seshadri)Thanks for the additional screenshots.
I don't know why this would happen. Since the same connection profile is used, I suspect some difference in the way the importer is treating the DatabaseMetadata returned.
Can you tell me if there's anything special about this schema? Does this user own it, are there synonyms?
~jd
-
4. Re: Uanble to import metadata from Oracle database
balaji.seshadri Oct 15, 2010 3:31 PM (in response to jdoyle)Its has grants for displaying tables because when i run select * from tab in toad it works.
What else is needed as privillege?.
Do we have any other way to map table in schema ?
-
5. Re: Uanble to import metadata from Oracle database
rareddy Oct 16, 2010 11:43 AM (in response to balaji.seshadri)Are you using the same user when working through Teiid?
If you use the same user through tool like SquirreL, do you see the tables? If no, then there is issue with the grants on that user. If yes, then Teiid should not have any issues either.
Ramesh..
-
6. Re: Uanble to import metadata from Oracle database
balaji.seshadri Oct 18, 2010 11:31 AM (in response to rareddy)Please see attached Squirrel capture,im able to see tables.
-
squirrel_capture.jpg 211.4 KB
-
-
7. Re: Uanble to import metadata from Oracle database
rareddy Oct 18, 2010 12:10 PM (in response to balaji.seshadri)Balaji,
Can you switch it to the "Objects" tab on the SquirreL, and expand the "tables" section on the left hand tree, do you see all your tables? Designer imports all the tables that are reported through "Database Metadata", so is SquirreL's left nav tree. If they are showing up in SqurrieL and not with Designer, then I am not sure what is going on. I would suggest trying with another user id, or try on different database to make sure your installation is correct. This is a straight forward task, I see no reason for this not to be working!
Ramesh..
-
8. Re: Uanble to import metadata from Oracle database
balaji.seshadri Oct 19, 2010 1:09 PM (in response to rareddy)I was able to see the objects in Squirrel client,i dont see any issue with grants.
I created meta data manually instead of relying on IDE,but this time im not able to add Primary Key.
Im unable to edit the primary key row i created ,is there anyway to do it.
-
unable_toedit_primarykey.jpg 143.6 KB
-
-
9. Re: Uanble to import metadata from Oracle database
balaji.seshadri Oct 19, 2010 1:10 PM (in response to balaji.seshadri)I did double click on each column,im able to do it in columns tab not on primary key tab
-
10. Re: Uanble to import metadata from Oracle database
rareddy Oct 19, 2010 1:16 PM (in response to balaji.seshadri)Balaji,
This view is read-only. If you want add a primary key, right click on the table in the "package diagram" tab, and "new child" and then select primary key. Give it a name, and assign it to the column in the properties dialog.
Ramesh..
-
11. Re: Uanble to import metadata from Oracle database
rareddy Oct 19, 2010 1:25 PM (in response to rareddy)Balaji,
In the Teiid Designer after you created connection profile to your Oracle DB, did your try to use "Database Development" view to connect to and issue any queries and saw the tables? This is similar to the SquirreL operation you did. I just want make sure there is no driver issues with the Designer.
Ramesh..
-
12. Re: Uanble to import metadata from Oracle database
balaji.seshadri Oct 19, 2010 1:31 PM (in response to rareddy)Please see the SQL Scarp Book screen shot from data source explorer in eclipse connecting to database using the same connection.
-
sqlscarpbook.jpg 184.2 KB
-
-
13. Re: Uanble to import metadata from Oracle database
balaji.seshadri Oct 20, 2010 12:29 PM (in response to rareddy)Thanks for the tip,it was really useful.
-
14. Re: Uanble to import metadata from Oracle database
rareddy Oct 20, 2010 12:33 PM (in response to balaji.seshadri)So, it is working for you now?