DSXchange

We are trying to use ODBC enterprise stage to extract data from Oracle databases. I have done changes in dsenv, .odbc.ini and uvodbc.config to configure Oracle database. When i try using ODBC stage, it gives me an error message as below.

##E TOSH 000205 19:10:55(005) <main_program> PATH search failure:
##E TOSH 000000 19:10:55(006) <main_program> Error loading "orchodbc": Could not load "orchodbc": No such file or directory.
##E TOSH 000000 19:10:55(007) <main_program> Could not locate operator definition, wrapper, or Unix command for "odbcread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
##E TCOS 000029 19:10:55(008) <main_program> Creation of a step finished with status = FAILED.

Can you please someone share your experience to configure ODBC.

Regards

Have you read the Reference Guide for the stage? Done things like add the two $APT_ORCHHOME variables where and how it shows? Best to let us know what you've done so people can advise you on what's still left.

And, out of morbid curiousity, why not use the Oracle Enterprise stage?

Hi Craig,

Thanks for your response.

There is no branded_odbc in the PXEngine folder, which is the value of APT_ORCHHOME env variable. I have added $DSHOME/branded_odbc in the path env variable and $APT_ORCHHOME/lib & $DSHOME/branded_odbc/lib in the library path env variable.

In ODBC INI, i have added DSN name = Data Direct driver for Oracle and added section to mention the driver path for that DSN.

That DSN added into uvodbc.config file.

Please let me know if anything is missed out.

Regards
Saravanan

After making the dsenv changes, did you stop and restart DataStage?

Yes Craig. I did that.

Due to security standards, we are planning to use ODBC for extraction and Oracle Enterprise Stage for target load if ODBC performance is acceptable by the customer.

Regards
Elavenil

This is resolved. The incorrect path was mentioned in dsenv file.

Thanks for your responses.

Regards
Elavenil.