Applicable to Sisense on Microsoft Windows
After you have downloaded the relevant Vertical Zip files, you should extract their contents to your local machine. At least two files are included in each Vertical Zip file you can download, an Ecdata file (.ecdata) and a Dashboard file (.dash).
You import these files into your ElastiCube Manager and Sisense Web Application and then redefine the data sources replacing them with your own internal data sources.
Once you have replaced the data sources and refreshed the dashboard, the predefined widgets are displayed with your data source’s results.
The following steps describe the process of importing the Vertical files into the ElastiCube Manager and Sisense Web Application and replacing the data sources with your own.
Importing ElastiCube Data
Sisense dashboards are based on data they query from ElastiCubes. ElastiCubes data is stored in a compressed file called an Ecdata file. The file contains all of the information contained in an ElastiCubeData folder (including the source data), and is used by the Sisense Server Console to build a new ElastiCube.
To support your dashboard, the Ecdata needs to be imported into the ElastiCube Manager. In later steps, you will replace this data with your own and refresh the dashboard to reflect your data.
To import data:
- In the ElastiCube Manager, open the Sisense Server Console.
- Click on the import ECDATA file icon .
- Select the location of the ECDATA file and click Open.
- A window will appear showing the import progress. Once complete, the new ElastiCubes will be added to the list of existing ElastiCubes. Make sure the ElastiCube is running before accessing it.
Note: You can also transfer data by copying the folder where Sisense stores the data locally, instead of exporting and importing the compressed file. To learn more, click here.
Importing a Dashboard
After you have imported the relevant Ecdata files for the Vertical you are interested in, you can import the dashboard included in the Vertical ZIP file. The Dashboard file (.dash) contains a predefined dashboard which queries the ElastiCube imported in the previous step. You can view the dashboard as it is, but the data will only be relevant for your use case after you change the data source in later steps.
To import a dashboard:
- In the ElastiCube Manager Server Console, select the relevant ElastiCube and click Edit.
- In the ElastiCube Manager, select Dashboard.
- The Sisense Web Application is opened and the New Dashboard window is displayed.
- Click Create.
- Hover over the Dashboards list in the home page and click the ‘+’ symbol. Select Import Dashboard from the menu. You can also right-click anywhere in the Dashboards list, or click on the menu of one of your existing folders to import a dashboard into a folder.
- Select your exported .dash file. The dashboard will be added to your list. You can drag it from there to your desired location in the tree. The Dashboard is displayed with Sisense’s predefined widgets and data.
Changing Connectivity Settings for Data Sources
Once you have imported the .dashboard file, the data source that is queried by the dashboard needs to be updated with your data. Through the ElastiCube Manager you can replace the predefined Sisense data sources with your data sources.
When the dashboard queries your data source it expects the data to be in the same format as the original data source. The data source name, fields and field types must remain the same for existing widgets in the dashboard to be able to reference the data correctly. This means that while you can provide your own data, it must be included in tables using the same naming as Sisense defined in the original ElastiCube. For example, in the table below, customer, there are five columns. Each column must maintain the same name, however, you should replace the values of each column with your own.
After replacing your data source, you can refresh the dashboard to reflect your data.
To change data sources:
- In the ElastiCube Manager, click ElastiCube > Change Connectivity Settings…
- A list of all existing data sources and associated data tables is displayed.
- Hover over the data source to reveal the following options:
- Change Source Provider: When you change the source provider, you change the type of data source currently defined. Click to select a data source connection type, for example, change SQL Server to an Oracle database. You will then be prompted to define the connection to the new data source. When done, click Close.
- Change Source Database: When you change the source database, you maintain the same data source type while providing your data. Click to edit the login details to the database as well as connections to associated tables. In case your data source is a file like Excel, select the Excel and click Close when complete.
- Refresh your dashboard to view your information inside Sisense’s predefined visualizations.