MicroStrategy ONE

Connect to a Data Source

See Manage Environments before you connect to a data source.

To import data from a database, you must establish communication between your environment MicroStrategy Workstation and your data source. To establish communication, you create a database connection. A database connection specifies the connection information used to access the data source enabling MicroStrategy Workstation to retrieve data.

Some data sources allow you to connect directly to the data source during the data import process. This can streamline the process of importing data. To determine whether your data source is a type that supports direct connections, see the online readme corresponding to your software version.

You can connect to a relational data source or an MDX data source. See Create a Database Connection and How to Create a Data Source Connection to an OLAP (MDX Cube) Source for more information.

After you create a database connection, you can edit, delete, rename, or duplicate it. See How to Manage Database Connections for more information.

You must define the OAuth parameters for the connection when using the following data sources:

  • Dropbox
  • Google Analytics
  • Google Drive
  • Salesforce.com
  • Twitter

See Configure OAuth Parameters for a Data Source for more information.

Related Topics

Introduction to MicroStrategy Workstation

Import Data