(SM-2405) SAP Datasphere

 

Storage management supports connecting to SAP Datasphere Space via a database user. To successfully establish a connection, it is required to have created a Space in SAP Datasphere and within that Space, a database user must be created with enabled Read and Write access.

General Prerequisites

Reuse Library release

SAP Datasphere integration is available in Reuse Library 2402 or higher.

SAP NetWeaver release

Storage management requires SAP ABAP stack NW 7.01 SP15 or higher.

Java connector

Java connector is a critical middleware component used for communication between SAP and SAP Datasphere. Follow the installation steps described in the Java Connector Setup.
The minimum required Java connector version for SAP Datasphere integration is 240.

OS directory and JDBC Driver

JDBC protocol is used to connect to SAP Datasphere. SAP HANA JDBC driver needs to be manually copied to the operating system and accessible to the connector. Download the SAP HANA JDBC driver. The latest version of the SAP HANA JDBC driver is recommended.

It is recommended to store the drivers in a directory shared between application servers, organized in sub-directories to avoid possible conflicts (some customers connect to multiple different platforms/services).

The default directory used to store drivers needed for communication with remote storages/services is:

$ ls -ld /sapmnt/<SID>/dvd_conn rwx------ 2 dvqadm sapsys 4096 --- /sapmnt/<SID>/dvd_conn

The actual SAP HANA JDBC driver should be put into a dedicated sub-directory, for example:

$ ls -ld /sapmnt/<SID>/dvd_conn/* drwxr-xr-x 2 dvqadm sapsys 4096 --- /sapmnt/<SID>/dvd_conn/hana $ ls -l /sapmnt/<SID>/dvd_conn/hana drwxr-xr-x 2 dvqadm sapsys 4096 --- /sapmnt/<SID>/dvd_conn/hana/ngdbc-2.19.16.jar

Set its ownership and permissions appropriately to <sid>adm[:sapsys].

Create a Database User in SAP Datasphere

You must first create a database user to establish a connection to SAP Datasphere. Please refer to the provided guide for instructions, ensuring to enable both Write access (SQL, DDL, & DML) and Read access (SQL).

Create Datasphere storage in Storage Management

Go to transaction /DVD/SM_SETUP
Create new storage of type DATASPHERE

Storage ID: Logical name of the storage connection.
Storage type: DATASPHERE (SAP Datasphere).
Java connector RFC: RFC Destination used for communication with JCo.
JDBC Call Repeat: Number of times failed calls should be retried.
JDBC Repeat delay (seconds): Delay between retried calls.
Host Name: The host name.
Port: The port number.
Database name: Name of an existing database name in SAP Datasphere.
Database schema: Name of a generated Open SQL Schema in SAP Datasphere.
Username: The name of your SAP Datasphere database user.
Password: The password for the database user.
Driver path: Path to Datasphere driver directory.
Hints: Additional string added to connection string when JDBC driver establishes a connection.
Connection pool size: Number of connections that can be kept open in the pool, reducing resource-expensive establishment of JDBC connections.