Quick Start Guide
To help you get started creating custom data connectors, we have provided a working sample that you can download and play with. By design, it is a simple connector that uses a CSV file as its data source. You can extrapolate from this simple code to build a custom connector of your own.
To start using the sample in your MicroStrategy environment, follow the steps below.
- Set up the sample.
Download the zip file for the sample data connector, DataConnectorSample.zip.
- Extract the contents. The following files are included in the DataConnectorSample folder:
Copy the DataConnectorSample folder to the MicroStrategy root folder on your Tomcat web server.
In these instructions, you place the sample folder in the root directory of your web server, but you can change that to any location in the MicroStrategy Web directory.
Register the sample connector.
Use the steps outlined in Registering a Data Connector. When you configure the connector, use the following values:
Connector name Enter "Sample Connector". Connector URL Enter "http://YourWebServer/MicroStrategy/DataConnectorSample/index.html" Connector description Enter "Simple connector that uses a CSV data file". Connector introduction page This is optional and is not used in this sample. It can be used to enter a URL to a page that provides introductory information about the connector. Connector icon Navigate to DataConnectorSampleIcon.png in the DataConnectorSample folder. Credential type This information is not currently used.
- Try out the sample connector.
- Open MicroStrategy Web or Desktop.
- Navigate to Create -> New Dashboard.
- Click Add External Data.
On the Connect to Your Data page, scroll down to the new data connector you added.
Click the icon for your new connector, and the HTML page in the sample opens.
- In the textbox on the screen, enter the name of the CSV data file included in the sample (DATA_IMPORT_CSV.csv) and click Submit.
It says "Fetching Cube information" and then redirects you back to MicroStrategy Web to complete the data import process.