Import Oracle DB schema from ODBC (datatype issue)

[sebcj]

Hi

while i am importing a an oracle schema into a diagram, all the datatypes generating as varchar(255). can anyone help me to sort this issue?

[«Midnight»]

Don't know, but here's some things to check.

What version of Oracle are you importing?

What client (vendor and version) are you using to establish the ODBC (or OLEDB) connection?

What default DBMS product have you set for your project? You can set this on the Settings | Database Datatypes dialog; choose a Product Name from the drop-down and check the Set as Default box.

If these don't help search the forum. I'm sure I've seen this here before.

David

[Luis J. Lobo]

I had the same problem some weeks ago. Try the "Microsoft Oracle for OLEDB" driver instead of the "Oracle Provider for OLEDB" when creating the ODBC connection.

[sebcj]

I've changed the drivers, but still i am getting the same datatype , is there any other checks i need to do?

[sebcj]

I'm trying to import oracle 9.1, I tried ORACLE ODBC DRIVER and Microsoft ODBC for Oracle, but still I am not able to import all datatypes. just varchar(255). Default DBMS is Oracle,

[«Midnight»]

Are you perhaps missing some permissions on the Oracle side?

[sebcj]

currently i've all required permissions in the schema

[Luis J. Lobo]

In the ODBC connection window, try typing the "SCHEMA OWNER"

[sebcj]

I already included the Schema owner window in ODBC connection window

[«Midnight»]

Actually, try clearing that entry. Someone had a problem recently, and clearing the owner solve it.

[sebcj]

you mean, remove connection, and recreate it?

I tried this for different schema's but for every schema imports, i am getting the same issue

[sebcj]

All, at last i managed to import correctly, it was  the problem with the driver, I replaced the driver and now importing correctly.

One solution i needed now, that is, previously i imported 1 whole schema with varchar(255) datatype into one folder in datamodel, and created many datamodel diagrams based on that.  now, when i import the schema again with correct datatype into the same folder, how can I make these changes reflect in my data model diagrams?

Creating all datamodel diagrams again is a big task, i am looking for a solution to reflect these changes into my diagrams...

Can anyone help on these please?

[«Midnight»]

Off hand I think a quick add-in is what you need. Just traverse the new model. For each table locate matching elements in the rest of your models. Then for each column in the table find the matching attribute in the other models and adjust the settings.

It might sound like work, but given the way EA works it would probably be pretty easy.

You might also be able to do this with a bunch of SQL statements against the EA back end repository. You'd have to be very careful about this unless you are expert at manipulating EA models this way. If anything goes wrong you're entirely without a safety net, and you might not find out until the model malfunctions at a later - and always more inconvenient - time.

[Luis J. Lobo]

In the "Code Engeneering | Import DB Schema from ODBC..." window, "Synchonization" section, you can select into import as new tables or synch within existing Tables.

The synchronization maintains the existing relations of the Tables with other UML elements.

Try it.

[sebcj]

Thanks a lot louis, this works!!