To get MicroStrategy to work with Snowflake:
- Install MicroStrategy or use an Amazon Machine Image (AMI).
- Configure the Snowflake ODBC Driver.
- OPTIONAL: Add a Snowflake customization file in MicroStrategy, so more MicroStrategy queries can execute natively in Snowflake.
Spin up a MicroStrategy AMI
Here's an AMI we used to test the Snowflake/MicroStrategy integration:
Configure the Snowflake ODBC Driver
Follow the instruction in this document to install and configure the Snowflake ODBC driver:
MicroStrategy should now work with Snowflake, but query performance is not optimal. MicroStrategy always brings a large amount of data and tries to process/compute internally, as opposed to leveraging Snowflake's native query engine.
To improve performance, obtain the SNOWFLAKE.PDS customization file, which tells MicroStrategy to push down queries to Snowflake when the request can be understood by Snowflake.
Plug In the Custom Snowflake Configuration File
1. Start MicroStrategy Developer
2. Once logged in, open Configuration Manager in the left pane:
3. Create a new Database Instance.
4. Another dialog box pops up. Give your database instance a name, then click Update button to import Snowflake database script file.
5. Click on the elliptical button on the upper right hand corner of the next dialog box:
6. Once you find the PDS file, click on the Load button, then > button to move the script file to the right penal.
At this point, the script is loaded. You can proceed and setup the database connection as you do with any other database.