Skip to Content
0
Former Member
Sep 27, 2016 at 08:50 PM

BODS 3.2 Connect to Multi Schema Netezza

36 Views

Hi, I am having issues when I run a BODS job to load data from Oracle to Netezza. My target table is under schema STG but BODS job keeps referring to schema Admin which is the default schema. I updated my ODBC driver to specify schema and also tried alias in Data Store definition. Nothing works. On the server side, ODBC driver has schema STG specified as well. Any thought? Thank you in advance, Terry