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

BODS 3.2 Connect to Multi Schema Netezza


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