Managing data source connections » Creating DSNLess database connections that support third-party drivers

Creating DSNLess database connections that support third-party drivers

You can import data into MicroStrategy databases that are not packaged with a MicroStrategy-branded driver. One way to connect to these databases is to use an existing DSN for the database when you create a database connection. If a DSN is not available, you can create a direct connection to the database. When creating a direct connection to these types of databases, you must ensure that Web can locate the correct driver for the database. The steps below show you how to provide the required configuration information and update the driver name to support connections to these databases.

Prerequisites

You must have the "Create and Edit Database Instances and Connections" and "Create and Edit Database Logins" privileges to define a new database connection.
An administrator must install the driver for your data source. Steps to install drivers for your data source are provided in the Installation and Configuration Guide. For the steps below, you need the name of the driver that is installed for your data source.

To create a new database connection

1 On any page, click Create on the icon bar on the left, then select Access External Data. Click Database. The Select Import Options dialog box opens.
2 Do one of the following:
To import data from Google BigQuery, complete the following steps:
a Click Google BigQuery.
b If you are not logged into your Google account, sign in using your Google user name and password.
c If a message is displayed asking you to allow MicroStrategy to access your Google BigQuery data, select Allow Access.
To import data from Hadoop, click Hadoop.
To import data from any available data source connection, click Database.

The Select Import Options dialog box opens.

3 Select one of the following:
To select single or multiple tables to import data from, select Pick Tables.
To use a graphical interface to build the SQL query to use to import your data, select Build a Query.
To manually type or paste a query to import your data, select Type a Query.
4 Click OK. The Import from Tables page opens.
5 From the Data Sources panel, click Add. The Data Source dialog box opens.
6 Select DSNLess Connections.
7 Ensure that the Show databases whose drivers were not found check box is selected.
8 From the Database and Version drop-down lists, select your database and version. Configuration requirements for the selected database are displayed.
9 Click Show connection string.
10 Type the value for each configuration requirement listed. Depending on the database that you are connecting to, this includes the server name, port number, and database name. For a detailed list of the information required for each database type, see the Installation and Configuration Guide.
11 Select the Edit connection string check box. You can now edit the connection string.
12 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.
13 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. For example, if the connection string includes AlternateServers=; remove this text from the connection string.
14 Type a user name and password with access to the database in the User and Password fields.
15 Type a name for the database connection in the Data Source Name field.
16 Do one of the following:
To allow other users to import data using the database connection, select the Share this connection with everybody check box.
To deny other users the ability to import data using the database connection, clear the Share this connection with everybody check box.
17 Click OK to create the connection.

Related topics

Creating a database connection
Editing, deleting, renaming, or duplicating a database connection