MicroStrategy ONE

Create, Edit, and Delete Standalone Database Connections and Logins

MicroStrategy ONE (March 2024) streamlines the ability to create, edit, and delete standalone database connections and logins.

You must have the following privileges to manage database connections and logins:

  • Configure project data source

  • Create configuration objects

  • Create and Edit Database Instances and connections

  • Create and edit database logins

Manage Database Connections

  1. Open the Workstation window.
  2. In the Navigation pane, click Data Sources.

  3. Click Database Connections to view all standalone connection objects.

  4. Here you can add a new database connection, export the grid to CSV, or filter the grid by Name, Type, Driver, or Login.
  5. To edit or delete a connection object, right-click it and choose Edit or Delete.

  6. To view general properties, the change journal, or security access for modifying ACLs, right-click a connection object and choose Properties.

Manage Database Logins

  1. Click Database Logins to view all standalone login objects.

  2. Here you can add a new database login, export the grid to CSV, or filter the grid by Name.
  3. To edit or delete a database login, right-click it and choose Edit or Delete.

  4. To view general properties, the change journal, or security access for modifying ACLs, right-click a database login and choose Properties.