SYSTEMPROVIDERSACTIVE: Data Dictionary Active System Providers
read only
- Catalogus:
DataDictionary - Schema:
Invantive - Label: Active System Providers
All providers currently loaded in Invantive SQL.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SYSTEMPROVIDERSACTIVE worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ABBREVIATION |
varchar2 |
Abbreviation | Abbreviation. | ||
BULK_ |
int32 |
Bulktoevoegen Aantal | Number of times a bulk insert was executed. | ||
BULK_ |
double |
Bulktoevoegen Duur Maximum (ms) | Maximum time spent in ms during bulk insert. | ||
BULK_ |
double |
Bulktoevoegen Duur Totaal (ms) | Total time spent in ms during bulk insert. | ||
BULK_ |
int32 |
Bulktoevoegen Pagina Aantal | Number of times a bulk page insert was executed. | ||
BULK_ |
int64 |
Bulktoevoegen Rijtelling | Number of rows inserted in bulk. | ||
CLIENT_ |
varchar2 |
Client-ID | OAuth client ID. | ||
COMMERCIAL_ |
varchar2 |
Commerciële Naam | Commercial name. | ||
COMMUNITY_ |
char |
Is Community Edition | Is application software offered for free? | ||
CONNECTION_ |
datetime |
Verbinding Geopend om (UTC) | Time the connection was opened (UTC). | ||
DATABASE_ |
varchar2 |
Databasebundelomschrijving | Database pool description, in which multiple databases are pooled. | ||
DATABASE_ |
varchar2 |
Database Prijslaag | Database pricing tier. | ||
DATABASE_ |
varchar2 |
Database Dienstenlaag | Database service tier. | ||
DATABASE_ |
varchar2 |
Database Versie | Current database version including platform, edition and version number. | ||
DATABASE_ |
varchar2 |
Databaseversienummer | Current database version number. | ||
DATA_ |
varchar2 |
Datacontainer Alias | Data container alias. | ||
DATA_ |
varchar2 |
Datacontainer ID | Data container ID. | ||
DEFAULT_ |
guid |
Standaard Verbinding ID | Default GUID for first discovered connection of this provider. | ||
DEFAULT_ |
int32 |
Standaard Aantal Parallelle Aanvragen | wordt alleen opgehaald als de naam wordt genoemd | Default number of parallel requests. | |
DEFAULT_ |
int64 |
Standaard Slot-gebaseerde Snelheidsbegrenzer Lengte (ms) | Default length in ms of a slot-based rate limit. | ||
DEFAULT_ |
int32 |
Standaard Slot-gebaseerd Snelheidsbegrenzer Sloten | Default number of slots of a slot-based rate limit. | ||
DESCRIPTION |
varchar2 |
Provideromschrijving | Provider description. | ||
DISPLAY_ |
varchar2 |
Weergavenaam | Display name. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
DOCUMENTATION_ |
varchar2 |
Documentatie (URL) | Documentation URL. | ||
DOWNLOAD_ |
varchar2 |
Download Implementatie URL | Download URL for implementation. | ||
FUNCTIONAL_ |
varchar2 |
URL van de functionele documentatie | Functional documentation URL. | ||
FUNCTIONAL_ |
varchar2 |
Discord-community voor ondersteuning van functies | Functional support discourse community. | ||
FUNCTIONAL_ |
varchar2 |
E-mailadres voor functionele ondersteuning | Functional support email address. | ||
FUNCTIONAL_ |
varchar2 |
Telefoonnummer voor ondersteuning voor functies | Functional support phone number. | ||
FUNCTIONAL_ |
varchar2 |
URL voor functionele ondersteuning | Functional support URL. | ||
HTTP_ |
int32 |
HTTP Schijfcache Treffers | Number of HTTP disk cache hits. | ||
HTTP_ |
int32 |
HTTP Schijfcache Foutieve Inhoud Treffers | HTTP disk cache number of incorrect content hits. | ||
HTTP_ |
int32 |
HTTP Schijfcache Missers | Number of HTTP disk cache misses. | ||
HTTP_ |
int64 |
HTTP Schijfcache Gelezen (byte) | Number of HTTP disk cache disk bytes. | ||
HTTP_ |
int64 |
HTTP Schijfcache Gelezen Gedecomprimeerd (byte) | Number of HTTP disk cache decompressed bytes. | ||
HTTP_ |
int64 |
HTTP Schijfcache Lees Decompressie Operaties | Number of HTTP disk cache decompress operations. | ||
HTTP_ |
int64 |
HTTP Schijfcache Gelezen Ontsleuteld (byte) | Number of HTTP disk cache decrypted bytes. | ||
HTTP_ |
double |
HTTP Schijfcache Lees Decryptieduur (ms) | Number of HTTP disk cache read decrypt duration (ms). | ||
HTTP_ |
int64 |
HTTP Schijfcache Lees Ontsleutelingsoperaties | Number of HTTP disk cache decrypt operations. | ||
HTTP_ |
int64 |
HTTP Schijfcache Leesoperaties | Number of HTTP disk cache operations. | ||
HTTP_ |
int32 |
HTTP Schijfcache Niet-ondersteunde Versleutelingstreffers | HTTP disk cache number of unsupported encryption hits. | ||
HTTP_ |
int32 |
HTTP Schijfcache Niet-ondersteund Formaat Treffers | HTTP disk cache number of unsupported format hits. | ||
HTTP_ |
int64 |
HTTP Schijfcache Geschreven (byte) | Number of HTTP disk cache disk cache write bytes. | ||
HTTP_ |
int64 |
HTTP Schijfcache Geschreven Gecomprimeerd (byte) | Number of HTTP disk cache write compressed bytes. | ||
HTTP_ |
int64 |
HTTP Schijfcache Geschreven Comprimeeroperaties | Number of HTTP disk cache write compress operations. | ||
HTTP_ |
int64 |
HTTP Schijfcache Geschreven Versleuteld (byte) | Number of HTTP disk cache write encrypted bytes. | ||
HTTP_ |
double |
HTTP Schijfcache Geschreven Versleutelingsduur (ms) | Number of HTTP disk cache write encrypt duration (ms). | ||
HTTP_ |
int64 |
HTTP Schijfcache Geschreven Versleutelingsoperaties | Number of HTTP disk cache write encrypt operations. | ||
HTTP_ |
int64 |
HTTP Schijfcache Schrijfoperaties | Number of HTTP disk cache write operations. | ||
HTTP_ |
int32 |
HTTP Geheugencache Aantal | Number of entries in memory cache. | ||
HTTP_ |
int32 |
HTTP Geheugencache Treffers | Number of memory cache hits. | ||
HTTP_ |
int32 |
HTTP Geheugencache Foutieve Inhoud Treffers | Number of memory cache incorrect content hits. | ||
HTTP_ |
int32 |
HTTP Geheugencache Missers | Number of memory cache misses. | ||
HTTP_ |
double |
HTTP Geheugencache Missers Opvraagtijd Maximum (ms) | Maximum original HTTP memory cache fetch time (ms). | ||
HTTP_ |
double |
HTTP Geheugencache Missers Opvraagtijd Minimum (ms) | Minimum original HTTP memory cache fetch time (ms). | ||
HTTP_ |
double |
HTTP Geheugencache Missers Opvraagtijd Totaal (ms) | Total original HTTP memory cache fetch time (ms). | ||
HTTP_ |
int64 |
HTTP Geheugencache Omvang | Estimated size of character of the memory cache. | ||
HTTP_ |
int32 |
HTTP Geheugencache Niet-ondersteund Formaat Treffers | Number of memory cache unsupported format hits. | ||
HTTP_ |
int32 |
HTTP Verzoeken Uitgevoerd | Number of HTTP requests made. | ||
ICON_ |
varchar2 |
Icoon Resourcenaam (16x16) | Name of file with 16x16 icon. | ||
INFLUENCES_ |
char |
Beïnvloedt Maximum Aantal Joins | Influences maximum number of joins? | ||
IS_ |
char |
Wordt Catalogus Gebruikt in Volledige Gekwalificeerde Naam | Whether the catalog name is used in constructing the full qualified name. | ||
IS_ |
char |
Is Standaard? | Is the default provider? | ||
IS_ |
char |
Wordt Schema Gebruikt in Volledige Gekwalificeerde Naam | Whether the schema name is used in constructing the full qualified name. | ||
IS_ |
char |
Is Service Provider? | Is the provider a service provider? | ||
MAIN_ |
varchar2 |
Hoofdcategorie | Main category. | ||
MARKETPLACE_ |
varchar2 |
URL van de marktplaats | URL of the marketplace containing integrations and add-ons. | ||
MAXIMUM_ |
int32 |
Maximum Aantal Parallelle Aanvragen | Maximum number of parallel requests. | ||
MAXIMUM_ |
int32 |
Maximaal Aantal Bruikbare Partities | Maximum number of usable partitions. | ||
NAME |
varchar2 |
Providernaam | Name of the provider. | ||
PARTITION_ |
varchar2 |
Partitiecode Kolomnaam | Name of the partition code column. | ||
PARTITION_ |
varchar2 |
Partitielabel Enkelvoud | Partition label in singular form. | ||
PRODUCTION_ |
char |
Productiegebruik Toegestaan | Is production use allowed? | ||
PROVIDER_ |
guid |
Providerinstantie UID | Unique ID of the provider instance. | ||
PUBLIC_ |
char |
Is Public Data? | Is the data offered publicly? | ||
REDIRECT_ |
varchar2 |
Omleidings-URL | OAuth redirect URL. | ||
SESSION_ |
int64 |
I/O Uitvoering Ontvangen Overige (b) | Number of bytes sent (other). | ||
SESSION_ |
int64 |
I/O Uitvoering Ontvangen (b) | Number of bytes sent overall. | ||
SESSION_ |
int64 |
I/O Uitvoering Ontvangen Lezen (b) | Number of bytes sent for read. | ||
SESSION_ |
int64 |
I/O Uitvoering Ontvangen Schrijven (b) | Number of bytes sent for write. | ||
SESSION_ |
int64 |
I/O Uitvoering Verzonden Overige (b) | Number of bytes received (other). | ||
SESSION_ |
int64 |
I/O Uitvoering Verzonden (b) | Number of bytes received overall. | ||
SESSION_ |
int64 |
I/O Uitvoering Verzonden Lezen (b) | Number of bytes received for read. | ||
SESSION_ |
int64 |
I/O Uitvoering Verzonden Schrijven (b) | Number of bytes received for write. | ||
SESSION_ |
double |
I/O Uitvoeringsduur Overige (ms) | Total duration for other in milliseconds. | ||
SESSION_ |
double |
I/O Uitvoeringsduur (ms) | Total duration overall in milliseconds. | ||
SESSION_ |
double |
I/O Uitvoeringsduur Lezen | Total duration for read in milliseconds. | ||
SESSION_ |
double |
I/O Uitvoeringsduur Schrijven (ms) | Total duration for write in milliseconds. | ||
SESSION_ |
int64 |
I/O Uitvoering Aantal Overige | Number of I/Os executed (other). | ||
SESSION_ |
int64 |
I/O Uitvoering Aantal | Number of I/Os executed overall. | ||
SESSION_ |
int64 |
I/O Uitvoering Aantal Lezen | Number of I/Os executed for read. | ||
SESSION_ |
int64 |
I/O Uitvoering Aantal Schrijven | Number of I/Os executed for write. | ||
SHORT_ |
varchar2 |
Provider Korte Naam | Provider short name. | ||
SLOTBASED_ |
int64 |
Slot-gebaseerde Snelheidsbegrenzer Lengte (ms) | Length in ms of a slot-based rate limit. | ||
SLOTBASED_ |
int32 |
Slot-gebaseerd Snelheidsbegrenzer Sloten | Number of slots of a slot-based rate limit, null means no limit. | ||
SQL_ |
varchar2 |
SQL Voorvoegselparameter | SQL parameter prefix. | ||
STRING_ |
char |
Tekstvergelijking is Hoofdlettergevoelig | Whether the provider matches text case-sensitive. | ||
SUPPORTS_ |
char |
Ondersteunt Kolomfiltering | Whether column filtering is supported; if true, the provider can filter the resulting columns itself based on a select statement. | ||
SUPPORTS_ |
char |
Ondersteunt Native Enkelvoudige Verzoeken | Whether the platform supports native scalar requests. | ||
SUPPORTS_ |
char |
Ondersteunt Native SQL | Whether the platform supports native SQL. | ||
SUPPORTS_ |
char |
Ondersteunt Sortering | Whether the provider supports ordering. | ||
SUPPORTS_ |
char |
Ondersteunt Eenvoudig Filter Verwijderen | Whether the provider supports delete using simple filters. | ||
SUPPORTS_ |
char |
Ondersteunt Eenvoudig Filter Bijwerken | Whether the provider supports update using simple filters. | ||
TECHNICAL_ |
varchar2 |
Technische Documentatie (URL) | Technical documentation URL. | ||
TECHNICAL_ |
varchar2 |
Discord-community voor technische ondersteuning | Technical support discourse community. | ||
TECHNICAL_ |
varchar2 |
E-mailadres voor technische ondersteuning | Technical support email address. | ||
TECHNICAL_ |
varchar2 |
Telefoonnummer voor technische ondersteuning | Technical support phone number. | ||
TECHNICAL_ |
varchar2 |
URL voor technische ondersteuning | Technical support URL. | ||
TRY_ |
number |
Probeer Volgorde | Ascending order in which providers are tried. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
SYSTEMPROVIDERSACTIVE_ |
NAME |
SYSTEMPROVIDERS.NAME |
Key | |
SYSTEMPROVIDERSACTIVE_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: