Tag Archives: odbc

enterprise architect reverse engineering ddl

Posted on July 21, 2011 | Comments Off on enterprise architect reverse engineering ddl

after finally get my odbc oracle connection running, it was time to try out the reverse engineering… loading a existing database in ea… and it works…

  1. Create a new, empty ea project
  2. Goto Projects->Database Engineering->Import DB Schema form ODBC…
  3. Select the Database Name / ODBC
  4. Set a Schema/Owner
  5. Press Import
  6. Select the tables to import and press OK

tada… done… easy as hell, as soon as the odbc works :/

and really cool is the generate DDL function compare… when generating DDL, press the compare button and set the odbc… and view… so it shows you all the changes, and suggested actions… how to extract these, is some thing different :/ something for my next post 🙂

Comments Off on enterprise architect reverse engineering ddl

Posted in Uncategorized

Tagged , , , ,

odbc oracle connection windows

Posted on July 21, 2011 | Comments Off on odbc oracle connection windows

so i needed a odbc to oracle… sounds easy… was confusing and actually i dont know, what i did nor if it was a good solution…

simplest way should be downloading the Oracle 11g Client for Windows… but wait… this fucking this is 2GB big… wtf? so tried it with the Instant Client (50MB) and the odbc supplement (700KB)… installing these things is kinda easy… but what the hell it is i dont know… ok its a driver… hurray… but how does the connection work? dont know… after googling around a lot i finally found this… opened notepad, created the files… set variables… and actually could configure the connection… hurray… and it actually works 🙂

is this a good solution?

Comments Off on odbc oracle connection windows

Posted in Uncategorized

Tagged , ,