Table CONN_CONNECTIONS

ACTIVESTATE

nvarchar

An enumerator object that identifies the state of the connection, which may be: dsDisconnectAfterEachTransaction, dsKeepActiveForxx, or dsKeepActiveForWholeSession. This is the setting of the Connection Properties section of the Advanced tab of an individual network layer dialog box.

ACTIVETIME

int

This is the minutes value in the Connection Properties section of the Advanced tab of an individual network layer dialog box. It is applicable only if dsKeepActiveForLimitedTime is selected for the ActiveState property.

ARRAYBINDSIZE

int

Represents the number of rows sent at once (a packet) to the database server for an INSERT request. This affects document and universe uploads.

CATALOG

nvarchar

This parameter is common to all OLAP connection types and returns the name of the cube.

CLIENTNUMBER

int

This property applies to SAP OLAP connections only and returns the client number (100, 800).

CMSID

varchar

The actual 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.

CONNECTIONCUID

varchar

CUID of the connection

CONNECTIONFOLDERPATH

nvarchar

Folder path of the connection

CONNECTIONMUID

varchar

Connection CUID + CMS NAME (NOT USED)

CONNECTIONNAME

nvarchar

Name of the connection

CONNECTIONPK

nvarchar

Primary key of the CONN_CONNECTIONS table

CONNECTIONTYPE

nvarchar

Connection type is an enumerator object that identifies the connection type, which may be: dsPersonal (=1) dsSecured (=2) dsShared (=3) This is the Type list box of the Login tab of an individual network layer dialog box.

CREATED

datetime

Time the connection was created

DATABASEENGINE

nvarchar

Sets or returns a string with the name of the database engine. This is the Database engine list box of the Login tab of an individual network layer dialog box.

DATABASESOURCE

nvarchar

Sets or returns a string with the name of the database source. В This is the Data source name text box of the Login tab of an individual network layer dialog box.

ID

int

Internal MetaMiner DB id

ISDELETED

bit

Indicates whether this object was deleted from the SAP BusinessObjects CMS. В When set to "1", the object was deleted and MetaMiner keeps a "soft delete" record of its metadata.

ISSYNCHMODE

bit

returns True if the connection is asynchronous, and False otherwise

NETWORKLAYER

nvarchar

Returns a string containing the network layer for the connection

PASSWORD

nvarchar

EMPTY

SAPLANGUAGE

nvarchar

This property applies to SAP OLAP connections only and returns the language of the object (EN, F, …).

SAPSYSTEMID

nvarchar

This property applies to SAP OLAP connections only and returns the system ID. String, returns system ID (BOF)

SAPSYSTEMNUMBER

nvarchar

This property applies to SAP OLAP connections only and returns the system number (00, 01 ...).

SERVER

nvarchar

returns a string with the server name. This parameter is common to all OLAP connection types

UPDATED

datetime

Datetime that this object was updated in the SAP BusinessObjects CMS

USERNAME

nvarchar

returns a string with the user name of the connection class

USESINGLESIGNON

bit

Determines whether or not the connection uses Enterprise Single Sign On to log in to the database