EBS Table

OvalEdge uses a JDBC driver to connect to the data source, which allows the user to crawl and profile database objects (Tables, Table Columns, Views).

Connector Characteristics

Connector Category	RDBMS System
Connectivity	JDBC
Connector Version [OvalEdge Connector Version Information]	Release6.3
EBS Table Versions Supported [Data Source Version from which OvalEdge started providing support]	EBS Tables are supported by OvalEdge until version 19
OvalEdge Releases Supported (Available from) [OvalEdge Release Version in which the connector was included in the OvalEdge Application]	Release6.3 onwards

Connector Features

Crawling of Metadata Objects	Supported
Profiling	Supported
Profiling Methodologies
Full Profiling Sample Profiling
Query Sheet	Supported
Data Preview	Supported
Authentication via Credential Manager	Supported
Data Quality	Supported
DAM (Data Access Management)	Not Supported
Bridge	Supported

Prerequisites

The following are the prerequisites required for establishing a connection:

1. Whitelisting Ports: Ensure the inbound port “1521” is whitelisted for OvalEdge to connect to the EBS Table database.

2. OvalEdge artifacts include the required drivers for supported databases. You have to download the jar file from the following link and place it in the external jar folder:

https://ovaledge-jars.s3.amazonaws.com/third_party_jars/third_party_jars_latest/ojdbc8.jar

1. Service Account Permissions

Administrator privileges are required to run these commands.

The following are the privileges needed for a service account to crawl and profile the data:

Operation	Access Permission
Connection Validation	Select
Crawl Schemas	Select
Crawl Tables	Select
Profile Schemas, Tables	Select

Data Source Configuration in OvalEdge

Connector Creator privileges are required for data source connection configuration.

1. Log into OvalEdge, go to Administration > Connectors, click + (New Connector), search for EBS Table, and complete the specific parameters.

Note: Fields marked with an asterisk (*) are mandatory for establishing a connection.

Field Name	Description
Connector Type	By default, "EBS Table" is displayed as the selected connector type.
Connector Settings
Credential Manager*	Select the desired credentials manager from the dropdown list. Relevant parameters will be displayed based on your selection. Supported Credential Managers: OE Credential Manager AWS Secrets Manager HashiCorp Vault Azure Key Vault
License Add Ons	OvalEdge connectors have a default license add-on for data crawling and profiling. Select the checkbox for Data Quality Add-On to identify data quality issues using data quality rules and anomaly detection.
Connector Name*	Enter a unique name for the EBS Table connection (Example: "EBS_Prod").
Connector Environment	Select the environment (Example: PROD, STG) configured for the connector.
Server*	Specify the name of the EBS Table database instance server IP/URL accessible by the OvalEdge application. For example, IP: 190.x1.x3.xx90 Server: ebstable.com
Port*	By default, port number 1521, related to the EBS Table database, is displayed. A new port number can be provided if needed.
Database*	Enter the source database name for crawling.
Database Type	Select the database type as SID or SERVICE_NAME. EBS Table SID is the name that uniquely identifies the instance/database, and a service name is an alias for the EBS Table server.
Driver*	A JDBC driver is a Java library file with the extension .jar that connects to a database. By default, the driver details associated with the EBS Table database will be auto-populated.
Username*	Enter the Service Account Username of the EBS Table Server.
Password*	Enter the password of the EBS Table server.
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:oracle:thin:@{server}:1521:{sid} Example: jdbc:oracle:thin:@oe.com:1521:ovaledgedb
Default Governance Roles
Default Governance Roles*	Select the appropriate users or teams for each governance role from the dropdown list. All users and teams configured in OvalEdge Security are displayed for selection.
Admin Roles
Admin Roles*	Select one or more users from the dropdown list for Integration Admin and Security and Governance Admin. All users configured in OvalEdge Security are available for selection.
No Of Archive Objects*	It indicates the number of recent metadata changes to a dataset at the source. By default, it is off. You can enable it by toggling the Archive button and specifying the number of objects to archive. Example: Setting it to 4 retrieves the last four changes, shown in the 'version' column of the 'Metadata Changes' module.
Select Bridge*	The dropdown displays the bridges set up in Manage Bridge. Select the appropriate bridge that enables seamless connectivity between data sources without altering firewall rules.

1. After entering all connection details, you can perform the following actions:

• Click Validate to verify the connection.

• Click Save to store the connection for future use.

• Click Save & Configure, allowing you to configure the necessary settings before saving the connection.

1. The saved connection will appear on the Connectors home page.

Errors and Resolution

If incorrect parameters are provided, you may encounter error messages. To resolve these issues, ensure all input is correct. If problems persist, contact your assigned OvalEdge support team.

S.No	Error Message(s)	Description
1	Failed to establish a connection, please check the credentials.	In case of an invalid username and password.

Connector Settings

The EBS Table connector offers various settings to customize data crawling, profiling, and access. These include:

• Crawler: Configure data that needs to be extracted.

• Profiler: Customize data profiling rules and methods.

• Query Policies: Define rules for executing queries based on roles.

• Access Instructions: Specify how data can be accessed as a note.

• Business Glossary Settings: Manage term associations at the connector level.

• Anomaly Detection Settings: Anomaly Detection Settings enable users to configure anomaly detection preferences at the connector level.

• Others: Configure notification recipients for metadata changes.

Crawl/Profile

Integration Admin privileges are required for Crawl/Profile operations.

Navigate to the Connectors page and click Crawl/Profile. A search field will be displayed, where you can search the specific tables by entering three characters followed by %; based on this, all the matched tables will be displayed from all the schemas.

Select Crawl, Profile, Unprofiled, or Scheduled based on the requirement. Click on the Run that gathers all metadata from the connected source into the OvalEdge Data Catalog.

Manage Connector

The Connectors page in OvalEdge provides a centralized view of all configured connectors, including their health status. Using the Nine Dots menu, you can view, edit, validate, and delete connectors.

Managing connectors includes:

• Connectors Health: Displays performance with a green (active) or red (inactive) icon, helping monitor data flow and address issues early.

• Viewing: Shows connector details (e.g., Databases, Tables, Table Columns, and Codes) via the View icon.

Nine Dots Menu Options:

• Edit Connector: Update and revalidate the data source.

• Validate Connector: Check the connection's integrity.

• Settings: Modify connector settings.

• Delete Connector: Remove connectors or schemas with confirmation.

Limitations

S.No.	Description
The following data types do not support for profiling: blob, clob, nclob, lob, img, binary, bfile, xmltype