Skip to Content
Author's profile photo Amr Salem
Amr Salem
Posted on December 28, 2013 1 minute read

Testing HANA Client on BI4.1 Server

Follow RSS feed
3 Likes 1,885 View 13 Comments

in my Previous blogs i showed how to install the SAP HANA Server and also installing the Client tools

SAP HANA SP07 Installation

Installing SAP HANA Client on BI4.1 Server

And this is the 3rd Step is to test the Connectivity between our HANA SP07 server and BI4.1, our test will go take 2 steps

A. Creating the ODBC

B. Creating the Connection in IDT (Information Design Tool), Next blog

Start Creating the ODBC

1. Open the the 64bit ODBC

1.JPG

2. Click Add and Select HDBODBC from the list

2.JPG

3. enter the required information (ODBC Data Source Name, and HANA Server and Port Number)

3.JPG

4. Click Connect to Test the Connection, Enter a valid HANA username and password

4.JPG

5. The Connection Test says “Connect Successful”

5.JPG

6. Click Ok, and Again Click ok to add the ODBC Data Source to the system DSN

6.JPG

Now we have successfully added a new Valid HANA ODBC Connection to our ODBC System DNS, we can use this to Connect to SAP HANA from the IDT which i will show in another blog

Regards

Amr

Assigned tags

Related Blog Posts

    Related Questions

      /
      1.JPG
      2.JPG
      3.JPG
      4.JPG
      5.JPG
      6.JPG
      13 Comments
      You must be Logged on to comment or reply to a post.
        • Author's profile photo Amr Salem
          Amr Salem Post author

          Hi Bharat

          i suggest you start from http://www.saphana.com

          and check for whatever courses SAP provides about HANA and BW on HANA

          also there are many YouTube Videos you can watch online to get a start and an idea about HANA. thats how i started actually.

          Mainly you will need an access to SAP HANA which you can get it from the Amazon AWS free license for developers. Try | SAP HANA

          Regards

          Amr

            • Author's profile photo Amr Salem
              Amr Salem Post author

              BW always used to run on top of a relational Database such as (Oracle, SQL Server, … etc). now after SAP HANA is there a new innovation has come to life “InMemory Databases” and SAP is trying to push Customers to change the underline database from any other vendor databases to their new Baby SAP HANA, this added many new features to run BW on HANA, Performance is one of them, since all the data stored inMemory.

              Good Luck

              • Author's profile photo Former Member
                Former Member

                Thanks Amr Salem,

                Is it right time to switch from ABAP to BW on HANA ? Is there hard coder required for BW on HANA ? because i don’t want to write code any more..!!! 

              • Author's profile photo Amr Salem
                Amr Salem Post author

                Well, its the right time to switch to HANA, i dont know much about BWonHANA, Most of the work required will be related to data modeling, but there are many business cases where you need solve it by writing code 🙂

                Personally, i don’t like dealing with BW and its integration issues with BI4. i like relational data warehouses, and Pure HANA Database is giving me more than i want, it solved the performance bottleneck, everything else can be done much easier in HANA. all you need to have is the SQL Experience, and this is there with anyone working in BI&DW field.

        • Author's profile photo Amr Salem
          Amr Salem Post author

          Actually, SAP HANA is not only about data warehousing, SAP HANA is a huge platform which can be used for many purposes, as an ABAP programmer you may want to look into Developing HANA Applications, native applications, mobile Application, HANA River which is almost close to your area. there are a lot to be done in SAP HANA you need to look which area can suite you and you start from there.