SYSTEMPROVIDERATTRIBUTES: Data Dictionary System Provider Attributes
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: System Provider Attributes
Attributes per registered and licensed provider.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMPROVIDERATTRIBUTES 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 |
|---|---|---|---|---|---|
ALLOWED_ |
varchar2 |
Allowed Values | Values the attribute accepts, separated by a comma, when it accepts a fixed set of them. | ||
ALLOW_ |
char |
Allow Display | Whether to allow displaying the value. | ||
ALLOW_ |
char |
Allow Set from Connecton String | Whether to allow setting the value from connection string. | ||
ALLOW_ |
char |
Allow Set from Log On | Whether to allow setting the value from log on window. | ||
ALLOW_ |
char |
Allow Set from Provider File | Whether to allow setting the value from provider file. | ||
ALLOW_ |
char |
Allow Set from Set Statement | Whether to allow setting the value from set SQL statement. | ||
CATEGORY |
varchar2 |
Category | Category of the attribute. | ||
CODE |
varchar2 |
Code | Code of the attribute. | ||
DEFAULT_ |
varchar2 |
Default Value | Default value of the property. | ||
DEFINING_ |
varchar2 |
Defining Type Assembly Qualified Name | Assembly qualified name of the defining type. | ||
DEFINING_ |
varchar2 |
Defining Type Name | Name of the defining type. | ||
DEFINING_ |
varchar2 |
Defining Type Namespace | Namespace of the defining type. | ||
DEFINING_ |
varchar2 |
Defining Type Provider Description | Description of the provider for the defining type. | ||
DEFINING_ |
varchar2 |
Defining Type Provider Display Name | Display name of the provider for the defining type. | ||
DEFINING_ |
varchar2 |
Defining Type Provider Name | Name of the provider for the defining type. | ||
DESCRIPTION |
varchar2 |
Description | Description of the attribute. | ||
DISPLAY_ |
int32 |
Display Order | Display order. | ||
EXPLANATION |
varchar2 |
Explanation | Explanation of the attribute. | ||
HAS_ |
char |
Has Getter | Whether the attribute has a get method. | ||
HAS_ |
char |
Has Setter | Whether the attribute has a set method. | ||
OBSOLETED |
char |
Obsoleted | Whether the attribute is obsoleted. | ||
ORIGIN |
varchar2 |
Origin | Origin of the current value of the property. | ||
PROVIDER_ |
char |
Is Community Edition | Is application software offered for free? | ||
PROVIDER_ |
varchar2 |
Data Container Alias | Data container alias. | ||
PROVIDER_ |
varchar2 |
Data Container ID | Data container ID. | ||
PROVIDER_ |
varchar2 |
Provider Description | Provider description. | ||
PROVIDER_ |
varchar2 |
Provider Documentation | Documentation of the provider. | ||
PROVIDER_ |
varchar2 |
Documentation (URL) | Documentation URL. | ||
PROVIDER_ |
varchar2 |
Download Implementation URL | Download URL for implementation. | ||
PROVIDER_ |
varchar2 |
Functional Documentation URL | Functional documentation URL. | ||
PROVIDER_ |
varchar2 |
Functional Support Discord Community | Functional support discourse community. | ||
PROVIDER_ |
varchar2 |
Functional Support Email Address | Functional support email address. | ||
PROVIDER_ |
varchar2 |
Functional Support Phone Number | Functional support phone number. | ||
PROVIDER_ |
varchar2 |
Functional Support URL | Functional support URL. | ||
PROVIDER_ |
char |
Influences Maximum Number of Joins | Influences maximum number of joins? | ||
PROVIDER_ |
char |
Is Default? | Is the default provider? | ||
PROVIDER_ |
char |
Is Service Provider? | Is the provider a service provider? | ||
PROVIDER_ |
varchar2 |
Marketplace URL | URL of the marketplace containing integrations and add-ons. | ||
PROVIDER_ |
varchar2 |
Provider Name | Name of the provider. | ||
PROVIDER_ |
char |
Production Use Allowed | Is production use allowed? | ||
PROVIDER_ |
char |
Is Public Data? | Is the data offered publicly? | ||
PROVIDER_ |
varchar2 |
Provider Short Name | Provider short name. | ||
PROVIDER_ |
varchar2 |
Technical Documentation (URL) | Technical documentation URL. | ||
PROVIDER_ |
varchar2 |
Technical Support Discord Community | Technical support discourse community. | ||
PROVIDER_ |
varchar2 |
Technical Support Email Address | Technical support email address. | ||
PROVIDER_ |
varchar2 |
Technical Support Phone Number | Technical support phone number. | ||
PROVIDER_ |
varchar2 |
Technical Support URL | Technical support URL. | ||
PROVIDER_ |
guid |
Provider UID | Unique ID of the provider. | ||
REQUIRED |
char |
Required | Whether a connection can not be made without a value for the attribute. | ||
VALUE |
varchar2 |
Value | Current value of the property. | ||
VALUE_ |
varchar2 |
Value Kind | Kind of value the attribute holds, such as a directory, a list of directories or free text. | ||
VALUE_ |
char |
Value Reveals OS-properties | Whether the attribute reveals OS-properties. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
SYSTEMPROVIDERATTRIBUTES_ |
PROVIDER_ |
SYSTEMPROVIDERS.NAME |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: