invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMPROVIDERS: Data Dictionary Providers

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Providers

All registered and licensed providers available in Invantive SQL.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMPROVIDERS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
ABBREVIATION varchar2(30) Abbreviation Abbreviation.
CLIENT_ID varchar2(240) Client ID OAuth client ID.
COMMERCIAL_NAME varchar2(240) Commercial Name Commercial name.
COMMERCIAL_NAME_SHORT varchar2(240) Commercial Name Short Commercial name (short).
COMMERCIAL_NAME_SHORT_ALTERNATVIES varchar2(240) Alternative Short Commercial Names Alternative short commercial names.
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 fetched only when named 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 varchar2(32767) Documentation Documentation.
DOCUMENTATION_URL varchar2(4000) Documentation (URL) Documentation URL.
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 documentation URL.
FUNCTIONAL_SUPPORT_DISCORD_COMMUNITY varchar2(60) Functional Support Discord Community Functional support discourse community.
FUNCTIONAL_SUPPORT_EMAIL_ADDRESS varchar2(60) Functional Support Email Address Functional support email address.
FUNCTIONAL_SUPPORT_PHONE_NUMBER varchar2(60) Functional Support Phone Number Functional support phone number.
FUNCTIONAL_SUPPORT_URL varchar2(240) Functional Support URL 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) Marketplace URL 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.
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.
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.
PRODUCTION_USE_ALLOWED char Production Use Allowed Is production use allowed?
PRODUCT_PHASE varchar2(240) Product Phase Product phase.
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) Redirect URL OAuth redirect URL.
SHORT_NAME varchar2(240) Short Name Short name.
SHORT_NAME_RESOURCE varchar2(240) Short Name for Resources Short name for use in translation resources.
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 text 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 Discord Community Technical support discourse community.
TECHNICAL_SUPPORT_EMAIL_ADDRESS varchar2(60) Technical Support Email Address Technical support email address.
TECHNICAL_SUPPORT_PHONE_NUMBER varchar2(60) Technical Support Phone Number Technical support phone number.
TECHNICAL_SUPPORT_URL varchar2(240) Technical Support URL Technical support URL.

Referenced By

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: