Connections deconstructed from known SQL statements of Webi, Deski reports.
Column Name |
Data Type |
Description |
|---|---|---|
CMSID |
varchar |
The actualy name of the CMS host machine without the port number, if used. В This is used in conjunction with OBJECTID or CUID to uniquely identify an object across environments |
DATABASEENGINE |
varchar |
Database engine of the connection |
DATABASESOURCE |
varchar |
Database source of the connection |
ID |
int |
ID of the connection (globally unique) |
NAME |
varchar |
The name of the object, in many cases the equivalent of SI_ID in the CMS/Query Builder when referring to a base CMS object type (USERS, SEMANTICLAYER etc.) |
SCHEMAOBJECTTYPE |
varchar |
Schema object type |
TYPE |
int |
Type |
USERNAME |
varchar |
Username associated w/ the connection credentials |
See also