How To: Set Dashboard Data Source Settings

As part of the analytics product, portal administrators are now able to add custom datasources which users can use to build custom dashboards.

Related Articles

• KB2575 - Index of Dashboard Articles

Adding a new Data Source

1. From the User Menu navigate to the Admin Setting page
2. On the right hand menu, click on Data Source Settings 



3. Click on “Add” button located on the task bar at the bottom of the page
4. On “Add New DataSource” popup window, Fill in the following fields:
   
   • Name (String)
     
     • Defines the key to use to access the connection string value.
   • Provider Name (String)
     
     • Defines the name of the ADO.NET provider to use to access the underlying data store. Currently this is limited to three (3) options namely:
       
       • System.Client.SqlClient
       • System.Client.EntityClient
       • System.Client.SqlServerCe.4.0
   • Connection String (String)
     
     • Defines to be the string that includes the source database name, and other parameters needed to establish the initial connection. 
   • Enabled (Boolean)
     
     • Sets whether the data source should be enabled or not

     
     

     

5. Click on Save to save changes

You may refer to the following Microsoft KB links below for more information around connection strings:

https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(v=vs.110).aspx

https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx

Editing an existing Data Source

1. Navigate through the Admin Setting page
2. Select the item you want to update by highlighting the row from the data source table



3. Click on “Edit” button located on the task bar at the bottom of the page
4. On “Edit New DataSource” popup window, modify or update desired fields.
5. Click on Save to save changes