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:
-
Whitelisting Ports: Ensure the inbound port “1521” is whitelisted for OvalEdge to connect to the EBS Table database.
-
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
-
Service Account Permissions
Important: 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
Important: Connector Creator privileges are required for data source connection configuration.
- 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:
|
|
License Add Ons |
OvalEdge connectors have a default license add-on for data crawling and profiling.
|
|
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. |
- 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.
- 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 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
Note: 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 |
|