AWS QuickSight Connector

Functionality

Support Data Objects

Crawler 

• Analysis
• Dashboards
• Sheets

Lineage

• Analysis
• Dashboards
• Lineage Sources: RDBMS schemas

S.No

Item List

Description

1

SDK 

SDK for JAVA 1.12.661 

Connection Validation

The service account must have Read permission.

Connector Type

The selected connection type, QuickSight, is displayed by default.

If required, the drop-down menu allows you to change the connector type; based on the selection of the connection type, the fields associated with the selected connection type are displayed.

Authentication*

The QuickSight connector allows you to crawl the Dashboards and Sheets using IAM User Authentication and Role-Based Authentication.

Credential Manager*

Select the option from the drop-down menu to indicate where you want to save your credentials:

OE Credential Manager: QuickSight’s on-premise connection is configured with the basic Username and Password of the service account in real-time when OvalEdge establishes a connection to the QuickSight database. If the OE Credential Manager option is selected, users need to add the credentials manually.

HashiCorp: The credentials are stored in the HashiCorp database server and fetched from HashiCorp to OvalEdge.

AWS Secrets Manager: The credentials are stored in the AWS Secrets Manager database server; OvalEdge fetches of the credentials from the AWS Secrets Manager.

Azure Key Vault: Azure Key Vault allows for secure storage and strict access mechanisms of sensitive information such as tokens, passwords, certificates, API keys, and other confidential data.

For more information on Azure Key Vault, refer to Azure Key Vault

For more information on Credential Manager, refer to Credential Manager

Credential Manager ConnId*

Enter Credential Manager ConnId.

The connection is validated based on the specific connection ID of the credential manager (Azure Key Vault, HashiCorp, and AWS Secrets Manager).

License Add-Ons

All of the connectors will have a Base Connector License by default, which allows you to crawl and profile to obtain metadata and statistical information from a data source. 

OvalEdge supports various License Add-Ons based on the connector’s functionality requirements:

• Select the Auto Lineage Add-On license that enables the automatic construction of the Lineage of data objects for a connector with the Lineage feature.

Connector Name*

Select a Connection name for QuickSight. The name you specify is a reference name that makes it easy to identify QuickSight in OvalEdge.

Example: Customers

Connector Environment

The environment drop-down menu allows you to select the environment configured for the connector from the drop-down list (for example, PROD or STG).

The purpose of the environment field is to help users understand that the new connector is established in an environment that is available at the Production, STG, and QA levels.

Note: The steps to set up environment variables are explained in the prerequisite section above.

Role-Based Authentication-Specific Parameters

Cross Account Role ARN

A Cross Account Role ARN refers to an IAM role's Amazon Resource Name (ARN) that allows an AWS account to access resources (like QuickSight) in another AWS account. 

Enter the Cross Account Role ARN Name.

Example: CrossAccountquicksight

Database Region

The Region refers to the specific geographical location where your Amazon QuickSight resides. Specify the region to ensure the connector interacts with the correct QuickSight location.

Example: us-east-1

Filter by tags

Specify tags as filters to limit the scope of objects the connector will interact with.

Example: Dashboards

IAM User Authentication-Specific Parameters

Access key*

Enter a unique identifier that is part of the credential pair, like a username.

Secret key*

A secret, like a password, is used to sign requests to AWS.

Database Region

The Region refers to the specific geographical location where your Amazon QuickSight resides. Specify the region to ensure the connector interacts with the correct  QuickSight location.

Example: us-east-1

Filter by tags

Specify tags as filters to limit the scope of objects the connector will interact with.

Example: Dashboards

Account ID*

The Account ID refers to the unique identifier assigned to an AWS (Amazon Web Services) account. When setting up a connection to an Amazon QuickSight, the Account ID is used to identify the specific AWS account that owns the QuickSight you want to connect to.

Enter the 12-digit Account ID number that is unique to each AWS account.

Default Governance Roles*

The admin will select a specific user or team from the governance roles (Steward, Custodian, Owner, Governance Role 4, Governance Role 5, Governance Role 6) assigned to the data asset. 

The dropdown list displays all the configurable roles (single user or team) according to the configurations made in OvalEdge.

Admin Roles*

Select the required admin roles for this connector.

• To add Integration Admin Roles, search for or select one or more roles from the Integration Admin options list and then click the Apply button.
  The Integration Admin is responsible for:
  • Configuring crawling and profiling settings for the connector
  • Deleting connectors, schemas, and/or data objects.
• To add Security and Governance Admin roles, search for or select one or more roles from the Security and Governance Admin options list and then click on the Apply button.
  The security and Governance Admin is responsible for:
  • Configuring role permissions for the connector and its associated data objects.
  • Adding admins to set permissions for roles on the connector and its associated data objects.
  • Updating governance roles.
  • Creating custom fields.
  • Developing Service Request templates for the connector.
  • Creating Approval workflows for the templates.

No of Archive Objects*

The number of archive objects indicates the number of recent metadata modifications made to a dataset at a remote/source location. The archive objects feature is deactivated by default. However, users may enable it by clicking the Archive toggle button and specifying the number of objects they wish to archive. 

Select Bridge*

With the OvalEdge Bridge component, any cloud-hosted server can connect with any on-premise or public cloud data source without modifying firewall rules. A bridge provides real-time control that makes it easy to manage data movement between any source and destination. 

For more information, refer to Bridge Overview.

No.

Error Message(s)

Description

1

error_validate_connection

This alert message is displayed when the information entered in the required fields is incorrect.

Crawler

The crawler connects to a data source to access metadata stored in the data source. When OvalEdge connects to a data source, it collects and catalogs all the data elements (i.e., metadata) and stores them in the OvalEdge database. The Integration Admin can select several options to crawl the data source system. The crawler setting consists of Crawler Options and Crawler Rules.

Access Instruction

Access instruction refers to instructions or related information about a data source. Users can share this information in various forms, such as links, images, or videos, offering essential details about a specific connector. When the Integration Admin adds instructions for a particular connection in the Access Instruction settings page, the access instruction is displayed on the Data Catalog > Data Objects summary page after crawling is completed.

Business Glossary Settings

The Business Glossary setting provides flexibility and control over how users view and manage term associations within the context of a business glossary at the connector level. 

Lineage

The lineage settings allow you to configure multiple dialects (by selecting Source Server Type for lineage) and connection priority lists to pick the tables to build lineage.

Others

To receive notifications for changes in object metadata, configure the 'Send Metadata Changes Notifications' settings. Depending on the selections, Owners, Stewards, Custodians, and additional Governance Roles can receive notifications per the configuration.
The OvalEdge Browser Extension leverages the Context URL to associate OvalEdge with specific URL addresses, which enables the browser to recognize the site and fetch metadata results from the OvalEdge catalog even when the Browser Extension is used outside the OvalEdge application.