Hi All, The topic of my Blogging activities in SDN will be initially on Installation of SAP HANA CLIENT, ODBC & DESIGN STUDIO.

TOOLS INFORMATION:

HANA CLIENT TOOL

ODBC

DESIGN STUDIO 

PREREQUISITES:

The following components need to be installed before starting the installation:

  • Microsoft Office 2007
  • Adobe Flash 10.1 or higher
  • SQL Server Native Drivers.
  • Hana client tools.

HANA CLIENT TOOL

The SAP HANA client software can be installed on a variety of platforms.

The following platform types are supported:

● AIX

● HP-UX

● Linux

● Microsoft Windows

● Solaris


HANA Client is the piece of software which enables you to connect any other entity, including Non-Native applications to a HANA server. This “other” entity can be, say, an NW Application Server, an IIS server..etc. The HANA Client installation also provides JDBC, ODBC drivers. This enables applications written in .Net, Java..etc to connect to a HANA server, and use the server as a remote database. So, consider client as the primary connection enabler to HANA server.

  • SAP HANA Client are the “client tools” like ODBC Drivers for windows to connect to the HANA Database when you want to use for example excel to connect to SAP HANA.
  • The SAP HANA Studio is the Eclipse based development Environment for SAP HANA.

Download the media from service market place, Need SMP credentials

/wp-content/uploads/2015/11/1_825150.png

When you install the SAP HANA client software package, supported clients are installed and available. The clients available on Microsoft Windows platforms are as follows:

● SQLDBC

● ODBO

● ODBC

● JDBC

● Microsoft ADO.NET


Run the setup file with run as administrator rights, follow the wizard

/wp-content/uploads/2015/11/3_825170.png


Confirm the standard options and go through the short installation procedure:


4.PNG

Click on Install


/wp-content/uploads/2015/11/5_825173.png

After installing SAP HANA Client and SAP HANA Studio, we can start HANA Studio by navigating to the Windows Start menu, go to “All Programs type SAP HANA and hit “SAP HANA Studio”:

Installation completed successfully.


Default Installation Paths for Windows

Microsoft Windows x86, 64-bit 64-bit C:\Program Files\sap \hdbclient


For more info, please check SAP guides.


http://help.sap.com/saphelp_hanaplatform/helpdata/en/c6/ce24c3bb571014bcfdf6abefff1d4f/frameset.htm


1577128 – Supported clients for SAP HANA


ODBC Connection to SAP HANA

After the HANA Client is installed, if not already created, you will need to create an ODBC Connection to HANA.

What is ODBC?

ODBC (Open Database Connectivity) is a standard programming language middle ware API for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems.

/wp-content/uploads/2015/11/6_825334.png

The figure above shows how ODBC fits in between an application and the database it is accessing.


From the Start menu → select Control Panel →Select Administrative Tools

/wp-content/uploads/2015/11/7_825358.png

Select Data Sources (ODBC)

/wp-content/uploads/2015/11/8_825359.png

Select the System DSN tab → Select Add → Select HDBODBC for 64 bit machines → Select HDBODC32 for 32 bit machines → Select Finish.

/wp-content/uploads/2015/11/9_825362.png

Click on finish tab.

Complete the entries Data Source Name → HANA_ODBC (suggested) Description • HANA ODBC (suggested) Server Port → Select Connect

/wp-content/uploads/2015/11/10_825363.png

Server name should be filled in for you to test your connection, leave the User and Password field blank! Your AD/MC credentials will transmit automatically

When you receive the Connect successful! Message • Click OK.

/wp-content/uploads/2015/11/11_825365.png


DESIGN STUDIO MEDIA DOWNLOAD AND INSTALLATION PROCESS:

System Requirements:

Before installing the design tool of SAP Business Objects Design Studio, make sure that the following components are installed on the local machines of your application designers:

● Internet Explorer 9.0, 10 or 11

● For 64-bit version of design tool installer: 64-bit version of Windows

● For 64-bit version of design tool installer: 64-bit Secure Login Client of SAP NetWeaver Single-Sign On .

SAP BusinessObjects Design Studio enables application designers to create analysis applications and dashboards – based on SAP NetWeaver BW, SAP HANA and universe data sources – for browsers and mobile devices (iPads, for example).


SAP BusinessObjects Design Studio can be used locally and integrated in the following platforms:


  • SAP BusinessObjects Business Intelligence (BI platform)
  • SAP NetWeaver
  • SAP HANA

Download the media from service market place by providing the credentials.

Click on DESIGN STUDIO CLIENT 1.5 and download the required media.

/wp-content/uploads/2015/11/12_825366.png

INSTALLATION PROCESS:

Run the setup file with run as administrator rights,

/wp-content/uploads/2015/11/14_825367.png

Click on next tab

/wp-content/uploads/2015/11/15_825371.png

Click on next tab, Installation process started…

/wp-content/uploads/2015/11/16_825372.png

Installation completed successfully.


The default path for 32-bit is C:\Program Files (x86)\SAP BusinessObjects\Design Studio and for 64-bit the path is C:\Program Files\SAP BusinessObjects\Design Studio.


Connecting Design Studio

/wp-content/uploads/2015/11/17_825373.png

Go to Application–> New

/wp-content/uploads/2015/11/18_825374.png

/wp-content/uploads/2015/11/19_825375.png


Provide the necessary information and choose finish.

Click on Add Data Source Tab

/wp-content/uploads/2015/11/20_825376.png

Click on Browse tab, automatically our Hana db system will appears as we have configured ODBC server, choose DBH.

/wp-content/uploads/2015/11/21_825377.png

Click on OK tab, provide the Hana database credentials,

/wp-content/uploads/2015/11/22_825378.png

Now connection is active,

/wp-content/uploads/2015/11/23_825379.png

Click on ok.

Able to view tables successfully.

/wp-content/uploads/2015/11/24_825380.png

That’s it, in my next blog will explain about SAP LUMIRA and Analysis office.

Thank you for reading the blog.

Rajesh K.


To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply