Page 1 of 1
ODBC and Orchestrate
Posted: Thu Jul 31, 2008 5:30 am
by abhilashnair
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?
Posted: Thu Jul 31, 2008 8:41 am
by bcarlson
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
Posted: Thu Jul 31, 2008 12:49 pm
by Raftsman
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.