opensap hanacloud1 week 03 advanced persistency features
TRANSCRIPT
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
1/34
Week 3 Unit 1:
Local DevelopmentOctober, 2013
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
2/34
2013 SAP AG All rights reserved 2Public
Local DevelopmentHow Do I Test My Application Locally?
Scenario:
app developer wants to deploy & test
persistence-enabled application locally
application code should run both in the
local dev environment & in the cloud
Eclipse IDE
SAP HANA Cloud Platform
Deploy in the cloud
Deploy and test locally
DB
DB
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
3/34
2013 SAP AG All rights reserved 3Public
Local DevelopmentApplication Scenarios
Default
Application uses only one schema
Application works only with default data-
source binding
Application uses no database-vendor-specific
SQL statements/features
Multiple applications share one
schema
Application uses database-vendor-
specific SQL statements/features
One application uses multiple schemas
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
4/34
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
5/34
2013 SAP AG All rights reserved 5Public
Local DevelopmentLocal Testing Support for Multiple Applications Sharing One Schema
Same as default support
All applications deployed together on
the local server always share the same
schema on Derby
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
6/34
2013 SAP AG All rights reserved 6Public
Local DevelopmentLocal Testing Support for Applications Using a Particular Database
Replace local database with
database system in the cloud
via DB tunnel
a customer installation of a database
Configuring the local server Open/config_master/connection
_data/ connection.properties
Replace with connection parameters
for desired database system*********
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
7/34
2013 SAP AG All rights reserved 7Public
Local DevelopmentLocal Testing Support for Applications Using Multiple Schemas
To configure data sources as
connection properties
Open/config_master/connection_
data/ connection.properties
For every data source used by theapplication
create a database configuration with a
unique prefix to the property key
add the propertycom.sap.cloud.persistence.dsname=
************
************
************
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
8/34
2013 SAP AG All rights reserved 8Public
Local DevelopmentWhat Youve Learned in This Unit
How to test your persistence-enabledapplication on a local server
What Apache Derby is, and how it is
used on SAP HANA Cloud Platform
How to test your application locally
but st ill use the data from yourdatabase in the cloud
How to configure the applications
data sources in the database
connection properties
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
9/34
Week 3 Unit 2:
Using SAP HANA ModelerOctober, 2013
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
10/34
2013 SAP AG All rights reserved 2Public
Using SAP HANA ModelerUsing SAP HANA Data Modeling and Analytics in the Cloud
Scenario:
app developer wants to use SAP HANA
data-persistence and analytic model
artifacts
Specif ics of SAP HANA Cloud Platform Schemas on trial landscape:
shared SAP HANA database systems
Application isolation based on schema and
package namespace
Applications database user has restricted
permissions
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
11/34
2013 SAP AG All rights reserved 3Public
Using SAP HANA ModelerConnect to Your Database in SAP HANA Cloud
Create schema of DB type HANA XS and name it opensap
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
12/34
2013 SAP AG All rights reserved 4Public
EPMsample
data
Applicationschema
Applicationpackage
EPMsample
data
Using SAP HANA ModelerConnect to Your Database in SAP HANA Cloud
Open a database tunnel
Connect SAP HANA studio to
opensap schema
In SAP HANA Systems View:Application schema
Personal schema not used
Application package
EPM application sample data
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
13/34
2013 SAP AG All rights reserved 5Public
Using SAP HANA ModelerEPM Reference Application
Enterprise Procurement ModelReference Application
Used for demo and testing purposes
Pre-delivered data content for
SAP HANA Cloud trial accounts
Multiple tables available
Addresses
Business partners
Employees
Products
Sales orders
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
14/34
2013 SAP AG All i ht d 6P bli
Using SAP HANA ModelerDemo Scenario
Create calculation viewon top of EPM data
Create calculation v iew arti fact
Activate view
Grant permissions to
applications db user
CALL "HCP" . "HCP_GRANT_SELECT_ON_ACTI VATED_OBJ ECTS"
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
15/34 2013 SAP AG. All rights reserved. 7Public
Using SAP HANA ModelerDemo Scenario
Visualize View content ina Web application
Consume calculation view
in JDBC sample
Declare data source jdbc/opensapDS in web.xml
Select content in servletSELECT TOP 10 * FROM "_SYS_BI C" . " " "SO_CV" ORDER BY . . .
Bind opensap schema
to JDBC sample
Deploy and start JDBC sample
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
16/34 2013 SAP AG. All rights reserved. 8Public
Using SAP HANA ModelerWhat Youve Learned in This Unit
How to create a calculation view
How to activate objects in SAP HANA
studio
How to grant permissions for your
user to select data from activated
objects How to consume calculation view
content in a Java servlet
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
17/34
Week 3 Unit 3: Introduction to
the Document Service
October, 2013
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
18/34 2013 SAP AG. All rights reserved. 2
P bli
Introduction to the Document ServiceOverview
Stores files and folders in the cloud
Open standards-based
Easy to consume
Usage-based pricing
Scalable
High availability setup
Secure
Multi-tenancy-enabled
Document Service API
Document Service
SAP HANA Cloud PlatformApps
Internet
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
19/34 2013 SAP AG. All rights reserved. 3
P bli
Introduction to the Document ServiceCMIS
CMIS Standard at OASIS CMIS defines semantics and protocols
Major ECM companies on the committee
SAP is an active contributor
Apache Chemistry CMIS libraries for various languages
Development tools: CMIS Workbench
Technology Compatibility Kit (TCK) for CMIS
SAP actively contributes and chairs this project
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
20/34 2013 SAP AG. All rights reserved. 4
P bli
Introduction to the Document ServiceSupported Features
CMIS features
Files & folders Metadata (types & properties)
Queries via CMISQL
Versioning
Permission handling (ACL)
Retention management
Additional features
AES encryption of content Virus scan on upload
Multi-tenancy support
Repository lifecycle
Backups to multiple locations
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
21/34 2013 SAP AG. All rights reserved. 5
P bli
Introduction to the Document ServiceDemo: HelloWorld
Simple Web application
Connects to Document service
Creates a folder and a file
Reads & prints the folders entries
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
22/34 2013 SAP AG. All rights reserved. 6
P bli
Introduction to the Document ServiceWhat Youve Learned in This Unit
How the Document service works
The CMIS standard
How to deploy the first demo
application in combination with the
Document service
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
23/34
Week 3 Unit 4: Consuming the
Document Service with Ext. Tools
October, 2013
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
24/34 2013 SAP AG. All rights reserved. 2
Consuming the Document Service with Ext. ToolsExternal Access to Document Repository
Documents in the cloud only accessible toapps deployed in the same account
Proxy Bridge
Tunnels external CMIS requests to Document
service
Restricts access with roles or filters
Access to repository via unique name + key
Document Service
SAP HANA Cloud
Proxy Bridge
No direct
access
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
25/34 2013 SAP AG. All rights reserved. 3
Consuming the Document Service with Ext. ToolsDemo: Proxy Bridge
Implement the Proxy Bridge by:
SubclassingAbstractCmisProxyServlet
Declaring the servlet in web.xml
Declaring roles to secure access
Deploying to the cloud & assigning a role
in the cockpit
Connecting to Proxy Bridge with
CMIS Workbench allows you to:
Create folders & upload files
View & edit metadata
Execute any CMIS-defined operation
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
26/34 2013 SAP AG. All rights reserved. 4
Consuming the Document Service with Ext. ToolsWhat Youve Learned in This Unit
How to access the documentrepository with external tools
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
27/34
Week 3 Unit 5: Document Service
Metadata & Queries
October, 2013
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
28/34
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
29/34
2013 SAP AG. All rights reserved. 3
Document Service Metadata & QueriesMetadata Coding Example
Setting propertiesList tags = Arrays.asList("Hello", "Tutorial");
Map properties = new HashMap();
properties.put("sap:tags", tags);
doc.updateProperties(properties);
Getting properties// all properties
List
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
30/34
2013 SAP AG. All rights reserved. 4
Document Service Metadata & QueriesQueries with the CMIS Workbench
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
31/34
2013 SAP AG. All rights reserved. 5Public
Document Service Metadata & QueriesAdvanced Features
Many more features waiting to betried out:
Use ACLs and define read or write
permissions on files/folders
Create versions of files to track changes
Use other external CMIS tools to access
your data
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
32/34
2013 SAP AG. All rights reserved. 6Public
Document Service Metadata & QueriesWhat Youve Learned in This Unit
How to attach properties todocuments
How to query properties in Java
How to query with the CMIS
Workbench
Advanced features for the
Document Service
-
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
33/34
Thank you
Contact information:
mailto:[email protected]:[email protected] -
8/13/2019 OpenSAP HANACLOUD1 Week 03 Advanced Persistency Features
34/34
2013 SAP AG. All rights reserved.
No part of this publicat ion may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG.The information contained herein may be changed without prior notice.
Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.
National product specifications may vary.
These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or
warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group
products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing
herein should be construed as constituting an additional warranty.
SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in
Germany and other countries.
Please see http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark for additional trademark information and notices.
http://www.sap.com/corporate-en/legal/copyright/index.epx#trademarkforhttp://www.sap.com/corporate-en/legal/copyright/index.epx#trademarkforhttp://www.sap.com/corporate-en/legal/copyright/index.epx#trademarkforhttp://www.sap.com/corporate-en/legal/copyright/index.epx#trademarkfor