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 |
Abbreviation | Abbreviation. | ||
CLIENT_ |
varchar2 |
Client ID | OAuth client ID. | ||
COMMERCIAL_ |
varchar2 |
Commercial Name | Commercial name. | ||
COMMERCIAL_ |
varchar2 |
Commercial Name Short | Commercial name (short). | ||
COMMERCIAL_ |
varchar2 |
Alternative Short Commercial Names | Alternative short commercial names. | ||
COMMUNITY_ |
char |
Is Community Edition | Is application software offered for free? | ||
DATA_ |
varchar2 |
Data Container Alias | Data container alias. | ||
DATA_ |
varchar2 |
Data Container ID | Data container ID. | ||
DEFAULT_ |
guid |
Default Connection ID | Default GUID for first discovered connection of this connector. | ||
DEFAULT_ |
int32 |
Default Number of Parallel Requests | fetched only when named | Default number of parallel requests. | |
DEFAULT_ |
int64 |
Default Slot-based Rate Limit Length (ms) | Default length in ms of a slot-based rate limit. | ||
DEFAULT_ |
int32 |
Default Slot-based Rate Limit Slots | Default number of slots of a slot-based rate limit. | ||
DESCRIPTION |
varchar2 |
Description | Description. | ||
DISPLAY_ |
varchar2 |
Display Name | Display name. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
DOCUMENTATION_ |
varchar2 |
Documentation (URL) | Documentation URL. | ||
DOWNLOAD_ |
varchar2 |
Download Implementation URL | Download URL for implementation. | ||
ESTATE_ |
varchar2 |
Estate Property Name | Invantive Estate property name. | ||
FORUMS_ |
varchar2 |
Forums Tag | Invantive Forums tags. | ||
FUNCTIONAL_ |
varchar2 |
Functional Documentation URL | Functional documentation URL. | ||
FUNCTIONAL_ |
varchar2 |
Functional Support Discord Community | Functional support discourse community. | ||
FUNCTIONAL_ |
varchar2 |
Functional Support Email Address | Functional support email address. | ||
FUNCTIONAL_ |
varchar2 |
Functional Support Phone Number | Functional support phone number. | ||
FUNCTIONAL_ |
varchar2 |
Functional Support URL | Functional support URL. | ||
HANDLING_ |
int32 |
Handling Order | Handling order. | ||
ICON_ |
varchar2 |
Icon Resource Name (16x16) | Name of file with 16x16 icon. | ||
INFLUENCES_ |
char |
Influences Maximum Number of Joins | Influences maximum number of joins? | ||
IS_ |
boolean |
Is Allowed? | Is allowed? | ||
IS_ |
char |
Is Catalog Used in Full Qualified Name | Whether the catalog name is used in constructing the full qualified name. | ||
IS_ |
char |
Is Default? | Is the default connector? | ||
IS_ |
boolean |
Is Essential? | Is essential? | ||
IS_ |
char |
Is Schema Used in Full Qualified Name | Whether the schema name is used in constructing the full qualified name. | ||
IS_ |
char |
Is Service Provider? | Is the connector a service connector? | ||
LICENSING_ |
varchar2 |
Licensing Feature | Licensing feature. | ||
MAIN_ |
varchar2 |
Main Category | Main category. | ||
MARKETPLACE_ |
varchar2 |
Marketplace URL | URL of the marketplace containing integrations and add-ons. | ||
MAXIMUM_ |
int32 |
Maximum Number of Usable Partitions | Maximum number of usable partitions. | ||
NAME |
varchar2 |
Name | Name of the connector. | ||
PARTITIONS_ |
varchar2 |
Partition Label Plural | Partition label in plural form. | ||
PARTITIONS_ |
varchar2 |
Partition Rollup Label Singular | Partition master rollup label in singular form. | ||
PARTITIONS_ |
varchar2 |
Partition Rollup Label Singular | Partition rollup label in singular form. | ||
PARTITION_ |
varchar2 |
Partition Code Column Name | Name of the partition code column. | ||
PARTITION_ |
char |
Partition Has Selected All Partitions | Whether the connector has selected all partitions. | ||
PARTITION_ |
varchar2 |
Partition Label Singular | Partition label in singular form. | ||
PARTITION_ |
varchar2 |
Partition Preferred UI Label Plural | Partition preferred UI label in plural form. | ||
PARTITION_ |
varchar2 |
Partition Preferred UI Label Selected Elements | Partition preferred UI label for selected elements. | ||
PARTITION_ |
varchar2 |
Partition Preferred UI Label Selector | Partition preferred UI label for selector. | ||
PARTITION_ |
varchar2 |
Partition Preferred UI Label Singular | Partition preferred UI label in singular form. | ||
PARTITION_ |
char |
Supports Multiple Selected Partitions | Whether the connector supports multiple selected partitions. | ||
PARTITION_ |
char |
Partition Supports No Selected Partitions | Whether the connector supports no selected partitions. | ||
PARTITION_ |
char |
Supports Partitions | Whether the connector supports partitions. | ||
PARTITION_ |
varchar2 |
Partition Label Singular | Partition label in singular form. | ||
PRODUCTION_ |
char |
Production Use Allowed | Is production use allowed? | ||
PRODUCT_ |
varchar2 |
Product Phase | Product phase. | ||
PROVIDER_ |
guid |
Provider UID | Unique ID of the provider. | ||
PUBLIC_ |
char |
Is Public Data? | Is the data offered publicly? | ||
REDIRECT_ |
varchar2 |
Redirect URL | OAuth redirect URL. | ||
SHORT_ |
varchar2 |
Short Name | Short name. | ||
SHORT_ |
varchar2 |
Short Name for Resources | Short name for use in translation resources. | ||
SLOTBASED_ |
int64 |
Slot-based Rate Limit Length (ms) | Length in ms of a slot-based rate limit. | ||
SLOTBASED_ |
int32 |
Slot-based Rate Limit Slots | Number of slots of a slot-based rate limit, null means no limit. | ||
SQL_ |
varchar2 |
SQL Prefix Parameter | SQL parameter prefix. | ||
STRING_ |
char |
String Comparison is Case-Sensitive | Whether the connector matches text case-sensitive. | ||
SUPPORTS_ |
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_ |
char |
Supports Native Scalar Requests | Whether the platform supports native scalar requests. | ||
SUPPORTS_ |
char |
Supports Native SQL | Whether the platform supports native SQL. | ||
SUPPORTS_ |
char |
Supports Ordering | Whether the connector supports ordering. | ||
SUPPORTS_ |
char |
Supports Simple Filter Delete | Whether the connector supports delete using simple filters. | ||
SUPPORTS_ |
char |
Supports Simple Filter Update | Whether the connector supports update using simple filters. | ||
TAGS |
varchar2 |
Tags | Comma-separated list of tags. | ||
TECHNICAL_ |
varchar2 |
Technical Documentation (URL) | Technical documentation URL. | ||
TECHNICAL_ |
varchar2 |
Technical Support Discord Community | Technical support discourse community. | ||
TECHNICAL_ |
varchar2 |
Technical Support Email Address | Technical support email address. | ||
TECHNICAL_ |
varchar2 |
Technical Support Phone Number | Technical support phone number. | ||
TECHNICAL_ |
varchar2 |
Technical Support URL | Technical support URL. |
Referenced By
- SYSTEMDATACONTAINERS
PROVIDER_NAME(Key) - SYSTEMPACKAGES
PROVIDER_NAME(Key) - SYSTEMPROVIDERATTRIBUTES
PROVIDER_NAME(Key) - SYSTEMPROVIDERSACTIVE
NAME(Key) - SYSTEMPROVIDERSAMPLEQUERIES
PROVIDER_NAME(Key) - SYSTEMTABLES
PROVIDER_NAME(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: