-
1. Import database via Metadata from JDBC database.
rareddy Jan 23, 2011 10:05 AM (in response to saurendra)Saurendra,
Teiid Designer's "JDBC importer" is used to import the metadata from a existing database. That does not let you create a DDL to create a schema like in Erwin. However if you hand model your schema the Designer has facilities to convert that model to DDL like Erwin.
So, the above error is saying to you that you have an empty database and there is nothing to import, I do not understand your "time consuming" comment. Please explain what you are trying to achieve, so that we can suggest the available options.
Thanks
Ramesh..
-
2. Import database via Metadata from JDBC database.
saurendra Jan 23, 2011 12:13 PM (in response to rareddy)Ramesh,
I am not agree with the fact that I have an empty Database and I am trying to Import. The database I am trying to import has more than 200 tables.
The screen short I have attached above, shows after I was trying to import from the data base using the option "Import via Metadata". Since the process of import via metadata shows the above errors, so that I have used the process like mentioned(Create DDL and import....) above.
My question of "times consuming" expresses the process which I am currently using(Create DDL and import....), i.e.
- Create a DDL file contains all the tables as required
- Convert that DDL into a suitable relational model for Teiid.
So this is the whole issue, If you need some more info, then I will give you the screen shots further.
-
3. Import database via Metadata from JDBC database.
rareddy Jan 23, 2011 6:48 PM (in response to saurendra)Which database and what kind of JDBC driver are you using? Try using the same driver with Squirrel tool and see if you see metadata. As I mentioned before the JDBC importer uses the metadata provided through JDBC driver to import the database schema into a model.
We only see this behavior when user does not have access to the tables or database is empty.
Ramesh..