-
Roadmap
-
Knowledgebase Documents
-
Installation and System Setup
-
Setup Data Catalog
-
Connectors
-
Data Discovery
-
Self Service
-
Access Management
-
Data Quality
-
Data Literacy
-
Privacy Compliance
-
Reporting
-
Architecture, Security & Releases
-
Developer's Zone
-
Advanced Tools
-
Record of Processing Activities (ROPA)
-
Others
-
Release6.0 User Guide
-
Release6.1 Features
-
Data Catalog
-
News
-
Deactivated_Old
-
Release6.3 Deep Dive Articles
SAP BODS
Connectivity Summary
An out-of-the-box connector is available for SAP BODS to support crawling datasets, i.e, SAP BODS Jobs, workflows, data flows, and lineage building.
The connectivity to SAP BODS is via JDBC, which is included in the platform.
Technical Specifications
The following are connector capabilities mentioned below:
Crawling
Supported objects for Crawling are: Jobs - It fetches all the workflows and data flows from jobs.
Lineage Building
Lineage Entities | Details |
Table - Table | Supported |
Table -File Lineage | Supported |
File - Table Lineage | Supported |
Column lineage - File Column Lineage | Supported |
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 |
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 for crawling requires the following minimum privileges:
Operation Access Permission Connection validate Should have permission on the database.
Connection Details
The following are the connection settings that need to be added for connecting an SAP BODS:
- Database Type: SAP BODS
- License Type: Standard or Auto Lineage
- Connection Name: Select a Connection name for the SAP BODS. The name you specify is a reference name to identify the SAP BODS connection in OvalEdge easily.
Example: sapbods1 - Server: IP Address of SAP BODS
- Port number: Provide the valid port
- Database: Provide the valid database name
- Driver: oracle.jdbc.driver.OracleDriver
- Username: Provide the valid username
- Password: Provide a valid password
- Connection String: jdbc:oracle:thin:@{server}:{port}:{sid}