1 General Prerequisites
- 1.1 SAP NetWeaver release
- 1.2 Kyano Java Connector
- 1.3 OS directory and JDBC Driver
2 Create a Database User in SAP Datasphere
3 Create Datasphere storage in Kyano Kyano Storage Management

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

General Prerequisites

SAP NetWeaver release

Kyano Storage Management requires SAP ABAP stack NW 7.01 SP15 or higher.

Kyano Java Connector

Kyano Java connector is a critical middleware component used for communication between SAP and SAP Datasphere. Follow the installation steps described in the Kyano Java connector Setup.

OS directory and JDBC Driver

JDBC protocol is used to connect to SAP Datasphere. THE 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). Component loading and using the driver is the Kyano Java Connector configured in the previous step.

The recommended directory used to store drivers is:

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

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 create a database user first 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 Kyano Kyano Storage Management

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

Storage ID: Logical name of the storage connection.
Storage type: DATASPHERE (SAP Datasphere).
Kyano Java connector RFC: RFC Destination used for communication with Kyano Java Connector.
JDBC Call Repeat: Number of times failed calls should be retried.
JDBC Repeat delay (seconds): Delay between retried calls.
Host Name: SAP Datasphere host name.
Port: The port number SAP Datasphere listens on.
Database name: Name of an existing database in SAP Datasphere.
Database schema: Name of a generated Open SQL Schema in SAP Datasphere.
Username: SAP Datasphere database user.
Password: Database user’s password.
Driver path: Path to the Datasphere JDBC driver directory.
Hints: Optional hints added to the connection string when the 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.