Datastage to Dash DB & Netezza
Posted: Fri Nov 06, 2015 3:13 pm
Hi All,
We are planning to build Datastage jobs that write to both Netezza and DashDB (say as DR) with same business rules
So we would end up using Netezza Connector and I believe ODBC connector for DashDB (it has DB2 as the database)
Has anyone connected and written to DashDB using Datastage?
Looking for some guidance in terms of To Do and Not To Do when working with DashDb from datastage
Also with Netezza we do SQL Pushdown for bulk processing, does this approach work with DashDb or that needs to be more the traditional row based processing?
Thanks
NV
We are planning to build Datastage jobs that write to both Netezza and DashDB (say as DR) with same business rules
So we would end up using Netezza Connector and I believe ODBC connector for DashDB (it has DB2 as the database)
Has anyone connected and written to DashDB using Datastage?
Looking for some guidance in terms of To Do and Not To Do when working with DashDb from datastage
Also with Netezza we do SQL Pushdown for bulk processing, does this approach work with DashDb or that needs to be more the traditional row based processing?
Thanks
NV