MicroStrategy ONE

Create Connection Map statement

Creates a connection map between a user or user group, a database connection, and a database login in a project.

Copy 
CREATE CONNECTION MAP FOR (USER 
 "user_name" | USER 
 GROUP "group_name") 
 DBINSTANCE "dbinstance_name" 
 DBCONNECTION "dbconnection_name" 
 DBLOGIN "dblogin_name" 
 [LANGUAGE "locale_name"] 
 FOR PROJECT "project_name";

where:

  • USER "user_name" is the login name of an existing user to whom the connection map is to apply, of type string.

  • GROUP "group_name" is the login name of an existing user group to whom the connection map is to apply, of type string.

  • DBINSTANCE "dbinstance_name" is the name of an existing database instance (role) that will be used for the connection map, of type string.

  • DBCONNECTION "dbconnection_name" is the name of an existing database connection to be used for the mapping, of type string.

  • DBLOGIN "dblogin_name" is the name of an existing database login to be used for the mapping, of type string.

  • LANGUAGE "locale_name"  is the locale name that is associated with the project, of type string.

  • PROJECT "project_name" is the name of the project in which the connection map is to be used, of type string.

Example

Copy 
CREATE 
 CONNECTION MAP FOR USER "palcazar 
 DBINSTANCE DBRole1 DBCONNECTION DBConn1 DBLOGIN 
 DBLogin1 ON PROJECT 3-Tier Project;