invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMPROVIDERSACTIVE: Data Dictionary Active System Providers

read only

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

All providers currently loaded in Invantive SQL.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMPROVIDERSACTIVE 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.
BULK_INSERT_COUNT int32 Bulk Insert Count Number of times a bulk insert was executed.
BULK_INSERT_DURATION_MAX_MS double Bulk Insert Duration Maximum (ms) Maximum time spent in ms during bulk insert.
BULK_INSERT_DURATION_TOTAL_MS double Bulk Insert Duration Total (ms) Total time spent in ms during bulk insert.
BULK_INSERT_PAGE_COUNT int32 Bulk Insert Page Count Number of times a bulk page insert was executed.
BULK_INSERT_ROW_COUNT int64 Bulk Insert Row Count Number of rows inserted in bulk.
CLIENT_ID varchar2(240) Client ID OAuth client ID.
COMMERCIAL_NAME varchar2(240) Commercial Name Commercial name.
COMMUNITY_EDITION char Is Community Edition Is application software offered for free?
CONNECTION_OPENED_AT_UTC datetime Connection Opened at (UTC) Time the connection was opened (UTC).
DATABASE_POOL_DESCRIPTION varchar2(4000) Database Pool Description Database pool description, in which multiple databases are pooled.
DATABASE_PRICING_TIER varchar2(240) Database Pricing Tier Database pricing tier.
DATABASE_SERVICE_TIER varchar2(240) Database Service Tier Database service tier.
DATABASE_VERSION varchar2(240) Database Version Current database version including platform, edition and version number.
DATABASE_VERSION_NUMBER varchar2(240) Database Version Number Current database version number.
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 provider.
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(4000) Provider Description Provider 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.
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.
HTTP_DISK_CACHE_HITS int32 HTTP Disk Cache Hits Number of HTTP disk cache hits.
HTTP_DISK_CACHE_INCORRECT_CONTENT_HITS int32 HTTP Disk Cache Incorrect Content Hits HTTP disk cache number of incorrect content hits.
HTTP_DISK_CACHE_MISSES int32 HTTP Disk Cache Misses Number of HTTP disk cache misses.
HTTP_DISK_CACHE_READ_BYTES int64 HTTP Disk Cache Read (byte) Number of HTTP disk cache disk bytes.
HTTP_DISK_CACHE_READ_DECOMPRESSED_BYTES int64 HTTP Disk Cache Read Decompressed (byte) Number of HTTP disk cache decompressed bytes.
HTTP_DISK_CACHE_READ_DECOMPRESS_OPERATIONS int64 HTTP Disk Cache Read Decompress Operations Number of HTTP disk cache decompress operations.
HTTP_DISK_CACHE_READ_DECRYPTED_BYTES int64 HTTP Disk Cache Read Decrypted (byte) Number of HTTP disk cache decrypted bytes.
HTTP_DISK_CACHE_READ_DECRYPT_DURATION_MS double HTTP Disk Cache Read Decrypt Duration (ms) Number of HTTP disk cache read decrypt duration (ms).
HTTP_DISK_CACHE_READ_DECRYPT_OPERATIONS int64 HTTP Disk Cache Read Decrypt Operations Number of HTTP disk cache decrypt operations.
HTTP_DISK_CACHE_READ_OPERATIONS int64 HTTP Disk Cache Read Operations Number of HTTP disk cache operations.
HTTP_DISK_CACHE_UNSUPPORTED_ENCRYPTION_HITS int32 HTTP Disk Cache Unsupported Encryption Hits HTTP disk cache number of unsupported encryption hits.
HTTP_DISK_CACHE_UNSUPPORTED_FORMAT_HITS int32 HTTP Disk Cache Unsupported Format Hits HTTP disk cache number of unsupported format hits.
HTTP_DISK_CACHE_WRITE_BYTES int64 HTTP Disk Cache Write (byte) Number of HTTP disk cache disk cache write bytes.
HTTP_DISK_CACHE_WRITE_COMPRESSED_BYTES int64 HTTP Disk Cache Write Compressed (byte) Number of HTTP disk cache write compressed bytes.
HTTP_DISK_CACHE_WRITE_COMPRESS_OPERATIONS int64 HTTP Disk Cache Write Compress Operations Number of HTTP disk cache write compress operations.
HTTP_DISK_CACHE_WRITE_ENCRYPTED_BYTES int64 HTTP Disk Cache Write Encrypted (byte) Number of HTTP disk cache write encrypted bytes.
HTTP_DISK_CACHE_WRITE_ENCRYPT_DURATION_MS double HTTP Disk Cache Write Encrypt Duration (ms) Number of HTTP disk cache write encrypt duration (ms).
HTTP_DISK_CACHE_WRITE_ENCRYPT_OPERATIONS int64 HTTP Disk Cache Write Encrypt Operations Number of HTTP disk cache write encrypt operations.
HTTP_DISK_CACHE_WRITE_OPERATIONS int64 HTTP Disk Cache Write Operations Number of HTTP disk cache write operations.
HTTP_MEMORY_CACHE_COUNT int32 HTTP Memory Cache Count Number of entries in memory cache.
HTTP_MEMORY_CACHE_HITS int32 HTTP Memory Cache Hits Number of memory cache hits.
HTTP_MEMORY_CACHE_INCORRECT_CONTENT_HITS int32 HTTP Memory Cache Incorrect Content Hits Number of memory cache incorrect content hits.
HTTP_MEMORY_CACHE_MISSES int32 HTTP Memory Cache Misses Number of memory cache misses.
HTTP_MEMORY_CACHE_MISSES_FETCH_TIME_MS_MAX double HTTP Memory Cache Misses Fetch Time Maximum (ms) Maximum original HTTP memory cache fetch time (ms).
HTTP_MEMORY_CACHE_MISSES_FETCH_TIME_MS_MIN double HTTP Memory Cache Misses Fetch Time Minimum (ms) Minimum original HTTP memory cache fetch time (ms).
HTTP_MEMORY_CACHE_MISSES_FETCH_TIME_MS_TOTAL double HTTP Memory Cache Misses Fetch Time Total (ms) Total original HTTP memory cache fetch time (ms).
HTTP_MEMORY_CACHE_SIZE int64 HTTP Memory Cache Cache Size Estimated size of character of the memory cache.
HTTP_MEMORY_CACHE_UNSUPPORTED_FORMAT_HITS int32 HTTP Memory Cache Unsupported Format Hits Number of memory cache unsupported format hits.
HTTP_REQUESTS_EXECUTED int32 HTTP Requests Executed Number of HTTP requests made.
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_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 provider?
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 provider a service provider?
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_PARALLEL_REQUESTS int32 Maximum Number of Parallel Requests Maximum number of parallel requests.
MAXIMUM_NUMBER_USABLE_PARTITIONS int32 Maximum Number of Usable Partitions Maximum number of usable partitions.
NAME varchar2(240) Provider Name Name of the provider.
PARTITION_CODE_COLUMN_NAME varchar2(240) Partition Code Column Name Name of the partition code column.
PARTITION_LABEL_SINGULAR varchar2(240) Partition Label Singular Partition label in singular form.
PRODUCTION_USE_ALLOWED char Production Use Allowed Is production use allowed?
PROVIDER_INSTANCE_UID guid Provider Instance UID Unique ID of the provider instance.
PUBLIC_DATA char Is Public Data? Is the data offered publicly?
REDIRECT_URL varchar2(4000) Redirect URL OAuth redirect URL.
SESSION_IO_BYTES_RECEIVED_OTHER int64 I/O Execution Bytes Received Other Number of bytes sent (other).
SESSION_IO_BYTES_RECEIVED_OVERALL int64 I/O Execution Bytes Received Number of bytes sent overall.
SESSION_IO_BYTES_RECEIVED_READ int64 I/O Execution Bytes Received Read Number of bytes sent for read.
SESSION_IO_BYTES_RECEIVED_WRITE int64 I/O Execution Bytes Received Write Number of bytes sent for write.
SESSION_IO_BYTES_SENT_OTHER int64 I/O Execution Bytes Sent Other Number of bytes received (other).
SESSION_IO_BYTES_SENT_OVERALL int64 I/O Execution Bytes Sent Number of bytes received overall.
SESSION_IO_BYTES_SENT_READ int64 I/O Execution Bytes Sent Read Number of bytes received for read.
SESSION_IO_BYTES_SENT_WRITE int64 I/O Execution Bytes Sent Write Number of bytes received for write.
SESSION_IO_DURATION_MS_OTHER double I/O Execution Duration Other (ms) Total duration for other in milliseconds.
SESSION_IO_DURATION_MS_OVERALL double I/O Execution Duration (ms) Total duration overall in milliseconds.
SESSION_IO_DURATION_MS_READ double I/O Execution Duration Read (ms) Total duration for read in milliseconds.
SESSION_IO_DURATION_MS_WRITE double I/O Execution Duration Write (ms) Total duration for write in milliseconds.
SESSION_IO_EXECUTION_COUNT_OTHER int64 I/O Execution Count Other Number of I/Os executed (other).
SESSION_IO_EXECUTION_COUNT_OVERALL int64 I/O Execution Count Number of I/Os executed overall.
SESSION_IO_EXECUTION_COUNT_READ int64 I/O Execution Count Read Number of I/Os executed for read.
SESSION_IO_EXECUTION_COUNT_WRITE int64 I/O Execution Count Write Number of I/Os executed for write.
SHORT_NAME varchar2(240) Provider Short Name Provider 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 provider matches text case-sensitive.
SUPPORTS_COLUMN_FILTERING char Supports Column Filtering Whether column filtering is supported; if true, the provider 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 provider supports ordering.
SUPPORTS_SIMPLE_FILTER_DELETE char Supports Simple Filter Delete Whether the provider supports delete using simple filters.
SUPPORTS_SIMPLE_FILTER_UPDATE char Supports Simple Filter Update Whether the provider supports update using simple filters.
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.
TRY_ORDER number Try Order Ascending order in which providers are tried.

Keys

Key Column Refers to Kind Description
SYSTEMPROVIDERSACTIVE_NAME_SYSTEMPROVIDERS_fk NAME SYSTEMPROVIDERS.NAME Key
SYSTEMPROVIDERSACTIVE_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID Key

Release Notes

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