9 Replies Latest reply: Jul 12, 2016 12:10 PM by Mathias Pietrus RSS

    database SPA HANA

    Marco Marcolini

      hi

      Connector SAP already provides the connecting link to the new SAP HANA database?

      thanks for your cooperation


        • Re: database SPA HANA
          Jonathan Poole

          The SAP Connector from QlikView can access HANA  IF  Netweaver is deployed on HANA.

           

          But you don't need the SAP Connector , you can use the ODBC driver that comes with HANA to do the connection via ODBC free of charge and that allows you to access HANA if the first condition above is not met.

            • Re: database SPA HANA
              Tobias Vogt

              Hi Jonathan,

               

              as I'm currently  doing some tests with HANA via odbc and I'd like to ask whether the login windows appears or appeared too, and how you can supress this for using odbc in automated reload tasks.

               

              On each reload I get the popup to enter username and password or just got to confirm the given entries.

               

              Regards and many thanks for any hints,

              Tobias

                • Re: database SPA HANA
                  Tobias Vogt

                  A short note to my previous post:

                  There is a newer ODBC-Driver Version with no popup on reload.

                  That might be used for automated reloads.

                    • Re: database SPA HANA
                      Mathias Pietrus

                      Where can I get this new ODBC-Driver Version? And what do I need to take care of?

                        • Re: database SPA HANA
                          Tobias Vogt

                          Hey, hi Mathias,

                           

                          you can download this via SAP Marketplace as a SAR-File you have to unzip via SAPCAR.

                          The ODBC-Driver is part of the SAP HANA CLIENT.

                          After Unzip the SAR-File run the Installation and make sure it has been selected for being installed.

                           

                          Hope it helps

                           

                          CU,

                          Tobias

                            • Re: database SPA HANA
                              Mathias Pietrus

                              Hey Tobias,

                               

                              Thank's for your quick response.

                              So I downloaded the latest Version (1.00.112.04) and installed it.

                              But the login window still appears.

                               

                              Do I have to change something (what? where?) in QV or create a new ODBC-datasource (User- or System-DSN)?

                               

                              Thank's in advance!

                                • Re: database SPA HANA
                                  Tobias Vogt

                                  Hi Mathias,

                                   

                                  so what is your HDBODBC-Driver Version you can see in ODBC-Source Administration?

                                  My Version is 1.00.102.05.

                                  Could you test successfully the Connection to your SAP HANA DB in ODBC-Source Administration?

                                   

                                  My Version of the SAP HANA Client - SAR File was

                                  IMDB_CLIENT100_102_5-10009664.SAR

                                  In QV you have to create the connect string once with the credentials.

                                  Does it work when you entered your credentials?

                                  Or does it carry on if you entered your credentials again?

                                   

                                  Regards,

                                  Tobias

                                  ========

                                    • Re: database SPA HANA
                                      Mathias Pietrus

                                      Hi Tobias,

                                       

                                      my driver version in ODBC-Administration is 1.00.112.04. I also tested the connection successfully in ODBC-Source Administration.

                                       

                                      My Version of SAP HANA Client is :

                                       

                                      File-Version: 1.0.112.10582

                                      Product-Version: 1.00.112.04.1467296086

                                       

                                      I can create a connect-string to Hana (this works fine!)  and I can also load data (I have to enter my credentials every time). But as soon as I want to load again or add a view or table I have to enter my credentials again and again...

                                       

                                      Can I create (how?) a connect-string (in QlikView) including my credentials?

                                      Like that:

                                      ODBC CONNECT TO DEMO_HANA (XUserId is KaFUbJFLTCVKUGBA, XPassword is TLICUJFMQDaCGXFMRRMGTTA);

                                       

                                      Thank's in advance!

                                       

                        • Re: database SPA HANA
                          Mats Olin

                          You can connect directly to SAP HANA through the JDBC or ODBC connector provided by SAP and the standard JDBC or ODBC connector in QV  if you wan't to access analytical views for example. If you run 'BW on HANA' and want to access your BW objects you can also use the different QV SAP connectors if you have those aswell. Just like Jonathan said / Mats