Page 1 of 1

Data extracting issue from oracle

Posted: Fri Aug 22, 2008 2:00 pm
by DWH-M
I am facing problem while extracing the data from using ODBC enterprise. I have imported the columns using the table definition.
but when i try to check the data using view data button i am getting an error like data type not supported and getting like ODBC process meta data not available in data base. When i have imported table definitions for the column i have got NVarchar, Nchar, Timestamp, decimal,biginit,longnvarchar.

Please let me know the solutions.

Posted: Fri Aug 22, 2008 2:29 pm
by chulett
The preference would be to use the orchdbutil command to import the table metadata as that is the most accurate way for PX.

Posted: Fri Aug 22, 2008 5:09 pm
by ray.wurlod
Import > Table Definitions > Orchestrate

will invoke orchdbutil when that particular option is selected in the dialog - you don't need to learn the intricacies of the orchdbutil command itself.