How to connect SQL Server to SAP HANA 2 Express edition?

  • First you have to download hdb_client_windows 64 bit setup from SAP download site

    And install.

  • Now create ODBC connection
  • Go to Administrative Tools and click on “Data Sources (ODBC)”

  • Go to “System DSN” Tab

  • Click Add, Select HDBODBC as below and click finish

  • Fill all the required information and click Connect

    Here very important to know the port no. for that login to

    SAP HANA Studio and connect to HANA SYSTEM.

    You can follow my blog

    http://wp.me/p2oyUE-O1

  • Right click on connection and click on properties

  • Go to “Hosts Used to connect”

  • Enter user and password. Press OK

  • You will receive success message if connection success

  • Now press OK to complete ODBC configuration.

  • Your Data Source name will show as below

  • Now Configure Linked Server in MS SQL Server
  • Open SQL Server Management Studio

  • Now Execute below Script to create and configure Linked Server

  • Refresh Linked Server

  • Test connection

  • Now run below SQL to get data from SAP HANA table

    Select
    *
    from [hxehost]..“DEMO”.“Shop_facts”

Advertisements
Posted in SAP HANA

Add System to SAP HANA 2 Express using Eclipse LUNA

  • Open Eclipse LUNA and make sure SAP HANA Studio plugins is install
  • If SAP HANA Studio plugins is not install follow below link to install

    http://wp.me/p2oyUE-MU

  • Move to SAP HANA Modeler
  • Click on “Add System Menu” and select

  • Enter Host name, Instance Number, select option “System database” and click “Next”

  • Enter User Name, Password and click “Next”

  • Click “Finish”

  • Connection successful.

Posted in SAP HANA

How to move SSRS reports from one server to another and Assign Data source through SQL script

  1. First follow below link to download SSRS reports

    https://gallery.technet.microsoft.com/scriptcenter/SSRS-all-RDL-files-from-00488104

  2. Now download SSRSBuddy tool form codeplex.com

    https://ssrsbuddy.codeplex.com/

  3. Run the exe with admin privilege. Enter valid Report server URL and select Data Source and Folder

    Also, browse and select reports to upload. Once finish click deploy.

  4. Now check selected reports will appear

  5. When you upload the report by default Data Source will not assign
  6. In my case I had 150+ reports to assign Data source
  7. It is easy to update Data Source by using SQL script
  8. First Run below SQL to find the DS ItemID
  9. Select * from DBO.DataSources DS JOIN DBO.Catalog C on C.ItemID = DS.ItemID

  10. Below is the SQL script to update single as well as bulk update of datasource.

  11. Go and check report data Source.

Posted in SQL Server

Create and Configure App Static Tiles

  • From the Fiori Configuration Cockpit of the Demo site, click Apps
  • Click + (plus) to add new Apps

  • In the Properties tab, click the App Resources

  • Select the App and click “OK”

  • Enter proper values

  • Click on the + icon to assign the app to the Demo Catalog

  • Select “Demo Catalog” from list and click “OK”

  • Same way select appropriate group

  • Select “Demo Group ” and Click “OK”

  • Under Visualization enter proper data and click “Save”

  • Click on preview

  • Preview is available

Posted in Fiori, SAP HANA

CREATE SAP FIORI LAUNCHPAD SITE

  • Go to SAP Cloud Platform trial account cockpit
  • Click Services and Select “User Experience”

  • Click the Portal tile
  • Click on “Configure Portal”

  • Select “Site Directory”

  • Click on “+” sign to create new site

  • Enter Site name, select “SAP Fiori Launchpad” and click “Create”

  • CREATING CONTENT IN THE LAUNCHPAD CONFIGURATION COCKPIT
  • From the Fiori Configuration Cockpit of the Demo site, click Catalogs

  • On the footer, click the + (plus) icon to create a new catalog

  • Under “Properties” enter Category Name and ID

  • Under Roles assign roles

  • Select the Roles form the list and click “OK”

  • Click “Save”

  • Catalog created and available

  • Define App Groups
  • From the Fiori Configuration Cockpit of the Demo site, click Groups

  • On the footer, click the + (plus) icon to create a new group

  • Under “properties” enter Group Name and ID

  • Under “Roles” assign roles by click “+” (plus)

  • Select the role from list and click “OK”

  • Now click “Save”

  • New Group created and save successfully

Posted in Fiori, SAP HANA

CREATE BUSINESS ROLES IN SAP CLOUD PLATFORM

  • Go to SAP Cloud Platform trial account cockpit
  • Click Services and Select “User Experience”

  • Click the Portal tile
  • Click on “Configure Portal”

  • Go To “Role” and Click on “New Role”

  • Type new role name and click “Save”

  • Now assign user to role

  • Enter User ID and click “Assign”

Posted in Fiori, SAP HANA

How to install SAP HANA Studio Plugins in Eclipse LUNA

  • Open Eclipse
  • Go to Help and click on “Install New Software”

  • Enter URL https://tools.hana.ondemand.com/luna and select “SAP HANA Tools”

    You can select other options also i.e. “SAP HANA Cloud Platform Tools”

  • In next step display the details to review the item to be installed. Click Next

  • Accept the license agreement and click finish

  • Downloading and Installing

  • Installation completed. Now restart the Eclipse

  • Now check Plugins installed or Not?
  • Follow Window à Open Perspective à Others

  • Multiple SAP HANA Perspective available

  • Open respective Perspective and start ….


Posted in SAP HANA