Motorola CD202 Instrukcja Użytkownika

Dr. Jasmin Gruschke, SAP AG Dr. Steffen Weinstock, SAP AG Tobias Wenner, SAP AG September, 2012 CD162 Accelerating ABAP Applications Using the Best Fe

© 2012 SAP AG. All rights reserved. 10 ABAP Database Connectivity (ADBC)

© 2012 SAP AG. All rights reserved. 11 ADBC - Introduction Object-based ABAP API for programming relational database access  Access to entire SQL

© 2012 SAP AG. All rights reserved. 12 ADBC – Typical steps Reading from the database Creating a database table Inserting data into the database

© 2012 SAP AG. All rights reserved. 13 ADBC – Your tools CL_SQL_CONNECTION  GET_CONNECTION  CREATE_STATEMENT and PREPARE_STATEMENT  ROLLBACK and C

Demo

Exercise

Suggested solution

HANA full text search capabilities

© 2012 SAP AG. All rights reserved. 18 HANA - Powerful and high-speed text search Linguistic search Multi col

Demo

© 2012 SAP AG. All rights reserved. 2 Disclaimer This presentation outlines our general product direction and should not be relied on in making a pur

Pushing down code to HANA with SQLScript

© 2012 SAP AG. All rights reserved. 21 SQLScript - Motivation “Classic way” Load all data into application server and compute • All data is copied •

© 2012 SAP AG. All rights reserved. 22 SCURR date source/target currency conversion rate SBOOK carrier booking date currency/amount SBOOK example To

Demo SBOOK example in ABAP

© 2012 SAP AG. All rights reserved. 24 SQLScript - Syntax CREATE PROCEDURE myprocedure ( IN from nvarchar(3), IN to nvarchar(3), OUT re

Demo SBOOK example: create SQLScript procedure

© 2012 SAP AG. All rights reserved. 26 SQLScript - Call CREATE GLOBAL TEMPORARY ROW TABLE cd162_cuco_tab ( name nvarchar(20), amount deci

Demo SBOOK example: run both implementations

Exercise

Suggested solution

© 2012 SAP AG. All rights reserved. 3 Agenda SAP HANA Application Accelerator Take Full Advantage of the HANA SQL Functionality with ABAP Database C

Outlook and summary

© 2012 SAP AG. All rights reserved. 31 SQLScript - Outlook Next release of ABAP contains built-in call for SQLScript procedures

© 2012 SAP AG. All rights reserved. 32 Summary Non-disruptive performance boosts thanks to SAP HANA Application Accelerator Exploit the tremendous H

© 2012 SAP AG. All rights reserved. 33 SAP NetWeaver Application Server ABAP Empowering classic & new SAP products and Custom Development • 50.00

© 2012 SAP AG. All rights reserved. 34 Further information SAP Public Web http://scn.sap.com/community/developer-center/ http://scn.sap.com/communit

Feedback Please complete your session evaluation for CD162 Thanks for attending this SAP TechEd session.

© 2012 SAP AG. All rights reserved. 36 No part of this publication may be reproduced or transmitted in any form or for any purpose without the expres

SAP HANA Application Accelerator

© 2012 SAP AG. All rights reserved. 5 SAP HANA Application Accelerator I Hana data base Instr.Appl. Serverrsdb/rda = onMain data baseAppl. Server 2Ap

Demo

© 2012 SAP AG. All rights reserved. 7 SAP HANA Application Accelerator II

© 2012 SAP AG. All rights reserved. 8 SAP HANA Application Accelerator – Useful documentation links User documentation -> SAP note 1694697 Second

ABAP Database Connectivity (ADBC)