As listed in the features section, Reveal provides you with the opportunity to connect to different enterprise data sources to retrieve information. While there are no changes to be made on the server side, you will need to configure the Data Sources within Reveal to access the data. You can choose from any of the following options:
Analytics tools (Google Analytics, Hubspot).
Content Managers and Cloud Services (Box, Dropbox, Google Drive, OneDrive and SharePoint Online).
Customer Relationship Managers (Microsoft Dynamics CRM On-Premises and Online, Quickbooks)
Databases (Microsoft SQL Server, Microsoft Analysis Services Server, Microsoft Azure Analysis Services, MySQL, PostgreSQL, Oracle, Sybase) *
Other Data Sources (OData Feed, Web Resources, JSON files)
If you open an existing dashboard and have not yet added the Data Source credentials, you will see a message similar to the following one:
When you select any of the data sources, you will see a new dialog pop up prompting you to enter details for your data source. You will see one of two screens:
When using a web-based cloud, you will see a web login dialog.
When using any other provider, you will be prompted to add an account.
If you add a data source which is not web-based, you will see the following dialog:
You can either enter new credentials for your data source, select the "No Account" option (data sources which do not require authentication), or select an existing one if applicable. In order to create a new account, select the + button in the top-right hand corner.
You will need to provide the following details:
Name: the name for your data source account. It will be displayed in the list of accounts in the previous dialog.
(Optional) Domain: the name of the domain, if applicable.
Username: the user account for the data source.
Password: the password for the data source.
Once ready, select Create Account. You can verify whether the account is reaching the data source or not by selecting Test Connection. Then, select Done. You will then be able to see your dashboard displayed in Reveal.
