# Manage Connectors

Manage connectors in a database application to ensure smooth data flow, security, and stable performance. Monitor and maintain connectors to prevent data bottlenecks, reduce delays, and keep the system efficient under varying loads.

## Post-Setup Display and Actions

The Connectors page contains all the configured connectors, including connected and saved ones. The grid view in the Connectors page improves the search experience with filter, sort, and search options based on connector attribute details.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdC4RTyHIzX2GII09Oc1SY0dBBEDjjAuB5Ef16mHe0bZI0I_uUZg6hDJAAZf8GzFbY6eMM2RDqOeAQXS8zPrADAXoVRuzPQ97FOwLP4dxtjPauYm2lPnQNu0JAkXF5wy2CFAz_13Q?key=kU5fqtI4eAzquyCyuBsp-g" alt=""><figcaption></figcaption></figure>

### Connectors Health

The Connector's health in the application displays a clear indicator of the connection status of a connector. Monitor connector health to ensure the smooth functioning of data pipelines and workflows.

The Connectors health column displays a green icon when the connection is active and a red icon when the connection is inactive. If the connection is saved without validation, the status will display as a Grey icon. This allows users to quickly and easily identify any issues with their connectors. The Connectors health column can be accessed from Administration > Connectors.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcvSgFWvFxFU6s_9E5amZAgAWAjXsyrk0myHup--hPy6JEvIX5SS7q9_7ADIDmbTxjKVRQ-__mo-5YDsoNaW2ZcMuKRmi6oL3ltRtdk2srwFc8Q3JsDxwrOn_BzomSa5Jv2tKlfaQ?key=kU5fqtI4eAzquyCyuBsp-g" alt=""><figcaption></figcaption></figure>

To view the connector health, select the desired connector and click next to the status button under connector health. A pop-up displays the connector's health.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXelECGciR6w47BudSN2K7H-B4ylHYkhuOemK50aOXEPswPIXp0AwpNG9Ox1_-7m2kcJtcgeReDWm7aEllhwpHNzfjJvg4yInaeAJoWNm8WzBQs2BpjQNjeqpv8TN9JFm1nznXoOig?key=kU5fqtI4eAzquyCyuBsp-g" alt=""><figcaption></figcaption></figure>

* Health: The status of the connector validation.
* Health Check Date: The date and time of the connector validation.
* Details: The details of the connector validation, such as the errors that were found.
* Mode: The mode of the connector validation, such as Auto and Manual.

### Connectors Summary

The Connector Summary Page provides a centralized view of a connector, displaying key details, governance roles, metadata crawl and profiling information, job execution statistics, recent activities, scheduled jobs, and associated workflows. It enables efficient monitoring, management, and analysis of connector performance and data quality.

To view the connector summary, click the connector name from the list of configured connectors available on the Connector page. Once opened, five tabs are displayed: **Overview**, **Connector Metrics**, **Crawling**, **Profiling** (if applicable), and **Lineage** (if applicable). Each tab presents specific insights into connector configuration and activity.

* Displays connector description, authentication type, credential manager, environment, and governance roles (Data Steward, Data Owner, Data Custodian, Integration Admin, Security Admin).
* Shows crawl details: last crawl status, job reference, duration, and objects (new, updated, deleted).
* Shows profiling details: coverage %, last profile status, job reference, and top profiled tables (table name, row count, null %, distinct %) with pagination.
* Displays recent job activity with job ID, type, triggered by, status, duration, and error message; supports pagination.
* Shows all scheduled jobs with type, frequency, scheduled run time, and associated workflows.

<figure><img src="https://content.gitbook.com/content/ztcvwwOJCeaE1n6oHp4C/blobs/zzZQV5FIKQEkiiPyWtui/unknown.png" alt=""><figcaption></figcaption></figure>

### View Connectors Details

Users can view the required connector’s database details by clicking the View icon. The Looker connector is taken here as an example. All its database counts details, such as the total number of Domains, Reports, Report Columns, and Codes, are displayed.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfliBS5NRMF6paGixy2Ir8nBokC6dMO08Os0HSeoXPvOIiue21_QhjmLTWDOlYxtzVq46IzcHc75VftgzjrrW3bgGXGk6THZ2s4yxqYFXy55BEqTvo58rp4urep-vLWMk_4orzeSw?key=kU5fqtI4eAzquyCyuBsp-g" alt=""><figcaption></figcaption></figure>

### Connectors Action Menu (nine dots)

#### **Edit connector**

**To edit a connector,**

* Go to the Administration > Connectors page.&#x20;
* Select a connection and click the Nine Dots button.
* Select the **Edit Connector** option to update the existing data source.<br>

  <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfj5KBx8Bm2dbVc6FV7NcKZ1xaBzi2FaVj7L6uWtQ0McYjCvNJpg-VZtDCcYVxj9zX0y1xf3234rqbDPL4WXI-wCcEeVYW1Nywio0hHOAlbtyArwAlpHCrgxmXCS1U4Y0T6sLuk?key=kU5fqtI4eAzquyCyuBsp-g" alt=""><figcaption></figcaption></figure>
* Update the details, then save and validate the connection again.&#x20;

#### **Validate Connector**

Users can select the required connection and click on the Validate Connector option from the Nine Dots icon to validate it.&#x20;

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfJboRN6rKH3f4KwyiBr1LXVBJIx25ERLK3JFnziHU8LOeEuhI0U7NNH3l4nyTv1hkWRAe0i4hR55c6KeJR7ia2kpGEm9mat_-j6djKXOFs5tU02CWmamd7ldDSoz-J3w7IN3UEmQ?key=kU5fqtI4eAzquyCyuBsp-g" alt=""><figcaption></figcaption></figure>

#### **Settings**

The Settings option allows users to update the settings for the chosen connector.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXex1vVoErKdXnnkoy7eI34nDweOZx9hikTtMsb69S1kISzXamyjpqWjWpAVMVc-p7q1NJ2WCHG9HSopmQAe1iAAH2iXtV4DiRRYwCqFqrZT16ob2Yz-QEb1sJt2PRqv6_oywqcn?key=kU5fqtI4eAzquyCyuBsp-g" alt=""><figcaption></figcaption></figure>

#### **Build Lineage**

The crawler supports crawling views, procedures, and source codes. Once crawled, lineage for the respective source can be built.

Source code parsing algorithms are used to parse various types of source code to build lineage and relationships automatically. Lineage can currently be built from the following:

* SQL query logs - When a query is executed on the database, the crawler can capture and parse the query to identify the source and destination.
* Source Code Parsing - PL/SQL (Oracle), T-SQL (SQL Server), and Teradata SQL can be parsed to build lineage.
* Reporting / Visualization Tools - Lineage can be built from tools such as Tableau, QlikView, Qlik Sense, SAP Business Objects, Crystal Reports, and Power BI<br>

  <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXeplE65wiXZAAxrqkR1cJtHkuL2-I52hyjnZgK8Y9W2Limj1jaid4skX2Jo9cDJ-ZKFYEQpksgkHF2L8k6a0Wl2BMtk09lq41Gx-aADYSXLdE1huni1n26sa1old7BTf1pncTyJJg?key=kU5fqtI4eAzquyCyuBsp-g" alt=""><figcaption></figcaption></figure>

#### **Delete Connector**

Delete a database schema based on what the user intends to remove. Users can delete any connection type, including RDBMS, Reports, or Files.

**To delete a database connection,**&#x20;

1. Click on the Nine dots button and select the Delete Connector button. Choose database or schema (if schema, select the applicable schema).<br>

   <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXccKBe7Krai6fwxC3lp_6EL9ggS8Nw5lQrkaMndRUpZL5enByWrclh5k-8xi8CcNWlVNqlklrfw6NrxOQSkDVClWm1IRlRRb50bCK8AFE1CYu0QV4Yjy4s8k32ohfM9euiXw9zB?key=kU5fqtI4eAzquyCyuBsp-g" alt=""><figcaption></figcaption></figure>
2. Enter the name of the Connector or Schema.
3. Select the schema(s) and click the Delete button to delete.<br>

   <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfrrqM0mMradHkdZOxOIUB4MaZzW3zLRKolAtHYbu5js2Y0zNTIRv46Tm6Fy3cbkn9jhRluEom6yBNMpNvmpWCBVW-VBaKgj1jbM-dIBT1tdNMdU02ffdLuo6uoIUDeIloiQj6-3g?key=kU5fqtI4eAzquyCyuBsp-g" alt=""><figcaption></figcaption></figure>
4. When the deletion of the data source is successful, an alert message will appear that the deleted job has been submitted.

{% hint style="info" %}
Once the Job is successful, the respective datasource will be removed from the application.
{% endhint %}

#### **Rename Connector**

The Rename Connector feature allows changing the name of an existing connector. This is useful when aligning connector names with updated naming conventions.

**To rename a connector:**

* Click on the 9-Dots menu.
* Select the Rename Connector option.<br>

  <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfXNcesqEB0yj1XHf28XxyNUhHww5gj2jORanatEazTIeTlz-vNzZLXgG8lsDwgKgXcv9-YUeX0ybUomyUoi7JHltuxoFUetDZBmUplfvdcMKWfSrh1o7v706EaIGCuKb7ShpDjPw?key=kU5fqtI4eAzquyCyuBsp-g" alt=""><figcaption></figcaption></figure>
* In the pop-up, enter the Current Name and the New Name.
* Click **Update** to proceed.<br>

  <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXeJYo3a3ewffuMpFUECW0jE7RD5U-MkF9W7MR4ZisqIumQkMSHXrAcqLwEdmjnHXh97UW2iFUD2NLGkS9b5qhpPi9GEycNWGjD6itCSvbW1mRwyjA2GpxcPLi9Q1dAwMEquJ4Hv?key=kU5fqtI4eAzquyCyuBsp-g" alt=""><figcaption></figcaption></figure>

Once submitted, an alert message will confirm that the rename job has been initiated. A background job will handle the update, and it may take some time for the new name to reflect throughout the application.

{% hint style="info" %}
After the job is successful, the old connector will be removed from the application and replaced with the renamed one. However, previously curated descriptions and collaboration notes will not be automatically updated with the new name.
{% endhint %}

***

Copyright © 2025, OvalEdge LLC, Peachtree Corners GA USA