Table DESKI_DATAPROVIDERS

Dataprovider details of Desktop Intelligence documents.

Column Name	Data Type	Description
CREATED	datetime	The datetime an object was created (for the first time) in the BusinessObjects CMS; Equivalent to SI_CREATION_TIME
DATAPROVIDERID	nvarchar	Dataprovider ID
DATAPROVIDERNAME	nvarchar	Dataprovider Name
DERIVEDCONNECTION	nvarchar	Connection used by the dataprovider; fallback method; primary method is to examine UNIVERSECUID or UNIVERSENAME or SOURCENAME property
DESKI_DOCUMENTS_ID	int	Foreign key to DESK_DOCUMENTS.ID
DESKIMUID	varchar	CUD + Server name
DOCUMENTID	int	SI_ID of the Deski document
DPTYPE	nvarchar	Type of dataprovider (Freehand SQL, Universe, etc)
DURATION	int	Duration that the dataprovider last ran for
ID	int	Internal MetaMiner DB id
ISCUSTOMSQL	bit	Does the dataprovider use custom SQL?
ISEDITABLE	bit	Is the dataprovider editable?
ISPARTIALREFRESH	bit	Is the dataprovider only partially refreshed?
ISREFRESHABLE	bit	Is the dataprovider refreshable?
ISVALID	bit	Is the dataprovider valid? (MetaMiner may flag this as invalid when the dataprovider doesn't work correctly)
LASTEXECUTIONTIME	datetime	Last time the dataprovider was refreshed and saved
LASTEXECUTIONTIME_SEC	int	Duration the last time the dataprovider was refreshed and saved
LASTREFRESHDATE	datetime	Last refresh date of the dataprovider
MAXDURATION	int	retrieves the maximum duration of the refresh of the data provider
MAXROWS	int	retrieves the maximum number of lines returned by the DP.
NBRCUBES	int	Returns the number of cubes of this data provider .
NBRROWSFETCHED	int	Returns the number of rows fetched.
QUERYSTRUCTURE	nvarchar	The orientation of the SQL queries of the Dataprovider
SOURCEID	nvarchar	Source ID (Universe ID or CUID string) of the dataprovider
SOURCENAME	nvarchar	Source name of the universe used by the dataprovider
SQLPARSECODE	int	Returns 0 if the dataprovider's SQL was parsable, 1 if it wasn't parsable
SQLPARSEERROR	nvarchar	Any errors returned while attempting to parse the dataproviders SQL
SQLTEXT	nvarchar	The SQL of the dataprovider
UNIVERSECUID	varchar	CUID of the universe used by the dataprovider
UNIVERSEMUID	varchar	Universe CUID + CMS Server name
UNIVERSENAME	nvarchar	Universe Name used by the dataprovider
UNV_UNIVERSES_ID	int	NOT USED
UPDATED	datetime	Datetime that this object was updated in the BusinessObjects CMS