Connectivity
\[How the connection is established with Exasol]
| JDBC | ### Connector Features | Feature | Availability | | -------------------------------------------- | :----------: | | Crawling | ✅ | | Delta Crawling | ❌ | | Profiling | ✅ | | Query Sheet | ✅ | | Data Preview | ✅ | | Auto Lineage | ✅ | | Manual Lineage | ✅ | | Secure Authentication via Credential Manager | ✅ | | Data Quality | ✅ | | DAM (Data Access Management) | ❌ | | Bridge | ✅ | ### Metadata Mapping The following objects are crawled from the Exasol and mapped to the corresponding UI assets. | Exasol Object | Exasol Attribute | OvalEdge Attribute | OvalEdge Category | OvalEdge Type | | ------------- | ------------------- | ------------------ | ----------------- | ------------------ | | Table | Table Name | Table | Tables | Table | | Table | Table Type | Type | Tables | Table | | Table | Table Comments | Source Description | Descriptions | Source Description | | Columns | Column Name | Column | Table Columns | Columns | | Columns | Data Type | Column Type | Table Columns | Columns | | Columns | Description | Source Description | Table Columns | Columns | | Columns | Ordinal Position | Column Position | Table Columns | Columns | | Columns | Length | Data Type Size | Table Columns | Columns | | Views | View Name | View | Tables | Views | | Views | Text | View Query | Views | Views | | Procedures | Routine\_Name | Name | Procedures | Procedures | | Procedures | Description | Source Description | Descriptions | Procedures | | Procedures | Routine\_Definition | Procedure | Procedures | Procedures | | Functions | Routine\_Name | Name | Functions | Functions | | Functions | Routine\_Definition | Function | Functions | Functions | | Functions | Description | Source Description | Descriptions | Functions | | Triggers | Trigger Name | Name | Triggers | Triggers | | Triggers | Trigger Definition | Trigger Data | Triggers | Triggers | | Triggers | Trigger Type | Type | Triggers | Triggers | ## Set up a Connection ### Prerequisites The prerequisites to establish a connection: ### **Whitelisting Ports** Whitelist the inbound port 8563 to allow OvalEdge to connect to the Exasol Server database. {% hint style="warning" %} Exasol uses port 8563 by default. When a different port is configured, specify the updated port number during connection setup, whitelist the port, and establish proper communication between the system and the Exasol Server. {% endhint %} ### Service Account User Permissions {% hint style="warning" %} Use a dedicated service account to establish the connection to the data source, configured with the following minimum set of permissions. {% endhint %} {% hint style="info" %} **👨💻 Who can provide these permissions?** The Exasol administrator grants these permissions, as standard accounts may not have the required access to assign them independently. {% endhint %} | Objects | System Tables | Access Permission | | ------- | ----------------------------------------------------------------------------- | ----------------- | | Schema |Select the desired credentials manager from the drop-down list. Relevant parameters will be displayed based on the selection.
Supported Credential Managers:
Enter a unique name for the Exasol connection
(Example: "Exasol\_Prod").
| | Connector Environment | Select the environment (Example: PROD, STG) configured for the connector. | | Connector Description | Enter the description related to the connector. | | Server\* | Enter the IP address of the server where Exasol is hosted. | | Port\* | Exasol uses port 8563 by default. The port number can be modified as needed. | | Database\* |The ‘Database’ field defines the default schema that the connector uses to connect to the Exasol server.
Example: If the target database is sales\_db, enter sales\_db to connect directly instead of the default schema.
| | Driver\* | By default, Exasol uses ‘com.exasol.jdbc.jdbc41.EXADriver.’ This field is not editable. | | Username\* | Enter the Username for the Exasol server. | | Password\* | Enter the Password associated with the Exasol Username. | | Connection String |Configure the connection string for the Exasol server:
Replace placeholders with actual server details:
Authentication Plugins:
jdbc:exa:{server}:8563;schema={sid}
This is the default JDBC connection string used for connecting to Exasol. The schema parameter specifies the default schema to use after the connection is established.
| | Plugin Server | Enter the server name when running as a plugin server. | | Plugin Port | Enter the port number on which the plugin is running. | **Default Governance Roles** | Default Governance Roles\* | Select the appropriate users or teams for each governance role from the drop-down 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 & Governance Admin. All users configured in OvalEdge Security are available for selection. | | ------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | **No of Archive Objects** | No Of Archive Objects\* |This shows the number of recent metadata changes to a dataset at the source. By default, it is off. To enable it, toggle the Archive button and specify the number of objects to archive.
Example: Setting it to 4 retrieves the last four changes, displayed in the 'Version' column of the 'Metadata Changes' module.
| | ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | **Bridge** | Select Bridge\* |If applicable, select the bridge from the drop-down list.
The drop-down list displays all active bridges configured in OvalEdge. These bridges enable communication between data sources and OvalEdge without altering firewall rules.
| | --------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 2. After entering all connection details, the following actions can be performed: * Click **Validate** to verify the connection. * Click **Save** to store the connection for future use. * Click **Save & Configure** to apply additional settings before saving. 3. The saved connection will appear on the Connectors home page. ## Manage Connector Operations ### Crawl/Profile {% hint style="warning" %} To perform crawl and profile operations, users must be assigned the Integration Admin role. {% endhint %} The **Crawl/Profile** button allows users to select one or more schemas for crawling and profiling. 1. Navigate to the Connectors page and click **Crawl/Profile**. 2. Select the schemas to crawl. 3. The **Crawl** option is selected by default. Click the **Crawl & Profile** radio button to enable both operations. 4. Click **Run** to collect metadata from the connected source and load it into the **Data Catalog**. 5. After a successful crawl, the information appears in the **Data Catalog > Databases** tab. The **Schedule** checkbox allows automated crawling and profiling at defined intervals, from a minute to a year. 1. Click the **Schedule** checkbox to enable the **Select Period** drop-down. 2. Select a time period for the operation from the drop-down menu. 3. Click **Schedule** to initiate metadata collection from the connected source. The system will automatically execute the selected operation (**Crawl** or **Crawl & Profile**) at the scheduled time. ### Other Operations The Connectors page in OvalEdge provides a centralized view of all configured connectors, including their health status. **Managing connectors includes:** * **Connectors Health**: Displays the current status of each connector, with a green icon for active connections and a red icon for inactive connections, helping monitor connectivity to data sources. * **Viewing**: Click the **Eye** icon next to the connector name to view connector details, including Tables, Views, and Columns. **Nine Dots Menu Options:** To view, edit, validate, configure, or delete connectors, click on the **Nine Dots** menu. * **Edit Connector**: Update and revalidate the data source. * **Validate Connector**: Check the integrity of the connection. * **Settings**: Modify connector settings. * **Crawler**: Configure data extraction. * **Profiler**: Customize data profiling rules and methods. * **Access Instructions**: Add notes on how data can be accessed. * **Business Glossary Settings**: Manage term associations at the connector level. * **Others**: Configure notification recipients for metadata changes. * **Build Lineage**: Automatically build data lineage using source code parsing. * **Delete Connector**: Remove a connector with confirmation. ### Connectivity Troubleshooting If incorrect parameters are entered, error messages may appear. Ensure all inputs are accurate to resolve these issues. If issues persist, contact the assigned support team.| S.No. | Error Message(s) | Error Description & Resolution |
|---|---|---|
| 1 | Error while validating EXASOL connection | Root cause: Connect timed out | Error Description: The EXASOL connection validation failed because the system could not establish a connection within the defined timeout period. Resolution: Verify the EXASOL server’s network connectivity, firewall settings, and port configuration, then retry the connection to ensure proper connectivity. |