Archive

Author Archive

Top 5 Reasons Why You Need an SAP HANA Security Strategy

As more organizations make the move to SAP HANA-based solutions, many of those same companies are failing to recognize that building a solid security strategy is just as important as the platform itself. With most of the SAP ecosphere running something based on SAP HANA, solutions like Suite on SAP HANA (SoH) and S/4HANA are bringing the dream of running ERP and Analytics on the same platform to life, prompting more organizations to grant access directly to the SAP HANA database.

But is that the best strategy to keep your valuable data secure? Have you considered the gaps that exist in your SAP HANA security model? Do you HAVE an SAP HANA security strategy in place? Here are the top five reasons all organizations need to address their SAP HANA security model before it’s too late:

  1. Fraud can cause an organization to lose both money and its valuable reputation. When an SAP HANA system operates an SAP ERP application serve, someone only needs to INSERT, UPDATE or DELETE access to the SAP ERP tables to commit mass fraud.
  2. When your SAP ERP system is offline, it is hard to conduct business. So yes, securing your SAP HANA system is also about system availability. An untrained administrator with a high level of privileges can be just as dangerous as a hacker trying to bring down your system. You’ll need a sound SAP HANA security model, SoD and training to prevent these types of mistakes.
  3. Hackers try to gain access to your systems and data for a variety of reasons. Typically, they’re not breaking in to perform routine maintenance. More likely, they hack into your system to steal information, commit fraud, extortion, denial of service and other malicious acts. You must make it very difficult for them to penetrate your SAP HANA database security.
  4. Compliance means that resistance to implementing SAP HANA security if futile. Most organizations have obligations to external regulatory agencies and must adhere to their security standards. SAP HANA is one of many systems that are subject to numerous regulations. Therefore, you need to have a security model and security strategy for all SAP HANA systems.
  5. Access to data must be governed. Almost all SAP HANA solutions involve the storage of master data and transaction data. Such data often needs to be segregated within the organization. Without a proper security model in place, most organizations have no means of securely distributing data hosted in SAP HANA.

HANASecurity.jpg

To help organizations understand what’s required to create a sound SAP HANA security model, I recently authored a book titled SAP HAN Security Guide, now available from SAP-Press and Rheinwerk Publishing.

 

 

The book addresses the following key areas of security and other topics:

User Provisioning Repository Roles
Object Privileges System Privileges
Package Privileges Analytic Privileges
Encryption Auditing and Monitoring
Troubleshooting Security Recommendations

SAP HANA Security Guide is available from SAP Press in hard copy or ebook format at: SAP-PRESS. Hard copies are also available from Amazon.

About Jonathan Haun

Jonathan is currently working as a Director at Protiviti. He has over 16 years of BI and IT experience. He currently focuses exclusively on Business Intelligence tools, technologies and EIM processes. He has helped hundreds of companies implement BI tools and strategies over the past 10 years. With Protiviti, he primarily works with the SAP BusinessObjects IDD and EIM tools. This includes experience with Data Integrator, Data Services, Universe Design, Web Intelligence, Crystal Reports, Xcelsius, BusinessObjects Enterprise, HANA, BOE architecture and server sizing. He is also a contributing author to the SAP Press book “Implementing SAP HANA” and the SAP Insider Book “SAP HANA HA and DR Essentials” The views and opinions on this blog are my own. They do not necessarily represent the views and opinions of Protiviti or SAP.

Categories: HANA, Security

First Impressions of the New SAP BI Launchpad

Experienced users of Web Intelligence, whom might have become fatigued with the interface of Web Intelligence and other applications using the BI Launchpad, will be excited to see the brand new iteration of the Launchpad in BI 4.2 SP4. This new, yet familiar interface will be sure to please both current and future users alike.

New, Yet Familiar Design

The entire look of the BI Launchpad has been given a major facelift, with the most prominent change being a shift to a tiled icon interface, more consistent with other SAP applications like Fiori 2.0. Upon login, users are directed to the My Home  page, pictured below.

In my opinion, this layout can be a tad bit overwhelming at first glance. Files are listed alphabetically with seemingly no options for grouping by file type, whether the file be a Webi or a Crystal Report. A drop down menu in the top left hand corner does allow you, however, to navigate to your recent and favorite documents for a more consolidated view.

To download full PDF and Continue Reading…

Austin Graham
Sr. Consultant 2
Data & Analytics
Protiviti

Getting Started with BW4HANA

Big Data with SAP HANA & Hadoop

Purpose –

This is part 1 of series of blog to get started with BW4HANA.

In this part we will create a BW4HANA instance from the image deployed by SAP on Cloud Platform like AWS or Azure.

Prerequisites –

  • SAP SID. It usually starts with S and is 11 characters for eg-: S0012345678. You can get SID from SAP.
  • SAP Cloud Appliance Library account (link). Fill in the necessary information using your SID above.
  • Access key and Secret key for your Amazon Web Service (AWS) account if you are using AWS to host your instance.

Let’s Get Started –

  1. Open the SAP Cal (link) in your favorite browser

1-1.PNG

  1. Login with your SAP ID

1-2.png3. On the top right corner there is a search option, Search for “BW

1-3.png

4. Select the appropriate instance from the below list and click on Create instance.      …

View original post 211 more words

Categories: Uncategorized

How to secure information views in SAP HANA

As more and more organization implement SAP HANA native or standalone, the need to understand how to provide access and secure information views has emerge.  The intent of this article is to provid…

Source: How to secure information views in SAP HANA

Categories: HANA

Multistore Table Partitions in SAP HANA 2.0

Starting with SAP HANA 2.0 we can now partition a single table between in-memory storage and SAP HANA Extended Storage (AKA.. Dynamic Tiring). This is an excellent feature because it simplifies the…

Source: Multistore Table Partitions in SAP HANA 2.0

Categories: HANA

Building a One-Way ANOVA R Extension in SAP Predictive Analytics

One of the first statistical tools many new analyst use is the Analysis of Variance, a collection of statistical methods used to decompose and understand the causes of variation within a set of data. One-way ANOVA is perhaps the most basic of these methods and a staple of most statistical software. While SAP has included many predictive algorithms in their SAP Predictive Analytics Expert application, it is missing many of the common descriptive algorithms used by data scientists to better understand their data. Luckily, it is relatively easy to build in custom R extensions to accommodate any descriptive statistical needs.

What is One-Way ANOVA?

One-Way Analysis of Variance is used to compare means within 3 or more samples to evaluate whether or not all groups have the same means (in effect, there is no difference in the monitored statistic between the groups). Of course there is natural variation in data, so the actual means of the groups may vary slightly, but the age-old question persists: is the difference statistically significant???

One-Way ANOVA is an omnibus test, which means that if the null hypothesis (all means are the same) is rejected, it offers no additional information on which of the group(s) are different from each other, simply that at least one of them is different enough to reject the hypothesis that they are all the same.

For additional background on One-Way ANOVA, see the relevant Wikipedia article.

To download full PDF, and Continue Reading…

Hilary BlissAbout Hillary Bliss
Hillary is a Senior Manager – Data & Analytics at Protiviti, and specializes in data warehouse design, ETL development, statistical analysis, and predictive modeling. She works with clients and vendors to integrate business analysis and predictive modeling solutions into the organizational data warehouse and business intelligence environments based on their specific operational and strategic business needs. She has a master’s degree in statistics and an MBA from Georgia Tech.

Categories: Predictive Analytics

Reporting & Analytics Interactive 2016

FLASH SALE!

 

THREE DAYS ONLY!

 

REGISTER FOR $1599

 

sap-events-2016_jpeg-emails_protivitioffer

Categories: Events