Skip to Content

Does DB2 9.7 ODBC driver work with HANA SDA?

Jun 28, 2017 at 07:06 PM


avatar image

Documentation notes the minimum release level for Smart Data Access to DB2 being for version 10.1; we have a 9.7 database and there are IBM ODBC drivers available for that version. Has anyone run/tested this version with HANA. That server is at Platform 2, SPS01 level.

Much Thanks,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ronald Konijnenburg
Jan 04 at 12:24 PM

We are running DB2 V9.7 FP 11 but are facing performance issues. Tracing that points to SDA (and not to network latency, source system performance). Also BW does not seem to like creating a datasource on a virtual table on a non Unicode sytem. The driver dumps on RAWSTRING fields (Unicode sources dont have the issue).

Anyone else facing issues?

10 |10000 characters needed characters left characters exceeded