ETLs

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:

SAP2

  • 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}