MicroStrategy ONE

Data Source Dialog

Use the Data Source dialog to configure data sources.

Access

To access the Data Source dialog:

  1. Choose Add Data > New Data.
  2. Select the engine to use to connect (Amazon Redshift, Apache Cassandra, etc.).
  3. Select an option and click Next.
  4. In the Data Sources/Projects pane, click Add .

Fields

The fields on this dialog vary, depending on the type of engine you use. Some of the most common fields are shown below.

Database: The database connection type (Amazon Redshift, Apache Cassandra, etc.). This field only appears for DSN-less data sources.

DBMS: Select the appropriate database management system (DBMS).

DSN: The data source name. This field only appears for DSN data sources.

Version: The version of the data source that you are connecting to.

Show databases whose certified drivers were not found: If you clear this checkbox, only databases that have an installed and configured driver are available for selection. You can connect to these databases by supplying the required connection information. If you select this checkbox, additional databases that do not have a configured driver are available for selection. This field only appears for DSN-less data sources.

Show databases which are not certified for the DSN's driver: If you clear this checkbox, only databases have an installed and configured driver are available for selection. You can connect to these databases by supplying the required connection information. If you select this checkbox, additional databases that do not have a configured driver are available for selection. This field only appears for DSN data sources.

Host Name: The host name for the data source. This field only appears for DSN-less data sources.

Port Number: The port number for the data source. This field only appears for DSN-less data sources.

Default Keyspace: The default keyspace, which is a top-level container for storing data. This field only appears for DSN-less data sources.

Authentication Mechanism: The type of authentication to use. This field only appears for DSN-less data sources.

Show/Hide connection string: Toggle this link to show or hide fields for viewing and editing the connection string.

Use parameterized queries: Select this check box to enable Intelligence server to pass data to the database in blocks instead of row-by-row. For information on how parameterized queries can improve performance in MicroStrategy, see the Project Design Help.

In live dashboards connected to certified gateways, as well as reports and cubes executed against a warehouse, all SQL executions containing text input from filters, search conditions, and text prompts are secured through parameterized queries. Starting in 2021 Update 4, this functionality is also extended to transaction inputs in transaction server reports and documents. See KB485174 for more information about the transaction part of this security feature and a list of certified gateways. See KB484512 for more information about the non-transaction part of this security feature and a list of certified gateways.

Edit connection string: Select this checkbox to enable the fields for editing the connection string. This field only appears for DSN-less data sources.

Driver: Select the driver. This field only appears for DSN-less data sources.

Connection String: Modify the Driver={DriverName} part of the connection string, where DriverName is the default name used for the driver. Replace the default DriverName with the name of the driver that your administrator installed for the database.

If there were any optional configuration parameters that you chose not to define, modify the connection string to remove the parameters completely from the string. These parameters are listed with an equal sign (=) followed immediately by a semicolon (;), indicating no value is provided. This field only appears for DSN-less data sources.

If the connection string includes AlternateServers=; remove this text from the connection string.

Server Name: The name of the server you are connecting to.

Database Name: The name of the database you are connecting to.

User: The name of a valid user account for the data source.

Password: The password for the data source user account.

Data Source Name: A name to identify the data source configuration in Web.

NameNode High Availability: If you are using Hadoop with High Availability enabled, select this option. Enter corresponding options for Nameservice, Gateway Host, TCP Port, HTTP Port, and Authentication mode.

Single NameNode: If you are using Hadoop, select this option to use a single NameNode. Enter the corresponding options for Hadoop Name Node, HDFS Port, Gateway Host, TCP Port, HTTP Port, and Authentication mode.

Related Topics

Create a DSN Using the Microsoft ODBC Data Source Administrator

Create a Database Connection