Connect to Your Data page

You can select a data source to import data from, by using the Connect to Your Data page.

It also allows you to view the Intelligent Cube quota information. When you import data into MicroStrategy Web, the data is imported as an Intelligent Cube, meaning that it will affect the overall administration and sizing considerations of Intelligent Cubes for a project. For example, once you publish an Intelligent Cube, the Intelligent Cube is stored on the Intelligence Server and takes up memory, which can impact performance. To view more details about the Intelligent Cubes, such as name and memory, and manage the Intelligent Cubes, click the memory used information. The Data Storage page opens. For descriptions of the available information and options, see Data Storage page.

Prerequisites

You must have Adobe Flash Player to import data from a file. For specific version requirements, see the MicroStrategy Readme.
You must have the Web Import Data and Web Import Database privileges.
To import data from a file by providing a URL link or a file URI scheme, your administrator must have enabled importing data from a URL link or a file URI scheme. Steps to do so are included in the System Administrator Help for MicroStrategy Developer.
To import data from Salesforce.com, your administrator must have enabled importing reports from Salesforce.com into MicroStrategy Web. Steps to do so are included in the Deploying MicroStrategy Web and Mobile Server chapter in the Installation and Configuration Guide.
Read Best practices: Importing data into MicroStrategy Web.

The All section contains separate links to import data using each data source available in MicroStrategy Web. To import data from one of the listed data sources, click the appropriate link. The following options are available:

* Depending on your MicroStrategy privileges, you may not have access to all of the data sources described listed below.
File From Disk: For steps to select and import data from a file stored on your computer or network, see Importing data from a file on your computer or network, a URL, or a file URI scheme.
File From URL: For steps to import data from a file stored at a specific URL or a file URI scheme, see Importing data from a file on your computer or network, a URL, or a file URI scheme.
Database: You can import data from a database by:
Picking relational tables. For steps, see Importing data from relational tables.
Building a SQL query. For steps, see Importing data from a database by building a SQL query.
Typing a custom database query, or Freeform script. For steps, see Importing data using a Freeform script.
Hadoop: You can import data from a Hadoop file browser by:
Browsing Hadoop files. For steps, see Importing data from a Hadoop file browser.
Picking relational tables. For steps, see Importing data from relational tables.
Building a SQL query. For steps, see Importing data from a database by building a SQL query.
Typing a custom database query, or Freeform script. For steps, see Importing data using a Freeform script.
OLAP: For steps to import data from OLAP sources, which include Microsoft Analysis Services, Cognos TM1, SAP BW, and Essbase, see Importing data from an OLAP source.
Public Data: For steps to import data by scraping a web page
Importing data by scraping a web page (public data)
Salesforce Reports: For steps, see Importing data from a Salesforce.com report.
Google Analytics: For steps, see Importing data from Google Analytics.
Google BigQuery: You can import data from Google BigQuery by:
Picking relational tables. For steps, see Importing data from Google BigQuery.
Building a SQL query. For steps, see Importing data from a database by building a SQL query.
Typing a custom database query, or Freeform script. For steps, see Importing data using a Freeform script.
Google Drive: For steps, see Importing data from a file stored on Google Drive.
Dropbox: For steps, see Importing data from a file stored on Dropbox.
Search Engine Indices: For steps to import data using a search as a source, see Importing data using a search as a source.
Clipboard: You can type or paste data directly into MicroStrategy Web, then use the data to create dashboards, documents, and reports. For example, you can copy and paste data into Web from a table on a web page or from an Excel worksheet. For steps, see Importing data by typing or pasting values directly into Web.
BI Tools: You can import data from SAP Business Objects Universe (BO), Oracle Business Intelligence Enterprise Edition (OBIEE), and IBM Cognos Framework Manager. For steps, see Importing data from a BI tool.
Facebook: For steps, see Importing data from Facebook.
Twitter: For steps, see Importing data from Twitter.
Sample Files:  If you do not have specific data to import, but still want to take advantage of MicroStrategy's business reporting capabilities, choose this option to select and import sample business data provided with MicroStrategy Web. For steps, see Importing data from a sample file.
Suggest a Data Source: If the data source that you want to use is not available, you can suggest it. For steps, see Suggesting a data source for data import.
MicroStrategy Project: You can import dashboards and data that another user has shared with you. Each dashboard is imported as a MicroStrategy dashboard file, which consists of the dashboard and one or more Intelligent Cubes that contain the data included in the dashboard. For steps, see Importing data from a MicroStrategy file.

Related topics

About importing data into MicroStrategy Web
Configuring OAuth parameters for data sources integrated using Data Import
Creating a database connection
Creating a data source connection to a search source
Creating a data source connection to an OLAP source (MDX cube source)
Creating a data source connection to a Hadoop Distributed File System