SYSTEMPROVIDERS: Data Dictionary Providers
read only
- Catalogus:
DataDictionary - Schema:
Invantive - Label: Providers
All registered and licensed providers available in Invantive SQL.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SYSTEMPROVIDERS 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. | ||
CLIENT_ |
varchar2 |
Client-ID | OAuth client ID. | ||
COMMERCIAL_ |
varchar2 |
Commerciële Naam | Commercial name. | ||
COMMERCIAL_ |
varchar2 |
Commerciële Naam Kort | Commercial name (short). | ||
COMMERCIAL_ |
varchar2 |
Alternatieve Korte Commerciële Namen | Alternative short commercial names. | ||
COMMUNITY_ |
char |
Is Community Edition | Is application software offered for free? | ||
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 connector. | ||
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 |
Description | 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. | ||
ESTATE_ |
varchar2 |
Estate Eigenschapsnaam | Invantive Estate property name. | ||
FORUMS_ |
varchar2 |
Forumstag | Invantive Forums tags. | ||
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. | ||
HANDLING_ |
int32 |
Verwerkingsvolgorde | Handling order. | ||
ICON_ |
varchar2 |
Icoon Resourcenaam (16x16) | Name of file with 16x16 icon. | ||
INFLUENCES_ |
char |
Beïnvloedt Maximum Aantal Joins | Influences maximum number of joins? | ||
IS_ |
boolean |
Is Toegestaan? | Is allowed? | ||
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 connector? | ||
IS_ |
boolean |
Is Essentieel? | Is essential? | ||
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 connector a service connector? | ||
LICENSING_ |
varchar2 |
Licentievoorziening | Licensing feature. | ||
MAIN_ |
varchar2 |
Hoofdcategorie | Main category. | ||
MARKETPLACE_ |
varchar2 |
URL van de marktplaats | URL of the marketplace containing integrations and add-ons. | ||
MAXIMUM_ |
int32 |
Maximaal Aantal Bruikbare Partities | Maximum number of usable partitions. | ||
NAME |
varchar2 |
Name | Name of the connector. | ||
PARTITIONS_ |
varchar2 |
Partitie Label Meervoud | Partition label in plural form. | ||
PARTITIONS_ |
varchar2 |
Partitie Oprol Label Enkelvoud | Partition master rollup label in singular form. | ||
PARTITIONS_ |
varchar2 |
Partitie Oprol Label Enkelvoud | Partition rollup label in singular form. | ||
PARTITION_ |
varchar2 |
Partitiecode Kolomnaam | Name of the partition code column. | ||
PARTITION_ |
char |
Partitie Heeft Alle Partities Geselecteerd | Whether the connector has selected all partitions. | ||
PARTITION_ |
varchar2 |
Partitielabel Enkelvoud | Partition label in singular form. | ||
PARTITION_ |
varchar2 |
Partitie Voorkeurs-UI Label Meervoud | Partition preferred UI label in plural form. | ||
PARTITION_ |
varchar2 |
Partitie Voorkeurs-UI Label Geselecteerde Elementen | Partition preferred UI label for selected elements. | ||
PARTITION_ |
varchar2 |
Partition Voorkeurs-UI Label Selector | Partition preferred UI label for selector. | ||
PARTITION_ |
varchar2 |
Partitie Voorkeurs-UI Label Enkelvoud | Partition preferred UI label in singular form. | ||
PARTITION_ |
char |
Ondersteunt Meerdere Geselecteerde Partities | Whether the connector supports multiple selected partitions. | ||
PARTITION_ |
char |
Partitie Ondersteunt geen Geselecteerde Partities | Whether the connector supports no selected partitions. | ||
PARTITION_ |
char |
Ondersteunt Partities | Whether the connector supports partitions. | ||
PARTITION_ |
varchar2 |
Partitielabel Enkelvoud | Partition label in singular form. | ||
PRODUCTION_ |
char |
Productiegebruik Toegestaan | Is production use allowed? | ||
PRODUCT_ |
varchar2 |
Productfase | Product phase. | ||
PROVIDER_ |
guid |
Provider UID | Unique ID of the provider. | ||
PUBLIC_ |
char |
Is Public Data? | Is the data offered publicly? | ||
REDIRECT_ |
varchar2 |
Omleidings-URL | OAuth redirect URL. | ||
SHORT_ |
varchar2 |
Korte Naam | Short name. | ||
SHORT_ |
varchar2 |
Korte Naam voor Bronnen | Short name for use in translation resources. | ||
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 connector matches text case-sensitive. | ||
SUPPORTS_ |
char |
Ondersteunt Kolomfiltering | Whether column filtering is supported; if true, the connector 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 connector supports ordering. | ||
SUPPORTS_ |
char |
Ondersteunt Eenvoudig Filter Verwijderen | Whether the connector supports delete using simple filters. | ||
SUPPORTS_ |
char |
Ondersteunt Eenvoudig Filter Bijwerken | Whether the connector supports update using simple filters. | ||
TAGS |
varchar2 |
Tags | Comma-separated list of tags. | ||
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. |
Geciteerd door
- 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
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: