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
© 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
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)
Commentaires sur ces manuels