Db2 Tools for zOS

 View Only
  • 1.  DVM - SAP HANA

    Posted Wed June 23, 2021 01:44 PM
    Greetings All,

    does anybody know if DVM is able to "talk" to SAP HANA (i.e read data from SAP HANA tables) ?



  • 2.  RE: DVM - SAP HANA

    Posted Wed June 23, 2021 02:25 PM
    Edited by System Test Fri January 20, 2023 04:11 PM
    Hi William,

    We've done some internal testing where we were able to connect to SAP data via the JDBC Gateway server-client component that comes with DVM for z/OS. So the client accesses the DVM Server, which routes to the Gateway and then on to the SAP database and uses their SAP HANA driver.
    So while some success has been achieved, it is not optimized as are the native mainframe sources. We haven't gone through rigorous functional, performance, or regression testing for this data source. The mileage may vary concerning comprehensive data type mapping, function mapping, SQL translation to SAP database.

    One of IBM's finest was able to successfully connect, as well, however, he is out until next week. We can circle back specifically on Monday to get a read-out from him regarding any specifics.

    Doug Dailey
    Product Manager, IBM Data Virtualization Manager for z/OS

  • 3.  RE: DVM - SAP HANA

    Posted Thu June 24, 2021 02:52 AM
    Hi Doug, Thank you very much! for your prompt reply. Very much appreciated. Yes, it would be very useful to get feedback from the Colleague who got it to work. Have a great day.