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
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
2. Click Add and Select HDBODBC from the list
3. enter the required information (ODBC Data Source Name, and HANA Server and Port Number)
4. Click Connect to Test the Connection, Enter a valid HANA username and password
5. The Connection Test says “Connect Successful”
6. Click Ok, and Again Click ok to add the ODBC Data Source to the system DSN
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
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...
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
Thanks Amr Salem,
Actually I'm little bit confused about BW and BW on HANA ? what is exactly ?
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
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..!!!
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.
Great,
As my experience in ABAP, then which is correct path way to do SAP-HANA ?
And what will be scoop / profile for me ?
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.
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. . .
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.
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...
Check This Link
http://www.saphana.com/docs/DOC-1074
1000s of Videos Available on youtube
SAP HANA Modeling Overview - YouTube
What about BI platform on linux suse server ? what connections i need ? how i can make odbc32 connection at BO on linux64?