R Integration with SAP HANA

Here are the prerequisites you must have before trying your hands on “R”

HBDCLIENT

HDServer

R-ODBC Package

R Studio

Setup the Data source (in this case SAP HANA DB Server)

Go to Service Marketplace -> Software Downloads -> Support Packages and Patches -> A-Z –> H–> SAP HANA PLATFORM EDITION” –> SAP HANA PLATFORM EDIT. 1.0” –> Entry by Component” –> HANA client

Connecting SAP HANA 1.0 to MS SQL Server 2012 for Data Provisioning

There are several Data Provisioning techniques available within SAP HANA. These are "Smart Data Access" (SDA) and "Smart Data Integration" (SDI). Also available is the Hadoop Integration. This Document will cover the connectivity between SAP HANA 1.0 and MS SQL Server 2012 for SDA and SDI.

In the nature of things it is quite tricky to connect a Linux based Application (In our case SAP HANA 1.0) to a Microsoft Windows based Application (In our case MS SQL Server 2012). The official Documentation guides you to the right direction. But, as so often, it tells only half the truth. This Document will show you the rest of the required Information.

1. Prequel
Please find here some Information before we start. These Information are Resources, Guides, Links, etc.

1.1 Exclusion
This Documents excludes the process of installing and configuring SAP HANA and MS SQL Server 2012. Please consult the official documentation for the correct process.