HANA instead of SQL Server

[Former Member]

Hi all,

I have got a specific question about HANA. Is it possible to create software on Microsoft Visual .NET using HANA as database instead of SQL Server?

Thanks in advance.

Regards,

Alejandro Fonseca.

[Ravi_Channe]

Hi Mario,

You can build a visual .NET application on SAP HANA using ODBC / ODATA connectivity. Please refer to the HANA SQL Script reference for an example of connecting to HANA using C#.

Also refer to the document mentioned below for the .NET connectivity using ODBC.

http://scn.sap.com/docs/DOC-33628

Regards,

Ravi

[Former Member]

Hello Ravindra,

Thanks for your reply.

I'd also like to ask you if it's possible to migrate reports created with Reporting Services and procedures created with SQL Server to HANA.

How complex could that migration be?

Is it necessary to re-build the SQL Server procedures and reports?

Thanks a lot!

Mario.

[Ravi_Channe]

Hi Mario,

Please refer to the documents on some of the basic understanding on SQL Query and procedure migration.

As you know, there is some syntax difference between SQL Server and HANA SQL scripts, there could be some challenges on migrating the SQL Server procedures to HANA.

Depending upon how the reporting access the underlying database, (SQL Interface, Queries fired against the database, custom coding), you may have to modify the reports.

Regards,

Ravi

[Former Member]

Hello Ravi,

I have used in the past the SQL Converter Tool, which is very useful for simple queries. I'm also aware of some of the differences between SQL and HANA.

I just wanted to know how challenging it could be to migrate a complete system from SQL Server to HANA and you've answered my question. Thank you very much.

Regards,

Mario.