Blog Archives

SAP HANA connection in Power BI Desktop

Open Power BI Desktop and click on Get Data Select “SAP HANA database” and click “connect” If HANA database driver not install you will get message as below Download driver from “SAP Software Download Center” and install Unzip “hdb_client_windows” Run

Posted in SharePoint 2010

How to Install and configure Power BI On-Premises data Gateway?

First you have to download PowerBIGatewayInstaller.exe Use below link to download https://powerbi.microsoft.com/en-us/gateway/ Double click on PowerBIGatewayInstaller.exe and follow the instructions Select the recommended option and click “Next” Wait while installation. Just read the important message and click “Next” Change the

Posted in Power BI

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

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  

Posted in SAP HANA

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

First follow below link to download SSRS reports https://gallery.technet.microsoft.com/scriptcenter/SSRS-all-RDL-files-from-00488104 Now download SSRSBuddy tool form codeplex.com https://ssrsbuddy.codeplex.com/ Run the exe with admin privilege. Enter valid Report server URL and select Data Source and Folder Also, browse and select reports to upload.

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

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”

Posted in Fiori, SAP HANA