Skip to Content

How to read SQL Server data from HANA Studio?

Hello

I just migrated master data to SBO 9.3 for HANA from an MS SQL based program. I created an ODBC connection to MS SQL database to retrieve data. Now, I need to compare data stored in HANA database with the data stored in the MS SQL server (through the odbc connection).

How can I query the MS SQL from HANA studio so I can compare the data from both databases?

Regards

Hector Santo

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 10 at 04:17 PM

    You can use SDA Smart Data Access to federate remote SQL Server data base. You will definitely get lots of Iformation on SDA it you Google it.

    Add comment
    10|10000 characters needed characters exceeded