Connect SAP HANA

Set up a direct connection to connect your SAP HANA data source to Bigeye.

1. Allow Bigeye’s IP address

If you've set up network policies to restrict the IP addresses that communicate with your Snowflake instance, modify these policies to allow the Bigeye IP address.

Bigeye makes calls to your warehouse from the following static IP:

35.163.65.120

2. Create a user for Bigeye

Create a dedicated, read-only user for Bigeye. This user must have read access to all tables you want to monitor with Bigeye. Use the sample SQL below to create a user and grant permission.

-- Connect as the SYSTEM user or another user with the necessary privileges

CONNECT SYSTEM PASSWORD <SYSTEM_PASSWORD>;

-- Create the user
CREATE USER [BIGEYE_RO_USER] PASSWORD "[password123]";

-- Grant the necessary privileges to the user, TODO: replace schema and table names with whichever datasets you want to mointor

GRANT SELECT ON <schema_name>.TABLE_1 TO [BIGEYE_RO_USER];
GRANT SELECT ON <schema_name>.TABLE_2 TO [BIGEYE_RO_USER];
GRANT SELECT ON <schema_name>.TABLE_3 TO [BIGEYE_RO_USER];

-- Disconnect from the SYSTEM user
DISCONNECT SYSTEM;

📘

TODO in the script indicates places where placeholder variables must be replaced with real values.

Use the following code to grant read access to all tables in the database, although it’s recommended to restrict access to only the tables you want to monitor.

-- Connect as the SYSTEM user or another user with the necessary privileges

CONNECT SYSTEM PASSWORD <SYSTEM_PASSWORD>;

-- Create the user
CREATE USER [BIGEYE_RO_USER] PASSWORD "[password123]";

-- Grant the necessary privileges to the user
-- The SELECT privilege on _SYS_BIC allows the user to access all current and future tables/views in all schemas

GRANT SELECT ON SCHEMA _SYS_BIC TO BIGEYE_RO_USER WITH GRANT OPTION;

-- To give access to access system views, grant the necessary system privileges (probably not necessary)
GRANT CATALOG READ TO BIGEYE_RO_USER;

-- Disconnect from the SYSTEM user
DISCONNECT SYSTEM;

3. Add SAP HANA as a data source in Bigeye

On the Catalog page, click Add source, and then select SAP HANA from the Choose a data source section. Click Next to configure the connection to your database.

📘

Direct Connection option is also displayed when the agent is enabled in your workspace. To learn about agent connection, see Agent Connection.

The Configure source modal is displayed, where you must enter the following details:

4. Test connection

After configuring the SAP HANA data source, you can test the connection. The system queries your warehouse to validate that the user has the required permissions to read data and run all metric types. If the test connection returns an error, return to Step 2: Create a user for Bigeye and verify that the user has all the required permissions in SAP HANA.