MicroStrategy ONE

Connect DSN statement

Opens a Command Manager connection to a Narrowcast Server metadata using a Data Source Name (DSN).

Copy
CONNECT DSN "data_source_name" [USER "login"] [PASSWORD "password"] [DATABASE "database"] [PREFIX "prefix"];

where:

  • data_source_name is the data source name, of type string, between double quotes (").

  • login is the name of the user used to connect to the Data Source, of type string, between double quotes (").

  • password is the password of the user, of type string, between double quotes (").

  • database is the database which contains the Narrowcast Server metadata, of type string, between double quotes (").

  • prefix is the database prefix for the metadata, of type string, between double quotes (").

Example

Copy
CONNECT DSN "SystemNCS" USER "NCSAdmin" PASSWORD "jfh8d9d9" DATABASE "NCS_DBase";