cancel
Showing results for 
Search instead for 
Did you mean: 

How to read SQL Server data from HANA Studio?

HectorSantos
Active Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

akshinde
Participant
0 Kudos

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.