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	varchar2(30)	Abbreviation	☑	Abbreviation.
CLIENT_ID	varchar2(240)	Client ID	☐	OAuth client ID.
COMMERCIAL_NAME_SHORT_ALTERNATVIES	varchar2(240)	Alternative Short Commercial Names	☐	Alternative short commercial names.
COMMERCIAL_NAME_SHORT	varchar2(240)	Commercial Name Short	☐	Commercial name (short).
COMMERCIAL_NAME	varchar2(240)	Commercial Name	☑	Commercial name.
COMMUNITY_EDITION	char	Is Community Edition	☑	Is application software offered for free?
DATA_CONTAINER_ALIAS	varchar2(4000)	Data Container Alias	☐	Data container alias.
DATA_CONTAINER_ID	varchar2(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	varchar2(16000)	Description	☑	Description.
DISPLAY_NAME	varchar2(240)	Display Name	☑	Display name.
DOCUMENTATION_URL	varchar2(4000)	Documentation (URL)	☐	Documentation URL.
DOCUMENTATION	varchar2(32767)	Documentation	☐	Documentation.
DOWNLOAD_IMPLEMENTATION_URL	varchar2(4000)	Download Implementation URL	☐	Download URL for implementation.
ESTATE_PROPERTY_NAME	varchar2(240)	Estate Property Name	☐	Invantive Estate property name.
FORUMS_TAG	varchar2(240)	Forums Tag	☐	Invantive Forums tags.
FUNCTIONAL_DOCUMENTATION_URL	varchar2(4000)		☐	Functional documentation URL.
FUNCTIONAL_SUPPORT_DISCORD_COMMUNITY	varchar2(60)		☐	Functional support discourse community.
FUNCTIONAL_SUPPORT_EMAIL_ADDRESS	varchar2(60)		☐	Functional support email address.
FUNCTIONAL_SUPPORT_PHONE_NUMBER	varchar2(60)		☐	Functional support phone number.
FUNCTIONAL_SUPPORT_URL	varchar2(240)		☐	Functional support URL.
HANDLING_ORDER	int32	Handling Order	☐	Handling order.
ICON_RESOURCE_NAME_16	varchar2(240)	Icon Resource Name (16x16)	☐	Name of file with 16x16 icon.
INFLUENCES_MAXIMUM_NUMBER_JOINS	char	Influences Maximum Number of Joins	☑	Influences maximum number of joins?
IS_ALLOWED	boolean	Is Allowed?	☐	Is allowed?
IS_CATALOG_USED_IN_FULL_QUALIFIED_NAME	char	Is Catalog Used in Full Qualified Name	☑	Whether the catalog name is used in constructing the full qualified name.
IS_DEFAULT_FLAG	char	Is Default?	☑	Is the default connector?
IS_ESSENTIAL	boolean	Is Essential?	☐	Is essential?
IS_SCHEMA_USED_IN_FULL_QUALIFIED_NAME	char	Is Schema Used in Full Qualified Name	☑	Whether the schema name is used in constructing the full qualified name.
IS_SERVICE_PROVIDER_FLAG	char	Is Service Provider?	☑	Is the connector a service connector?
LICENSING_FEATURE	varchar2(240)	Licensing Feature	☐	Licensing feature.
MAIN_CATEGORY	varchar2(240)	Main Category	☑	Main category.
MARKETPLACE_URL	varchar2(4000)		☐	URL of the marketplace containing integrations and add-ons.
MAXIMUM_NUMBER_USABLE_PARTITIONS	int32	Maximum Number of Usable Partitions		Maximum number of usable partitions.
NAME	varchar2(240)	Name	☑	Name of the connector.
PARTITION_CODE_COLUMN_NAME	varchar2(240)	Partition Code Column Name	☐	Name of the partition code column.
PARTITION_INFO_ALL_PARTITIONS_SELECTED	char	Partition Has Selected All Partitions	☑	Whether the connector has selected all partitions.
PARTITION_INFO_LABEL_SINGULAR	varchar2(240)	Partition Label Singular	☐	Partition label in singular form.
PARTITION_INFO_PREFERRED_UI_LABEL_PLURAL	varchar2(240)	Partition Preferred UI Label Plural	☐	Partition preferred UI label in plural form.
PARTITION_INFO_PREFERRED_UI_LABEL_SELECTED_ELEMENTS	varchar2(240)	Partition Preferred UI Label Selected Elements	☐	Partition preferred UI label for selected elements.
PARTITION_INFO_PREFERRED_UI_LABEL_SELECTOR	varchar2(240)	Partition Preferred UI Label Selector	☐	Partition preferred UI label for selector.
PARTITION_INFO_PREFERRED_UI_LABEL_SINGULAR	varchar2(240)	Partition Preferred UI Label Singular	☐	Partition preferred UI label in singular form.
PARTITION_INFO_SUPPORTS_MULTIPLE_SELECTED_PARTITIONS	char	Supports Multiple Selected Partitions	☑	Whether the connector supports multiple selected partitions.
PARTITION_INFO_SUPPORTS_NO_SELECTED_PARTITIONS	char	Partition Supports No Selected Partitions	☑	Whether the connector supports no selected partitions.
PARTITION_INFO_SUPPORTS_PARTITIONS	char	Supports Partitions	☑	Whether the connector supports partitions.
PARTITION_LABEL_SINGULAR	varchar2(240)	Partition Label Singular	☐	Partition label in singular form.
PARTITIONS_INFO_LABEL_PLURAL	varchar2(240)	Partition Label Plural	☐	Partition label in plural form.
PARTITIONS_INFO_MASTER_ROLLUP_LABEL	varchar2(240)	Partition Rollup Label Singular	☐	Partition master rollup label in singular form.
PARTITIONS_INFO_ROLLUP_LABEL	varchar2(240)	Partition Rollup Label Singular	☐	Partition rollup label in singular form.
PRODUCT_PHASE	varchar2(240)	Product Phase	☐	Product phase.
PRODUCTION_USE_ALLOWED	char	Production Use Allowed	☑	Is production use allowed?
PROVIDER_UID	guid	Provider UID	☑	Unique ID of the provider.
PUBLIC_DATA	char	Is Public Data?	☑	Is the data offered publicly?
REDIRECT_URL	varchar2(4000)		☐	OAuth redirect URL.
SHORT_NAME_RESOURCE	varchar2(240)	Short Name for Resources	☑	Short name for use in translation resources.
SHORT_NAME	varchar2(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	varchar2(30)	SQL Prefix Parameter	☐	SQL parameter prefix.
STRING_COMPARISON_IS_CASE_SENSITIVE	char	String Comparison is Case-Sensitive	☑	Whether the connector matches string case-sensitive.
SUPPORTS_COLUMN_FILTERING	char	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	char	Supports Native Scalar Requests	☑	Whether the platform supports native scalar requests.
SUPPORTS_NATIVE_SQL	char	Supports Native SQL	☑	Whether the platform supports native SQL.
SUPPORTS_ORDERING	char	Supports Ordering	☑	Whether the connector supports ordering.
SUPPORTS_SIMPLE_FILTER_DELETE	char	Supports Simple Filter Delete	☑	Whether the connector supports delete using simple filters.
SUPPORTS_SIMPLE_FILTER_UPDATE	char	Supports Simple Filter Update	☑	Whether the connector supports update using simple filters.
TAGS	varchar2(240)	Tags	☐	Comma-separated list of tags.
TECHNICAL_DOCUMENTATION_URL	varchar2(4000)	Technical Documentation (URL)	☐	Technical documentation URL.
TECHNICAL_SUPPORT_DISCORD_COMMUNITY	varchar2(60)		☐	Technical support discourse community.
TECHNICAL_SUPPORT_EMAIL_ADDRESS	varchar2(60)		☐	Technical support email address.
TECHNICAL_SUPPORT_PHONE_NUMBER	varchar2(60)		☐	Technical support phone number.
TECHNICAL_SUPPORT_URL	varchar2(240)		☐	Technical support URL.

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.

Please enable JavaScript to view this site.

Data Dictionary Data Model

SYSTEMPROVIDERS: Data Dictionary Providers

View Columns

Important Safety and Usage Information