MicroStrategy ONE

Allowing Connections to Web Services in a Project

To connect to and report on data from a web service, you can create an XQuery database instance for the web service. The steps below describe how to create a database instance, which allows reports in a MicroStrategy project to connect to web services.

To Configure a Database Instance

  1. In MicroStrategy Developer, log in to a project source, using a user account with administrative privileges.
  2. In the Folder List, expand the project source, expand Administration, expand Configuration Managers, and then select Database Instances.
  3. Choose File > New > Database Instance.
  4. On the General tab, in the Database instance name field, enter a descriptive name for the database instance.
  5. From the Database connection type drop-down list, select XQuery.
  6. In the Database connection area, click New.
  7. In the Database connection name field, enter a descriptive name for the database connection.
  8. In the Default database login name area, click New.
  9. In the Database login field, enter a descriptive name for the database login.
  10. Choose the login option corresponding to the authentication method accepted by the web service:
    • Basic authentication with a user name and password: Enter a valid user name and password in the Login ID and Password fields. For information on how you can include this security in your report so that you can access the web services data, see Using XQuery to Retrieve Data from a Web Service.
    • Integrated authentication using Kerberos: Pass a Kerberos certificate specific to each user or a single certificate for all users to the XQuery data source. Enter any user name in the Login ID field, and leave the Password field blank. For pass-through authentication, the Use network login ID (Windows authentication) check box must be selected. For more information, see Using Kerberos to Authenticate XQuery Data Sources.
    • No required authentication: If the web service that you plan to connect to does not require a user name and password, enter any user name in the Login ID field, and leave the Password field blank. The example web service http://www.webserviceX.NET/uszip.asmx does not have any specific user name and password requirements.
    • Per query authentication: To include the login information as a part of each web service call in an XQuery report, see Using XQuery to Retrieve Data from a Web Service.

      Alternatively, you can include authentication information as part of the database connection. This allows you to request authentication tokens from a web service when a user logs in to a project, store them in variables and then call these variables in each XQuery report. For steps on how to include web service authentication information in a database connection for project-wide authentication, see Using XQuery to Retrieve Data from a Web Service.

  11. Click OK.
  12. In the Default database login name area, select the new database login that you created, and then click OK.
  13. In the Database connection area, select the new database connection that you created, and then click OK.
  14. To make the database instance available for Freeform SQL reports, right-click a project and select Project Configuration.
  15. Expand Database instances, and select SQL Data warehouses.
  16. From the list of available database instances, select the check box for the database instance that you created in the previous steps. If you are prompted to configure data mart optimization, click No.
  17. Click OK.