BODS 3.2 Connect to Multi Schema Netezza

[Former Member]

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

[former_member198401]

Also check the below SAP note to check the compatibility between Data Services  and Netezza ODBC

2365217 - NETEZZA and SAP Data Services compatibility matrix

Regards

Arun Sasi

[former_member234353]

Hi Terry,

Can you post the details of the target table that you have defined and also the alias that you have defined within the target Datastore.

Due to the architecture of the netezza, there are issues that are usually faced in the target schema definition.

Thanks,

AJ