Skip to Content

How to migrate ODBC reports to HANA HTTP reports

Hi,

Here i am going to discuss about How do we migrate HANA Reports/Workbooks from ODBC to HANA HTTP

We already know in Analysis Office 1.4, we need to install HANA ODBC driver in local machine in order to connect to HANA system/data source

Problem :

Now Analysis Office 2.0 does not support ODBC. Here comes the question, if Analysis Office 2.0 does not support ODBC what about already existing HANA reports/workbooks which are created on ODBC based ?

Solution : In analysis Office 2.0, you have an option to migrate fromĀ  ODBC to HANA HTTP data source

How :

As soon as you open any report/workbook which contains HANA systems based on ODBC in Analysis Office 2.0 , It will display SAP HANA Data Source Migration dialog like below

Under ODBC Tab : It displays all HANA systems present in your Workbook based on ODBC

Under HTTP System Tab : It has a drop down which offers all HANA HTTP connections present in Analysis Office 2.0(if you added already)

you can also create immediately any HANA Http system by clicking on Create button which displays Create SAP New HANA Connection dialog (picture can seen in this document How to create HANA Http connection in local and consume in Analysis Office 2.0)

Select respective HANA Http systems from Dropdown against ODBC system and click on OK button. It asks for the credentials for HANA HTTP system, once after valid Credentials given, you will get successful message for migration process.

Related Documents :

How to create HANA Http connection in local and consume in Analysis Office 2.0

How to create HANA Http in BIP and consume in Analysis Office 2.0

Saving workbook as 1.x format using 2.x

How to maintain Analysis Office 2.0 settings

Main fetaures in 2.0 :

Whats New In Analysis Office 2.0


Subhash