You can analyze your data in MicroStrategy by accessing it through a MicroStrategy database instance. You can then import that data into a MicroStrategy project, and create facts, attributes, and metrics to analyze it.
The following steps are written for MicroStrategy 10. Simba ODBC drivers also support earlier versions of MicroStrategy. Consult the MicroStrategy Readme for your version of MicroStrategy to determine whether your database is supported as a MicroStrategy data warehouse.
Make sure that you are using the 64-bit version of your driver. MicroStrategy 10 is a 64-bit application.
To add your data to a MicroStrategy project:
- In MicroStrategy Developer, connect to the project source containing the project that you want to add your data to. For instructions on connecting to a project source, see the MicroStrategy Developer Help documentation that is provided in the application.
Make sure that you have administrative privileges for the project source.
- In the tree view, expand your project source, and then select Administration > Configuration Managers > Database Instances.
- Select File > New > Database Instance.
- In the Database Instances dialog box, in the Database Instance Name field, type a name for your new database instance.
- From the Database Connection Type drop-down list, select your database type.
- Click New.
- In the Database Connections dialog box, from the list of available database connectors, select your DSN.
- Click New.
- In the Database Logins dialog box, in the Database Login field, type a name for your new database login.
- If you are connecting to a data store that requires authentication, type your credentials in the User Name and Password fields.
- If you are connecting to a Salesforce data store that requires a security token, type your security token in the Password field after your password, with no space in between.
- If you are connecting to an Impala or Google BigQuery data store, select the Use Network ID check box. If a warning dialog box is displayed, click OK to close it.
- Click OK to save the database login and close the Database Logins dialog box.
- In the list of database logins, make sure that the new database login is selected, and then click OK to save the database connection and close the Database Connections dialog box.
- In the list of database connections, make sure that the new database connection is selected, and then click OK to save the database instance and close the Database Instances dialog box.
- Restart Intelligence Server.
- In MicroStrategy Developer, open the project that you want to add your data to. Make sure the project is selected in the tree view.
- Select Schema > Warehouse Catalog.
- In the Warehouse Catalog, do one of the following:
- If you are connecting to a new project, then from the Select Default Database Instance drop-down list, select the new database instance and click OK.
- Or, if you are adding your data to an existing project, then from the Select Database Instance drop-down list, select the new database instance.
All of the tables that are available in the project are displayed in the Tables Available area.
From the Tables Available area, select the tables that you want to add to the project. Click > to add those tables to the list of tables being used by the project.
When you are done adding tables to the project, click Save and Close. The Warehouse Catalog closes.
Data from the specified tables in your database can now be used to create facts and attributes in the MicroStrategy project.
For more information about connecting to a database in MicroStrategy, see the MicroStrategy Help documentation that is provided in the application.