Skip to Content
author's profile photo Former Member
Former Member

Client Tools and SAP HANA

Does anyone have a link to a listing of SAP BusinessObjects tools or Microsoft tools and the query language and driver they use to access SAP HANA? Specifically I am looking for something similar to the following. I tried filling it out but was not sure on several items in the list.

ToolDriverLanguageAnalysis for OfficeODBO, ODBC, JDBC ??MDX / SQL ??Analysis for OLAPODBO, ODBC, JDBC ??MDX / SQL ??Crystal Reports 2011ODBC / JDBCSQLCrystal Reports 2008ODBC / JDBCSQLCrystal Reports for EnterpriseODBC / JDBC / Universe (.UNX)SQLWeb Intelligence 3.1ODBC / JDBC via Universe (UNV or UNX), MDX via BWpbHANASQLWeb Intelligence 4.0ODBC / JDBC via Universe (UNV or UNX), BICS via BWpbHANASQLMicrosoft ExcelODBO, ODBC, JDBCMDX / SQL ??Explorer 4.0ODBC / JDBC / (Optional Universe but not advised)SQLDashboards 4.0ODBC / JDBC via Universe (UNX), BICS via BWpbHANA, QaaWS or BIWS via WebI or UniverseSQLXcelsius 2008QaaWS or BIWS via WebI or UniverseSQL?

If no such lists exists, this might be a good place to start one.

Thanks,

Jonathan

Add comment
10|10000 characters needed characters exceeded

9 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 19, 2013 at 02:08 AM
    ToolDriverLanguageAnalysis for Office

    ODBC

    SQLAnalysis for OLAP

    JDBC

    SQLCrystal Reports 2011ODBC / JDBCSQLCrystal Reports 2008ODBC / JDBCSQLCrystal Reports for EnterpriseODBC / JDBC / Universe (.UNX)SQLWeb Intelligence 3.1ODBC / JDBC via Universe (UNV)SQLWeb Intelligence 4.0

    ODBC / JDBC via Universe (UNV or UNX)

    SQLMicrosoft ExcelODBO / ODBCSQL / MDXExplorer 4.0JDBC / (Optional Universe but not advised)SQLDashboards 4.0

    ODBC / JDBC via Universe (UNX)

    QaaWS or BIWS via WebI 4.0 or Universe (UNV)

    SQL /

    XML via SQL

    Xcelsius 2008QaaWS or BIWS via WebI or Universe (UNV)XML via SQLVisual Intelligence

    JDBC / (Optional Universe)

    Online and Offline Mode

    SQLPredective Analysis

    JDBC / (Optional Universe)

    Online and Offline Mode

    SQLDesign StudioJDBC / ODBCSQL

    This table outline the connection options and query language used by the SAP BusinessObjects tools when connecting to SAP HANA standalone. Connectivity to BW on HANA is not included.

    If it needs updating, let me know.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 17, 2013 at 10:06 AM

    Hi Jonathan,

    Not sure if you had a chance to look at the following document, but it explains the BO tools connectivity to SAP HANA in details.

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

    Regards,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ravindra Channe

      I understand what BICS is in the context of BW, but what does it
      mean in the context of SAP HANA? Is this being used as a generic term to
      describe a type of proprietary protocol to connect to a data source?

  • Posted on Feb 19, 2013 at 12:58 AM

    Jonathan,

    Ravi's diagram is the closest you can get to. Let us know if you have a specific question.

    Regards,

    Rama

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Anooj,

      I had a look through the presentation. The instructions were for creating an OLAP connection using the SAP HANA provider (Direct). To me BICS implies a connection to a NW BW application server. An SAP HANA provider OLAP connection implies direct connectivity to the SAP HANA Analytic Views and Calculation Views.

      Creating a BICS connection within Analysis for OLAP (Assuming BW on HANA)

      Creating an OLAP Connection to SAP HANA

      BW_OLAP.gif (6.5 kB)
  • Posted on Feb 19, 2013 at 02:47 AM

    Hi,

    you are missing a couple of items and it seems that you now have the connectivity towards BW, HANA as standalone system, and BW on HANA here.

    All the BI Clients with the exception of Explorer and Visual Intelligence can leverage the BICS Layer to connect to SAP BW. For the BI clients it does not make a different is BW runs on a relational RDBMS or on SAP HANA - interface wise - with the exception of Visual Intelligence and Explorer.

    Visual Intelligence and Explorer connect to the HANA system for BW on HANA.

    If you trying to show the connection for HANA as standalone I would separate the BW on HANA from that.

    regards

    Ingo Hilgefort

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Ingo. It was wise to remove the BW connectivity from this table. Do you have any presentations or posts outlining the connectivity options from BOBJ to BW 7.x ? I would like to add a link if possible.

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2013 at 10:45 PM

    hi jonathan, can you explain further when you differentiate ODBC, and ODBC for HANA Native. Thanks. G

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2013 at 03:07 PM

    I have all the connection set up but not able to see HANA view either on Excel or analysis for MS.

    What could be the reason. can you please advice.am using 2007 and HANA SP5

    thanks.


    Untitled.jpg (15.0 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 15, 2013 at 05:17 PM

    Hi Jonathan: Your last item in the table, Design Studio can connect to HANA via ODBC. You may like to add that for general benefit

    BR - Arpan

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 30, 2016 at 02:02 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 30, 2016 at 01:47 PM

    Hello All,

    Latest BI release is BI 4.2 and new tools have been introduced like Design Studio and Lumira. Can someone give the same table for the consolidated list of tools now (new as well as old tools).

    Regards,

    Pavan

    Add comment
    10|10000 characters needed characters exceeded