ODBC and Orchestrate

abhilashnair · Post by **abhilashnair** » Thu Jul 31, 2008 5:30 am

What is the difference between importing table definitions using ODBC method and using Orchestrate method, is one of them accurate than the other one? Which of these is recommended when Database is Oracle 9i?

bcarlson · Post by **bcarlson** » Thu Jul 31, 2008 8:41 am

My guess is that the ODBC version will be more generic and basically contain table name, column names and datatypes whereas the Orchestrate method may be more database vendor aware. The basic DDL does not change from database to database when it comes to column and datatypes, but there are subtle differences when they deal with storage (tablespaces, partitioning keys vs. primary indices, etc.)

That is my guess.

Brad

Raftsman · Post by **Raftsman** » Thu Jul 31, 2008 12:49 pm

That`s exactly correct. If you use the ODBC, the table datatypes may not be exactly as the Oracle definition. It is better to use Orchestrate. That being said, if you deal with CLOB`s and BLOB`s, ODBC works better. Not exactly sure why but we ran into problems for those datatypes.