I am connecting (trying to connect...) to a DB2 database to do a reverse engineering (Import Data Dictionary). Desktop is 64-bit Win7, Oracle Data Modeler v 4.0.3. DB2/UDB 7.1.
I have an ODBC connection to the DB2 database on the PC. When I create the connection (using the JDBC-ODBC bridge), both the Test and Connect buttons return Success. I select the connection and click Next to get the list of available Schemas, and the list is empty. (The ODBC connection is specific to the DB2 7.1 on i Series that we have.)
I'm guessing that the JDBC/ODBC bridge is finding a handshake (box to box), but not really seeing the database. And as another option, I cannot find anything on how to use the "Other ThirdParty driver" -- what should go in the JDBC URL and Driver Class boxes. We do have a jar file with classes for connecting to DB2 that we use with other apps, but I don't know how to get the Data Modeler to use what's in that jar file.
Any help would be appreciated.
