Managing data source connections » Creating a database connection

Creating a database connection

When you import data from a relational data source, you must establish communication between MicroStrategy and your data source. To establish communication, you create an database connection, which enables MicroStrategy Web to retrieve data from your data source.

Relational data sources include Google BigQuery, Hadoop, and Teradata, among others.

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.
If you plan to connect to a data source using a DSN, the DSN must be created and available. If a DSN is not available, you can use the DSNLess Connection option to connect to your data source.

To create a new database connection

1 On any page, click Create on the icon bar on the left, and then select Access External Data.
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 the type of connection to your database, as follows:
To connect directly to a data source, complete the following steps:
a Select DSNless Connections.
b From the Database and Version drop-down lists, select your database and version.
c Define the database connection by providing the appropriate details for the type of connection to create, such as 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.

If you are connecting to a Teradata database, you can enable Teradata Parallel Transporter to retrieve large amounts of data.
d If you clear the Show databases whose drivers were not found check box, 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 the Show databases whose drivers were not found check box, additional databases that do not have a configured driver are available for selection. For steps to connect to these databases, see Creating DSNLess database connections that support third-party drivers.
To connect to a data source using a DSN, complete the following steps:
a Select DSN Connections.
b From the DSN drop-down list. select the DSN of the database to connect to.
c Select the appropriate database management system (DBMS) from the DBMS drop-down list.
7 Type a user name and password with access to the database in the User and Password fields.
8 Type a name for the database connection in the Data Source Name field.
9 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.
10 Click OK to create the connection.

Related topics

Editing, deleting, renaming, or duplicating a database connection
Creating DSNLess database connections that support third-party drivers