SAP HANA for Oracle Developers - by the SAP HANA Academy

[dvankempen]

What's New?

We have just started recording a number of video tutorials for the SAP HANA Academy specifically targeted to Oracle developers.

In this series, we assume that you are familiar with the Oracle database but that you might need some guidance for SAP HANA.

Where can you find documentation? Any free training? How does the SAP HANA in-memory technology relates to Oracle's?

This will be an ongoing project, so please feel free to leave your comments below about topics that you wish to have addressed.

• PL/SQL vs SQLScript?
• Column storage?
• What tool to use?

Complete playlist: SAP HANA for Oracle Developers - YouTube

Introduction

In the first video, the SAP Community Network, the SAP Help Portal, the SAP Support Portal and the Product Availability Matrix are introduced. Knowing where to find information is critical for success.

Deployment Options

The next video discusses deployment options for SAP HANA with some background about the start of HANA as an appliance and the Tailored Data Center Integration option introduced with SPS 06.

The hosted options are presented:

• SAP HANA One on Amazon Web Services (AWS)
• SAP HANA Developer Edition
• SAP Cloud Appliance Library
• SAP HANA Cloud Platform

Developer Edition(s)

The next video discusses the SAP HANA developer editions hosted by Amazon Web Services and Microsoft Azure.

See also the great Step-by-step guide for deployment of SAP HANA Developer Edition on Microsoft Azure | Microsoft Azure... and AWS | Getting Started with SAP.

Connecting to the Developer Edition

The next video shows how to connect to the developer edition and shows the web interface to manage your SAP HANA instance, how to connect using SAP HANA studio and also how to connect on the command line using SSH.

Architecture

Now that we can connect to the SAP HANA database, we take a look at the SAP HANA architecture as compared to Oracle's.

Connectivity options are discussed: ODBC/JDBC, ODBO, XML/A, OData.

The different system services: indexserver, name server, compile server, etc.

In-Memory

The next video discusses SAP HANA in-memory: What's the difference between a traditional database and an In-Memory Platform?

Thank you for watching

You can view more free online videos and hands-on use cases to help you answer the What, How and Why questions about SAP HANA and the SAP HANA Cloud Platform on the SAP HANA Academy at youtube.com/saphanaacademy, follow us on Twitter @saphanaacademy, or connect to us on LinkedIn.