Skip to Content
Author's profile photo Amr Salem

Testing HANA Client on BI4.1 Server

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

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Amr Salem,

      I would like to learn HANA ? can you plz suggest me !!!

      I'm having 3+ yr exp in ABAP. now want to switch from ABAP to BW on HANA.

      Your suggestions will be highly appreciated... 

      Author's profile photo Amr Salem
      Amr Salem
      Blog 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 Former Member
      Former Member

      Thanks Amr Salem,

      Actually I'm little bit confused about BW and BW on HANA ? what is exactly ?

      Author's profile photo Amr Salem
      Amr Salem
      Blog 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
      Blog 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 Former Member
      Former Member

      Great,

      As my experience in ABAP, then which is correct path way to do SAP-HANA ?

      And what will be scoop / profile for me ?

      Author's profile photo Amr Salem
      Amr Salem
      Blog 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.

      Author's profile photo Former Member
      Former Member

      Highly appreciate...


      But i don't want to write code anymore, in this case what to do in HANA ? and totally i have planned to move from ABAP to HANA. . .

      Author's profile photo Amr Salem
      Amr Salem
      Blog Post Author

      I believe to Write Code or not to write code is something related to your role, not related to the tool you are using, in HANA there are many interesting opportunities which requires to write Code, the less of them that needs coding is Modeling Data for Analytics.

      Author's profile photo Former Member
      Former Member

      May know more about Modeling Data for Analytics .!!! how to secure my career in Modeling Data for Analytics ???

      Is there any particular module for Modeling Data for Analytics as like BW / BI or BO ???

      Thank you Amr Salem...

      Author's profile photo Amr Salem
      Amr Salem
      Blog Post Author

      Check This Link

      http://www.saphana.com/docs/DOC-1074

      1000s of Videos Available on youtube

      SAP HANA Modeling Overview - YouTube

      Author's profile photo Former Member
      Former Member

      What about BI platform on  linux  suse  server ? what connections i need ? how i can make odbc32 connection at BO on linux64?