3 Replies Latest reply on Jan 23, 2011 6:48 PM by Ramesh Reddy

    Import database via Metadata from JDBC database.

    Saurendra Kumar Newbie

      Hi

       

      While importing database tables via Metadata from JDBC database, none of the tables are imported and gives some error message, like this Teiid1.png

      In order to overcome this above issue, I was first created one DDL, by selecting the tables from the schema and then convert that DDL into relational model by selecting "DDL into Relational Model" from Import option. This is also a time consuming process, can any body has any solution on this regard.

        • 1. Import database via Metadata from JDBC database.
          Ramesh Reddy Master

          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 Kumar Newbie

            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.
              Ramesh Reddy Master

              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..