ETLs
      Back to home
      1. Knowledge Base
      2. Connectors
      3. 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}