Using MicroStrategy

You can analyze your Spark 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. The Simba Spark ODBC Driver also supports 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.

To add your Spark data to a MicroStrategy project:

1. 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.

Note:

Make sure that you have administrative privileges for the project source.

2. In the tree view, expand your project source, and then select Administration > Configuration Managers > Database Instances.
3. Select File > New > Database Instance.
4. In the Database Instances dialog box, in the Database Instance Name field, type a name for your new database instance.
5. From the Database Connection Type drop-down list, select your database type.
6. Click New.
7. In the Database Connections dialog box, from the list of available database connectors, select your DSN.
8. Click New.
9. In the Database Logins dialog box, in the Database Login field, type a name for your new database login.
10. Click OK to save the database login and close the Database Logins dialog box.
11. 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.
12. 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.
13. Restart Intelligence Server.
14. In MicroStrategy Developer, open the project that you want to add your data to. Make sure the project is selected in the tree view.
15. Select Schema > Warehouse Catalog.
16. 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.

17. 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.
18. 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.

Related topics

• Troubleshooting