Connectivity Summary
An out-of-the-box connector is available for SAP HANA databases to support crawling database objects, profiling sample data, and lineage building. The connectivity to SAP HANA is via the JDBC driver, which is included in the platform.
The drivers used by the connector are mentioned below:
Driver/API: ngdbc.jar
Version: 2.2.16
Details: N/A
Technical Specifications
The following are the connector capabilities mentioned below:
Crawling
Supported objects for Crawling are:
- Tables
- Table Columns
- Views
- Stored Procedures
- Functions
Profiling
See this article Profile Data to know more about Profiling.
Feature | Support | Remarks |
Table Profiling | Row count, Columns count, View sample data | |
View Profiling | Row count, Columns count, View sample data | View is treated as a table for profiling purposes |
Column Profiling | Min, Max, Null count, distinct, top 50 values | |
Full Profiling | Supported | |
Sample Profiling | Supported |
Lineage Building
Lineage Entities | Details |
Table lineage | Supported |
Column lineage | Supported |
Lineage Sources | Stored procedures, functions, triggers, views, SQL queries (from Query Sheet) |
Querying
Operation | Details |
Select | Supported |
Insert | Not supported, by default. |
Update | Not supported, by default. |
Delete | Not supported, by default. |
Joins within database | Supported |
Joins outside database | Not supported |
Aggregations | Supported |
Group By | Supported |
Order By | Supported |
By default, the service account provided for the connector will be used for any query operations. If the service account has write privileges, then Insert / Update / Delete queries can be executed.
Pre-requisites
To use the connector, the following need to be available:
- Connection details as specified in the following section should be available.
- An admin / service account with read privileges.
- JDBC driver is provided by default. In case it needs to be changed, add SAP HANA client drivers into the OvalEdge Jar path to communicate to SAP HANA database.
Connection Details
The following are the connection settings that need to be added for connecting to SAP HANA database:
- Database Type: SAP HANA
- Connection Name: Select a Connection name for the SAP HANA database. The name that you specify is a reference name to easily identify your SAP HANA database connection in OvalEdge.
Example: SAP HANA UAT - Hostname / IP Address: Database instance IP Address/ domain (on-premises)
- Port number: 30015
- Sid/Database: Name of the database to connect.
- Username: User account login credential
- Password: Password
- Driver Name: JDBC driver name for SAP HANA. It will be auto-populated.
Example: com.sap.db.jdbc.Driver - Connection String: SAP HANA connection string. Set the Connection string toggle button to automatic, to get the details automatically from the credentials provided. Alternatively, you can manually enter the string.
Format: jdbc:sap://{server}:30015/?autocommit=false
Once connectivity is established, additional configurations for Crawling and Profiling can be specified.
Property | Details |
Crawler configurations | |
Procedures, Functions, Views | |
Tables, Views and Columns | |
Relationships | |
Profiler Settings | |
Auto | This is used for full profiling (if the actual row count is less than configured) |
Sample | This will perform profiling on sample profile size for ex: on 10000 records |