SAPHANADeveloperGuideForSAPHANAWebWorkbench

需积分: 13 144 浏览量更新于2023-05-30 评论收藏 5.32MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

PUBLIC

SAP HANA Platform 2.0 SPS 03

Document Version: 1.1 – 2018-10-31

SAP HANA Developer Guide

For SAP HANA Web Workbench

THE BEST RUN

Content

1 SAP HANA Developer Guide for SAP HANA Web-Based Development Workbench........... 6

2 SAP HANA Web-Based Development Workbench.................................... 7

2.1 SAP HANA Web-based Development Workbench: Editor................................. 8

Editor Settings............................................................10

Text Editing Keyboard Shortcuts............................................... 13

Toolbar and Context-Menu Options in the Editor....................................15

2.2 SAP HANA Web-based Development Workbench: Catalog................................18

Catalog Settings..........................................................20

SQL Console.............................................................22

SQL Result Table and Data Preview Table.........................................24

2.3 SAP HANA Web-based Development Workbench: Trace.................................26

Trace Settings............................................................28

Database Trace...........................................................29

SQL Trace...............................................................30

Plan Trace...............................................................31

3 Getting Started with Application Development.................................... 34

3.1 Tutorial: Create a Simple SAPUI5 Application........................................ 34

3.2 Tutorial: Create and Debug a Server-side JavaScript Application...........................36

3.3 Maintaining Repository Packages.................................................38

Repository Package Hierarchy................................................ 38

Dene Repository Package Privileges........................................... 40

Create Repository Packages..................................................43

Delete Repository Packages..................................................46

3.4 Creating the Application Descriptors...............................................47

Dene the Application Root Package............................................48

Enable Access to the Application Packages....................................... 50

Dene Application Access Privileges............................................64

3.5 Maintaining Application Artifacts.................................................68

Design-Time Application Artifacts..............................................68

File Versions............................................................. 71

3.6 Storing Source Code on GitHub..................................................73

3.7 Maintaining Application Security................................................. 75

Set up Application Security...................................................76

Set up Application Authentication..............................................77

3.8 Maintaining HTTP Destinations..................................................80

P U B L I C

SAP HANA Developer Guide

Content

Tutorial: Create an HTTP Destination............................................81

HTTP Destination Conguration Syntax..........................................83

The HTTP Destination Extension...............................................90

Tutorial: Create an OAuth Conguration Package...................................92

4 Setting up the Data Persistence Model in SAP HANA...............................106

4.1 Creating the Persistence Model in Core Data Services..................................108

Tutorial: Get Started with CDS................................................109

Create a CDS Document....................................................112

Create an Entity in CDS.....................................................134

Create a User-Dened Structured Type in CDS.................................... 151

Create an Association in CDS................................................ 164

Create a View in CDS...................................................... 178

Modications to CDS Artifacts................................................198

Tutorial: Import Data with CDS Table Import......................................202

Migrate an Entity from HDBTable to CDS (hdbdd)..................................214

4.2 Creating the Persistence Model with HDBTable...................................... 218

Create a Schema.........................................................219

Tutorial: Create a Table.....................................................222

Create a Reusable Table Structure.............................................231

Create an SQL View.......................................................234

Create a Sequence........................................................239

Create a Synonym........................................................247

Tutorial: Import Data with HDBTable Table Import..................................251

5 Developing Procedures......................................................264

5.1 Create and Edit Procedures....................................................265

Dene and Use Table Types in Procedures....................................... 267

Tutorial: Create an SQLScript Procedure that Uses Imperative Logic.....................269

5.2 Tutorial: Create a Scalar User-Dened Function......................................272

5.3 Tutorial: Create a Table User-Dened Function.......................................274

5.4 SQLScript Security Considerations...............................................276

5.5 Debugging Procedures....................................................... 278

Debug Privileges for Procedures.............................................. 278

Assign the DEBUG Privilege................................................. 279

Assign the ATTACH DEBUGGER Privilege ....................................... 280

Debug Procedures........................................................281

Debug an External Session..................................................284

6 Dening Web-based Data Access in XS Classic....................................286

6.1 Data Access with OData in SAP HANA XS..........................................286

OData in SAP HANA XS.................................................... 287

SAP HANA Developer Guide

Content

P U B L I C 3

Tutorial: Use the SAP HANA OData Interface..................................... 288

Dene the Data an OData Service Exposes.......................................292

Create an OData Service Denition............................................293

OData Service Denitions...................................................294

OData Service-Denition Examples............................................298

OData Service Denition Language Syntax (XS Advanced)............................321

OData Service Denition: SQL-EDM Type Mapping (XS Advanced)......................323

OData Security Considerations...............................................325

OData Batch Requests (XS Advanced)..........................................325

6.2 Data Access with XMLA in SAP HANA XS.......................................... 328

XML for Analysis (XMLA)...................................................329

Tutorial: Use the SAP HANA XMLA Interface......................................330

Dene the Data an XMLA Service Exposes.......................................332

Create an XMLA Service Denition............................................ 333

XMLA Service Denition....................................................334

XMLA Security Considerations...............................................334

Multidimensional Expressions (MDX)...........................................335

MDX Functions.......................................................... 336

MDX Extensions......................................................... 338

6.3 Using the SAP HANA REST API................................................. 340

SAP HANA REST Info API...................................................342

SAP HANA REST File API...................................................342

SAP HANA REST Change-Tracking API..........................................348

SAP HANA REST Metadata API...............................................349

SAP HANA REST Transfer API................................................350

SAP HANA REST Workspace API..............................................351

7 Writing Server-Side JavaScript Code...........................................354

7.1 Data Access with JavaScript in SAP HANA XS.......................................354

7.2 Using Server-Side JavaScript in SAP HANA XS...................................... 355

Tutorial: Write Server-Side JavaScript Application Code..............................355

JavaScript Editor.........................................................358

Displaying the Function Flow.................................................360

Getting Immediate Feedback................................................ 362

Server-Side JavaScript Security Considerations...................................364

7.3 Using Server-Side JavaScript Libraries............................................374

Import Server-Side JavaScript Libraries.........................................376

Write Server-Side JavaScript Libraries..........................................377

7.4 Using the Server-Side JavaScript APIs............................................ 378

Tutorial: Use the XSJS Outbound API...........................................390

Tutorial: Call an XS Procedure with Table-Value Argument............................393

Tutorial: Query a CDS Entity using XS Data Services................................398

P U B L I C

SAP HANA Developer Guide

Content

Tutorial: Update a CDS Entity Using XS Data Services...............................402

7.5 Creating Custom XS SQL Connections............................................405

Create an XS SQL Connection Conguration..................................... 407

The SQL Connection Conguration File.........................................409

SQL Connection Conguration Syntax..........................................410

7.6 Setting the Connection Language in SAP HANA XS....................................411

7.7 Scheduling XS Jobs..........................................................413

Tutorial: Schedule an XS Job.................................................414

Add or Delete a Job Schedule during Runtime.................................... 423

7.8 Tracing Server-Side JavaScript..................................................424

Tutorial: Trace a Server-Side JavaScript Application................................ 425

7.9 Debugging Server-Side JavaScript...............................................426

Tutorial: Create and Debug a Server-side JavaScript Application........................427

XSJS Debugger..........................................................429

XSJS Debugger Role.......................................................431

Debug Session Access.....................................................431

7.10 Testing XS JavaScript Applications...............................................432

Automated Tests with XSUnit in SAP HANA......................................434

Application Development Testing Roles.........................................435

Test an SAP HANA XS Application with XSUnit....................................435

Testing JavaScript with XSUnit...............................................449

8 Building UIs..............................................................456

8.1 Building User Interfaces with SAPUI5 for SAP HANA.................................. 456

8.2 Consuming Data and Services with SAPUI5 for SAP HANA..............................457

8.3 SAPUI5 for SAP HANA Development Tutorials.......................................458

Tutorial: Create a Hello-World SAPUI5 Application..................................459

Tutorial: Consume an XSJS Service from SAPUI5..................................462

Tutorial: Consume an OData Service from SAPUI5................................. 466

Tutorial: Consume an OData Service with the CREATE Option..........................472

9 Setting Up Roles and Privileges............................................... 479

9.1 Create a Design-Time Role.....................................................480

Change a Design-Time Role................................................. 482

Database Roles..........................................................484

Privileges..............................................................496

9.2 Run the File Access Check for Roles.............................................. 515

9.3 Creating Analytic Privileges....................................................516

Create Static SQL Analytic Privileges...........................................517

Create Classical XML-Based Analytic Privileges....................................519

Analytic Privileges........................................................ 521

SAP HANA Developer Guide

Content

P U B L I C 5

剩余545页未读，继续阅读

leeym0216

粉丝: 0
资源: 11

会员权益专享

SAP HANA Developer Guide For SAP HANA Web Workbench

评论0

会员权益专享

最新资源

SAP HANA Developer Guide For SAP HANA Web Workbench

评论0

基于物联网智能门锁系统设计与开发_物联网冷链和电子锁专业论文设计范文.pdf

三分钟看懂ChatGPT.zip

扬州非遗文化在文创产品设计中的应用研究__非文化专业论文设计范文.pdf

开发轮子（一）：全国省/市/区/街道三、四级联动

基于单片机的水温水位控制系统设计.doc

学校网络及网络安全管理规定.docx

计算机周报：注册制全面推行，ChatGPT推动AI新场景落地.zip

学校网络安全管理制度.doc

学生网络安全方案设计.docx

DNS域名解析中A、AAAA、CNAME、MX、NS、TXT、SRV、SOA、PTR各项记录的作用

云服务器数据安全保护软件项目询价文件.doc

计算机-ChatGPT算法突破，泛AI加速

互联网传媒行业周报：ChatGPT试点付费订阅，生活服务消费正在复苏.zip

修改 设置-壁纸 中,无法分别设置主屏壁纸和锁屏壁纸问题.patch

安全地使用网络.pptx

MCX653106A-ECAT ROCE v2测试报告-2023.6.2.xlsx

光影图标.apk

修改设置-显示 中无法设置照片屏保问题.patch

非遗文化融入文创产品设计中的应用研究_非文化专业论文设计范文.pdf

企业网络安全防护技术措施.doc

会员权益专享

最新资源

修改设置-壁纸中,无法分别设置主屏壁纸和锁屏壁纸问题.patch

修改设置-显示中无法设置照片屏保问题.patch