Connector Settings

The connector settings includes Query Policies and Data Access Permissions

Query Policy

The Query Policies are part of the connector settings for supported connectors in the Query Sheet. Specific roles can limit the usage of selected query types (UNION/SUM/AVG, etc.) on the Query Sheet to fetch data based on applied operations or functions.

To provide the restriction to use specific Query Types, the Integration admin needs to follow the following steps:

• Integration Admins should navigate to the connector page, select the desired connector, and click the 9 Dots menu to define the query policy.

• Select the Settings options and display the connectors Setting page.

• Click on the Query Policies, and the data grid with existing Policy details with Role, Query Type, Access Type, and Delete columns is displayed.

• To include new query policies, click on the +Add Query Policy button in the inline row with Role, Query Type, Access Type, and Cancel options displayed.

• Select the desired Role, Query Type, and Access Type from the respective dropdowns and click the Save Changes button.

• The Datagrid presents the selected Query Policy. For example, choosing the Role as "OE_ADMIN," Query Type as "JOIN," and Access Type as "DENY" limits OE_ADMIN privilege holders from utilizing the JOIN function on the Query Sheet page.

• In the Query Sheet, the JOIN function with the OE_ADMIN role triggers the error message "User does not have permission on this <TableName> to perform this Function: Join."

Data Access

Data Access Authorization

Data Access Authorization is part of the crawler-specific connector settings to verify the user's access to the query sheet and queries in the data catalog. Here, the system checks the credentials and permits that specific account holder to access the query sheet and queries in the data catalog.

OvalEdge follows OvalEdge Data Permissions

When selecting this option, the application utilizes a service account to establish the connection in the Data Catalog Data page, Data Catalog Code, and Query Sheet.

OvalEdge follows Remote System Permissions

To connect and fetch data from a remote source, enter the credentials on three pages: Data Catalog Code, Data Catalog Data, and Querysheet. The system caches these credentials, but they are cleared after seven days of inactivity, requiring you to re-enter them.

Customization via System Settings

1. querysheet.row.limit

   1. Navigate to the Administration > System Settings > Others, search for “Query” in the key column.

   2. Querysheet.row.limit Admins can set the maximum number of records (count of rows) to download from Query Sheet Results. The default value is set to 50,000. Admins can enter the desired value in the field provided in the System settings (others).

2. querysheet.columns.parameterization

   1. To create a param query, use #{ or ${ or @{ or ## or $$ Two special characters for the parameterized columns.