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 SQL 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.
The columns of the view SYSTEMPROVIDERS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ABBREVIATION |
string(3) |
Abbreviation |
☑ |
Abbreviation. |
COMMERCIAL_NAME |
string(240) |
|
☑ |
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 |
int32 |
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. |
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 |
|
☑ |
Whether the connector has selected all partitions. |
PARTITION_INFO_LABEL_SINGULAR |
string(240) |
|
☐ |
Partition label in singular form. |
PARTITION_INFO_PREFERRED_UI_LABEL_PLURAL |
string(240) |
|
☐ |
Partition preferred UI label in plural form. |
PARTITION_INFO_PREFERRED_UI_LABEL_SELECTED_ELEMENTS |
string(240) |
|
☐ |
Partition preferred UI label for selected elements. |
PARTITION_INFO_PREFERRED_UI_LABEL_SELECTOR |
string(240) |
|
☐ |
Partition preferred UI label for selector. |
PARTITION_INFO_PREFERRED_UI_LABEL_SINGULAR |
string(240) |
|
☐ |
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 |
|
☑ |
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 in plural form. |
PARTITIONS_INFO_MASTER_ROLLUP_LABEL |
string(240) |
|
☐ |
Partition master rollup label in singular form. |
PARTITIONS_INFO_ROLLUP_LABEL |
string(240) |
|
☐ |
Partition rollup label in singular form. |
PRODUCTION_USE_ALLOWED |
boolean |
Production Use Allowed |
☑ |
Is production use allowed? |
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 |
int32 |
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. |
17-05-2021 11:57 Version 20.1.419-BETA+3191