Please enable JavaScript to view this site.

Data Dictionary Forums

Data Dictionary Data Model

Navigation: Catalog: DataDictionary > Schemas > Schema: Invantive > Tables

SYSTEMPROVIDERS: Data Dictionary Providers

All registered and licensed providers available in Invantive SQL.

Catalog: DataDictionary

Schema: Invantive

Alias: pvr

Label: Providers

This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.

View Columns

The columns of the view SYSTEMPROVIDERS are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

ABBREVIATION

string(30)

Abbreviation

☑

Abbreviation.

COMMERCIAL_NAME

string(240)

Commercial Name

☑

Commercial name.

COMMUNITY_EDITION

boolean

Is Community Edition

☑

Is application software offered for free?

DATA_CONTAINER_ALIAS

string(4000)

Data Container Alias

☐

Data container alias.

DATA_CONTAINER_ID

string(4000)

Data Container ID

☐

Data container ID.

DEFAULT_CONNECTION_ID

guid

Default Connection ID

☑

Default GUID for first discovered connection of this connector.

DEFAULT_NUMBER_PARALLEL_REQUESTS

int32

Default Number of Parallel Requests

 

Default number of parallel requests.

DEFAULT_SLOTBASED_RATE_LIMIT_LENGTH_MS

int64

Default Slot-based Rate Limit Length (ms)

☑

Default length in ms of a slot-based rate limit.

DEFAULT_SLOTBASED_RATE_LIMIT_SLOTS

int32

Default Slot-based Rate Limit Slots

☐

Default number of slots of a slot-based rate limit.

DESCRIPTION

string(16000)

Description

☑

Description.

DISPLAY_NAME

string(240)

Display Name

☑

Display name.

DOCUMENTATION_URL

string(4000)

Documentation (URL)

☐

Documentation URL.

DOCUMENTATION

string(32767)

Documentation

☐

Documentation.

DOWNLOAD_IMPLEMENTATION_URL

string(4000)

Download Implementation URL

☐

Download URL for implementation.

ICON_RESOURCE_NAME_16

string(240)

Icon Resource Name (16x16)

☐

Name of file with 16x16 icon.

INFLUENCES_MAXIMUM_NUMBER_JOINS

boolean

Influences Maximum Number of Joins

☑

Influences maximum number of joins?

IS_CATALOG_USED_IN_FULL_QUALIFIED_NAME

boolean

Is Catalog Used in Full Qualified Name

☑

Whether the catalog name is used in constructing the full qualified name.

IS_DEFAULT_FLAG

boolean

Is Default?

☑

Is the default connector?

IS_SCHEMA_USED_IN_FULL_QUALIFIED_NAME

boolean

Is Schema Used in Full Qualified Name

☑

Whether the schema name is used in constructing the full qualified name.

IS_SERVICE_PROVIDER_FLAG

boolean

Is Service Provider?

☑

Is the connector a service connector?

MAIN_CATEGORY

string(240)

Main Category

☑

Main category.

MAXIMUM_NUMBER_USABLE_PARTITIONS

int32

Maximum Number of Usable Partitions

 

Maximum number of usable partitions.

NAME

string(240)

Name

☑

Name of the connector.

PARTITION_CODE_COLUMN_NAME

string(240)

Partition Code Column Name

☐

Name of the partition code column.

PARTITION_INFO_ALL_PARTITIONS_SELECTED

boolean

Partition Has Selected All Partitions

☑

Whether the connector has selected all partitions.

PARTITION_INFO_LABEL_SINGULAR

string(240)

Partition Label Singular

☐

Partition label in singular form.

PARTITION_INFO_PREFERRED_UI_LABEL_PLURAL

string(240)

Partition Preferred UI Label Plural

☐

Partition preferred UI label in plural form.

PARTITION_INFO_PREFERRED_UI_LABEL_SELECTED_ELEMENTS

string(240)

Partition Preferred UI Label Selected Elements

☐

Partition preferred UI label for selected elements.

PARTITION_INFO_PREFERRED_UI_LABEL_SELECTOR

string(240)

Partition Preferred UI Label Selector

☐

Partition preferred UI label for selector.

PARTITION_INFO_PREFERRED_UI_LABEL_SINGULAR

string(240)

Partition Preferred UI Label Singular

☐

Partition preferred UI label in singular form.

PARTITION_INFO_SUPPORTS_MULTIPLE_SELECTED_PARTITIONS

boolean

Supports Multiple Selected Partitions

☑

Whether the connector supports multiple selected partitions.

PARTITION_INFO_SUPPORTS_NO_SELECTED_PARTITIONS

boolean

Partition Supports No Selected Partitions

☑

Whether the connector supports no selected partitions.

PARTITION_INFO_SUPPORTS_PARTITIONS

boolean

Supports Partitions

☑

Whether the connector supports partitions.

PARTITION_LABEL_SINGULAR

string(240)

Partition Label Singular

☐

Partition label in singular form.

PARTITIONS_INFO_LABEL_PLURAL

string(240)

Partition Label Plural

☐

Partition label in plural form.

PARTITIONS_INFO_MASTER_ROLLUP_LABEL

string(240)

Partition Rollup Label Singular

☐

Partition master rollup label in singular form.

PARTITIONS_INFO_ROLLUP_LABEL

string(240)

Partition Rollup Label Singular

☐

Partition rollup label in singular form.

PRODUCTION_USE_ALLOWED

boolean

Production Use Allowed

☑

Is production use allowed?

PROVIDER_UID

guid

Provider UID

☑

Unique ID of the provider.

PUBLIC_DATA

boolean

Is Public Data?

☑

Is the data offered publicly?

SHORT_NAME_RESOURCE

string(240)

Short Name for Resources

☑

Short name for use in translation resources.

SHORT_NAME

string(240)

Short Name

☑

Short name.

SLOTBASED_RATE_LIMIT_LENGTH_MS

int64

Slot-based Rate Limit Length (ms)

☑

Length in ms of a slot-based rate limit.

SLOTBASED_RATE_LIMIT_SLOTS

int32

Slot-based Rate Limit Slots

☐

Number of slots of a slot-based rate limit, null means no limit.

SQL_PREFIX_PARAMETER

string(30)

SQL Prefix Parameter

☐

SQL parameter prefix.

STRING_COMPARISON_IS_CASE_SENSITIVE

boolean

String Comparison is Case-Sensitive

☑

Whether the connector matches string case-sensitive.

SUPPORTS_COLUMN_FILTERING

boolean

Supports Column Filtering

☑

Whether column filtering is supported; if true, the connector can filter the resulting columns itself based on a select statement.

SUPPORTS_NATIVE_SCALAR_REQUESTS

boolean

Supports Native Scalar Requests

☑

Whether the platform supports native scalar requests.

SUPPORTS_NATIVE_SQL

boolean

Supports Native SQL

☑

Whether the platform supports native SQL.

SUPPORTS_ORDERING

boolean

Supports Ordering

☑

Whether the connector supports ordering.

SUPPORTS_SIMPLE_FILTER_DELETE

boolean

Supports Simple Filter Delete

☑

Whether the connector supports delete using simple filters.

SUPPORTS_SIMPLE_FILTER_UPDATE

boolean

Supports Simple Filter Update

☑

Whether the connector supports update using simple filters.

TECHNICAL_DOCUMENTATION_URL

string(4000)

Technical Documentation (URL)

☐

Technical documentation URL.

 

18-10-2024 06:49 Version 24.0.345-PROD+4945

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.
  
Disclaimer