Skip to Content
avatar image
Former Member

Access HANA Views from different HANA databases // virtual HANA view

Hi together,

we have two HANA database systems. We want to access a HANA view from database A from database B.

I know that it is possible to create a virtual table using Smart Data Integration, but we want to create a "virtual HANA view"?

Greetings

Patrick

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 30, 2017 at 12:56 PM

    You are talking about HANA database views? Then you can also create a virtual table pointing to the view (instead of a table).

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Patrick,

      Did you success with this integration?

      It is a good point to test, since it does not appear in any SAP documentation this possibility. We have this need and that is why I thought HANA's SMART DATA ACCESS could be the solution for not replicating data in the segmentation.

      My fear is for the performance of the segmentation, have you been able to test this segmentation with two HANA instances that are on the same internal network?

      Thank you very much in advance.

      Rubén

  • Jan 31, 2017 at 08:55 AM

    It is possible to add HANA views as a virtual table to another HANA system. If I remember correctly, in SPS 10 there is a restriction. _SYS_BIC schema will not be visible to Smart Data Access.

    Please check the SAP note below for this.

    2171760 - Wrong results on virtual tables with remote Column Views

    I know this has been fixed in SPS 12 for sure.

    Add comment
    10|10000 characters needed characters exceeded

  • May 21, 2017 at 01:45 PM

    Hi,

    We have done this on our environment without a problem using an SDA connector. We are on HANA 1.0 SP12 and all the calculation views from source system are visible to connect to a virtual table. Just make sure you have access to the _SYS_BIC schema on source HANA. In addition, if your calculation view has parameters then you will not be able to connect a virtual table to it as this is not supported by SAP yet.

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Expert,

      Will you please help me in detail, how you accessed HANA views through SDA, please...

      We are having the similar scenario in my current project, please...

      Thanks,

      BR,
      Chandra.