MicroStrategy ONE

Use the Alchemer Connector

Starting in MicroStrategy ONE Update 12, you can use the Alchemer connector as part of the new data import experience. If you are using a version earlier than MicroStrategy ONE Update 12, see Use the Alchemer Connector Before MicroStrategy ONE Update 12.

Check out the following topics to get started:

Configure Parameters for Alchemer in Old Data Import

  1. Find Alchemer and click Edit Connector

  2. Sign in using Connector URL, Client ID, and Client Secret.

  3. Click Save.

Import Data from Alchemer

Once you configure the required parameters, you can start importing data. This feature is only available when the new data import experience is enabled.

  1. Choose Alchemer from the Services drop-down.

  2. Sign in to your Alchemer (SurveyGizmo) account.

  3. Choose a Survey to import and click Submit.

  4. If necessary, click Prepare Data to view the sample data and adjust column types.
  5. Publish the cube to MicroStrategy.

Use the Alchemer Connector Before MicroStrategy Update 12

SurveyGizmo has been renamed to Alchemer.

To use the Alchemer connector with MicroStrategy Web, your administrator must perform the steps detailed in the Configure the Alchemer Connector topic of the MicroStrategy Web Administration Help.

  1. Open a new or existing dashboard.
  2. Choose Add Data > New Data.
  3. Click the Alchemer connector icon from the data source list. You are redirected to your Alchemer login page.
  4. Log in and grant the connector application permission to connect to your data.

    You only need to grant the connector application permission when launching the Alchemer connector for the first time.

  5. Upon successful authorization, you are redirected to a data import page displaying a list of your surveys.

  6. Select a survey to import.
  7. Click Data Preview to preview the questions in the survey.

  8. Click Submit. A preview of your imported data appears.
  9. On the Preview dialog, wrangle your data and click Finish.