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