Spotfire and SAP HANA in Energy
Andre Kooy May 15, 2018
Agenda u
Introduction
u
SAP HANA and Spotfire
u
HANA Data Connector: data external vs import data
u
Import data vs information link
u
Loading data on demand
u
Inheriting row level security
u
End to end Single Sign On
u
Use Cases
u
u
Lubricant Supply Chain
u
Hydrocarbon Production dashboard
Q&A
Quintus consultants
www.quintus.nl
Quintus consultants u
Specialized Tibco Spotfire consultancy firm
u
Based in The Netherlands and USA
u
17 professionals
u
Projects around the globe
u
Consulting, always focused on allowing self service analytics
u
Call offs -> expertise on demand
u
Custom tools for our customers
u
Products on Tibco Spotfire
u
u
QuintusVisuals
u
Single Server Deployment Tool
50% of revenue in Energy
Quintus consultants
www.quintus.nl
Our experience in Energy u
16 years of experience with Spotfire in Energy
u
Shell, ConocoPhillips, Wintershall, Halliburton, Maersk, Tullow, Santos, Petrobras, BP, Statoil, Saudi Aramco and others
u
Used by several energy customers (EBN, WoodMackenzie) for sharing analyses with external stakeholders
Quintus consultants
www.quintus.nl
SAP HANA u
SAP HANA is an u
In memory
u
Column oriented
u
Relational Database Management System
u
Its primary function as a database server is to store and retrieve data as requested by the applications
u
It is used by many O&G companies as a data warehouse, for financial, operational and other data
u
More than just the SAP ERP data
Quintus consultants
www.quintus.nl
SAP HANA and Spotfire u
Spotfire can connect to SAP HANA via a client side connector and via server side information links
u
Connect to calculated views and/or data tables
SAP HANA
Infolink
Spotfire server Infolink
Data connector
Quintus consultants
User (Spotfire Analyst) www.quintus.nl
SAP HANA and Spotfire (II) u
In a Spotfire report/template it is possible to use combinations.
u
Choosing the right connection is not straight forward, it depends on business requirements and IT capability
u
To give best advice, deep knowledge of pro’s and cons is required -> we will provide high level only in this presentation Spotfire server
SAP HANA Infolink
Infolink Data connector User (Spotfire Analyst)
Quintus consultants
www.quintus.nl
Data connector u
With the data connector, the user can directly access the tables and calculated views that were made available to that user
u
It requires some configuration and allows prompting
u
A choice must be made between data external and import data
u
The data connection can be saved in the Spotfire library Spotfire server
SAP HANA Infolink
Infolink Data connector User (Spotfire Analyst)
Quintus consultants
www.quintus.nl
Data connector (data external) u
Keeping data external is mandatory when large volumes of data need to be analyzed u
u
“large” volume is defined by network capacity, HANA capacity, Spotfire server capacity and the PC or laptop of the user
Limited options available in the Spotfire analyst (aka Professional client) u
Joining, unioning, calculated columns limited or not possible
u
More dependent on IT
u
Integration with statistical tools much harder Spotfire server
SAP HANA Infolink
Infolink Data connector
Quintus consultants
User (Spotfire Analyst)
www.quintus.nl
Data connector (import data) u
Row level data is imported
u
All functions in Spotfire Analyst are available
u
Allows more self service analysis
u
Takes initially more time (all data must be loaded) but is faster after initial load, since all data is in memory of the user’s PC or laptop
Spotfire server
SAP HANA Infolink
Infolink Data connector User (Spotfire Analyst)
Quintus consultants
www.quintus.nl
Import data vs information link u
Row level data is imported in both scenarios
u
Import data does not have the information designer u
Joining data
u
Adding columns with additional logic to information model
u
Pre Pivoting of data
u
Caching
u
Manually changing SQL Spotfire server
SAP HANA Infolink
Much depends on what the Spotfire Analyst user is allowed to do
Infolink Data connector User (Spotfire Analyst)
Quintus consultants
www.quintus.nl
Data on demand u
By marking something in the analysis, only the associated data is loaded
u
Works with data connector data external, with data connector import data and information links
u
In many cases a combination is the best solution
u
Demonstration of data on demand
Quintus consultants
www.quintus.nl
Inheriting row level security u
With any of the connections, row level security as configured in SAP HANA can be implemented in Spotfire
u
Via the data connector, it is inherent: users only get to see the tables, calculated views and row level data as they are allowed to see -> they login with their own credentials into HANA
u
Via the information link, HANA data can be made available with a functional/general user or by requiring authentication by the end user u
With the functional/general user, the settings for that user will be used
u
With authentication, the end users need to login with their own credentials into HANA
Quintus consultants
www.quintus.nl
End to End Single Sign On u
With any of the connections, end to end Single Sign On can be implemented
u
Via the data connector, it needs to be setup between the user’s laptop or PC and with SAP HANA direct. This is achieved using Kerberos. The identity of the Windows user is used to login to HANA, with no request for login
u
Via the information link, SSO first needs be configured for the Spotfire server. When that is in place, it can also be configured between the Spotfire server and HANA. This is also achieved using Kerberos.
Quintus consultants
www.quintus.nl
Use case: Lubricant Supply Chain u
Comparing Bills of Material within plants (several alternatives) and between plants
u
Identifying savings opportunities
u
> 25 GB of data
u
Grew from a prototype to a full fledged tool
u
Available to web end users within 10 seconds
u
Huge file to manage with scheduled updates
u
Specific security features implemented via Iron Python
Quintus consultants
www.quintus.nl
Use case: Production dashboard u
Daily review of production data
u
Hierarchical overview: regional, country, asset, well
u
Available in daily management meetings to support assets
u
Cost data, planning information, flow rates and others, all collected in HANA
u
1 analysis to be used by all, full end to end single sign on implemented
u
Initially all was done with the HANA data connector, data external -> this lead to severe limitations, hence the design has been reviewed and will include information links to allow detailed analysis
Quintus consultants
www.quintus.nl
Q&A
Quintus consultants
www.quintus.nl
Information For more information please contact: André Kooy Phone +31 653 57 31 67 Email
[email protected]
Website www.quintus.nl Quintus consultants b.v. Ruimtesonde 16 3824 MZ Amersfoort The Netherlands
Quintus consultants
Quintus consultants Inc. 1001 S. Dairy Ashford, Suite 100 Houston, TX 77077 USA
www.quintus.nl
Quintus consultants
www.quintus.nl