Web Intelligence Dataproviders (XI3).
Column Name |
Data Type |
Description |
|---|---|---|
CANCREATECOMBINEDQUERY |
bit |
Can combined queries be created? |
CANEDITCHANGEQUERY |
bit |
Can the dataprovider be edited? |
CANREFRESHDATAPROVIDER |
bit |
Is dataprovider refreshable? |
CANRETIEVEDUPLICATEROWS |
bit |
Retrieve duplicate rows? |
CANVIEWSQL |
bit |
Can view SQL? |
DATAPROVIDERID |
varchar |
Dataprovider ID |
DATAPROVIDERNAME |
varchar |
Dataprovider name |
DATAPROVIDERTYPE |
varchar |
Dataprovider type |
DATE |
datetime |
Date of the dataprovider being refreshed |
DPROWCOUNT |
int |
Count of all rows in the given dataprovider |
DURATION |
int |
What's the duration of dataprovider refresh for last time it was saved? |
HASCOMBINEDQUERIES |
bit |
Does the dataprovider use combined queries? |
ID |
int |
Primary key |
ISCUSTOMSQL |
bit |
Is the dataprovider using custom SQL? |
ISPARTIALRESULT |
bit |
Is the dataprovider returning a partial result? |
ISQUERYSUBMITTED |
bit |
Is the query submitted? |
ISSAMPLEDATA |
bit |
Is data being sampled? |
ISSAMPLINGFREERANDOM |
bit |
Is sampling free and random? |
ISSAMPLINGREPEATABLERANDOM |
bit |
Is sampling repeatable random? |
ISSQLSUPPORTED |
bit |
Does the dataprovider support SQL? |
ISVALID |
bit |
NOT USED |
SOURCENAME |
varchar |
Source name of the dataprovider |
SQL_CONTAINER_STRUCTURE |
varchar |
Structure of the SQL container within the container hierarchy (union/intersect/synchronized) |
UNIVERSECUID |
varchar |
Universe CUID of the universe used by this dataprovider (equivalent to SI_CUID) |
UNIVERSEID |
varchar |
Universe ID of the universe used by this dataprovider (equivalent to SI_ID) |
WEBI1200_DOCUMENT_ID |
int |
Foreign key to WEBI1200_DOCUMENTS.ID |
See also