This page includes the following sections:
- Method 1 - Add Single Data Source with Dialog
- Method 2 - Add Multiple Data Source with Text File
- General Notes
There are two methods of specifying data sources for analytics.
For day to day adding/removing of data sources, method 1 is simpler and easier. If you need to import a long list of data sources, method 2 may be preferable.
Click the Add Data Source button to display the following dialog.
The following source types are available:
- PowerPivot for SharePoint
- MS SSAS OLAP 2005
- MS SSAS OLAP 2008
- MS SSAS OLAP 2012
- MS SSAS OLAP 2012 Tabular
- MS SSAS OLAP 2014
- MS SSAS OLAP 2014 Tabular
- MS SSAS OLAP 2016
- MS SSAS OLAP 2016 Tabular
The name of the data source (as it will appear in BI Office).
Server Name or IP Address
One or the other (not both).
Data Source Instance Name
Instance name on the data source.
If left blank, system will use the default port.
IMPORTANT: Insert the Data Source Instance Name or the Port, but not both.
Brief description of the data source (as it will appear in BI Office).
Mash Pit (Allow users to upload data models)
This field appears for tabular type only.
This option allows you to specify a "Datasource User" for a specific server. Once you check this option and specify here a domain, user name and password, the global datasource user will no longer have access to the server.
- User Name
This box can be used to enter connection string properties.
Use this method to add multiple data sources using a text file.
Click the Import button (see red arrow below).
Click on the Download Template button to save the file to your hard disk.
Fill in the template with the appropriate values. Each row represents a single data source.
NOTE: For detailed field descriptions, see Method 1 - Add Single Data Source with Dialog.
Data Source Type
Use the following numbers below to indicate the data source.
|Data Source Type||Number|
|MS OLAP 2005||0|
|MS OLAP 2008||1|
|MS OLAP 2012||3|
|MS OLAP 2012 TABULAR||4|
|MS OLAP 2014||5|
|MS OLAP 2014 TABULAR||6|
Use a semicolon between roles. For example: Role1;Role2
Save file as a comma delimited file.
Click Upload File and browse to correct file name. The system will begin process and validate the input:
GREEN - successful
RED - failure
Click "Commit Successful Data Sources to complete the process.
After adding a new data source, you are required to assign roles to make the data source accessible to your end users.
If your data source server is separate from the other parts of your application, it is important to ensure that the environment is running within an Active Directory.
Allow Users to Upload Data Models
For tabular data sources only, you may OPTIONALLY allow users to upload data models for working in Data Modeling (MashPit).