SAP HANA

This guide provides step-by-step instructions for connecting SAP HANA to Unistream.

Prerequisites

You will need:

• Access to your SAP HANA instance

• Administrator privileges to create a new user (or existing user credentials)

• Host address and port number

• Unistream platform credentials

---

Step 1: Configure Access in SAP HANA

Before connecting to Unistream, you need to create a dedicated user in SAP HANA and grant appropriate permissions.

1.1 Create User

Connect to your SAP HANA instance (using SAP HANA Studio, DBeaver, or another tool) and run the following commands:

-- Create a new user with password
CREATE USER <username> PASSWORD <password> NO FORCE_FIRST_PASSWORD_CHANGE;

Replace:

• <username> with your desired username

• <password> with a secure password

1.2 Grant Permissions

Choose the appropriate permission level based on your needs:

Option A: Grant Access to Entire Schema

-- Grant read access to all objects in a schema
GRANT SELECT ON SCHEMA <schema> TO <username>;

Replace:

• <schema> with your schema name (e.g., SAPABAP1, SYSTEM)

Option B: Grant Access to Specific Tables

-- Grant select on specific tables
GRANT SELECT ON <schema>.<table1> TO <username>;
GRANT SELECT ON <schema>.<table2> TO <username>;

Replace:

• <schema> with your schema name

• <table1>, <table2>, etc. with your table names

Option C: Grant Access to Specific Columns

-- Grant select on specific columns
GRANT SELECT (<column1>, <column2>, ...) ON <schema>.<table> TO <username>;

Replace:

• <schema> with your schema name

• <table> with your table name

• <column1>, <column2>, etc. with your column names

1.3 Example: Complete Setup

Here's a complete example for a schema named SAPABAP1:

-- Create user
CREATE USER unistream_user PASSWORD SecureP@ssw0rd123 NO FORCE_FIRST_PASSWORD_CHANGE;

-- Grant read access to all tables in the schema
GRANT SELECT ON SCHEMA SAPABAP1 TO unistream_user;

-- Optional: Grant monitoring privileges
GRANT MONITORING TO unistream_user;

---

Step 2: Connect to Unistream

2.1 Add SAP HANA Source

1. In Unistream, navigate to Lake

2. Click Add Source

3. Select SAP HANA

2.2 Configure Connection

Fill in the General Fields:

• Name: Enter a descriptive name for your connection (e.g., "Production SAP HANA")

• Code: Enter a unique code identifier (e.g., "prod_hana")

Fill in the Connection Details:

• Host: Your SAP HANA server address

• Port: SAP HANA SQL port (default: 30015 for single-container, 3XX15 for multi-tenant)

• Username: The username you created in Step 1 (e.g., unistream_user)

• Password: The password you set in Step 1

• (Optional) Database: The database name

2.3 Test and Save

1. Click Test Connection to verify the connection is working

2. If the connection is successful, you'll see a success message

3. Click Add to save your connection

Need Help?

If you encounter any issues not covered in this guide, please contact Unistream support