Strategy ONE
Import Data from a URL
You can import data from a URL directly into MicroStrategy Workstation to create a document.
Your data must be in one of the following files types:
- .xlsx
- .xls
- .csv
- .json - JSON data that is available via webservices
- .txt - Text files can contain HTML tables.
- SAS date files
- OData - OData feeds are supported via anonymous authentication and should be in JSON format (details about this can be found at the OData website). MicroStrategy also supports pagination in OData feeds. The import process automatically makes calls to retrieve the paginated data and combines it into a single table.
- Create a document or open an existing one.
- Choose Data > Add Dataset.
- Click Add External Data.
- Click Data from URL.
- Enter your URL.
-
Select your connection type from the Connection List drop-down.
- Click Add to add more datasets.
- Click Finish.
- Select worksheets.
- Click Select and Save.