Traditionally, your data was only as fresh as your latest ElastiCube build. With live connections, you can refresh your dashboards manually or set them to refresh automatically every few seconds. Sisense Live Connect queries are run directly against the data source. Sisense performs no additional caching on the data.
The most significant difference between dashboards built on ElastiCubes and dashboards connected to live data sources is how the load is managed. With an ElastiCube, you refresh the data when you build an ElastiCube and query the ElastiCube, not the data sources that define your ElastiCube. With live connections, queries are run against the data source itself. This means that you don’t have to wait for an ElastiCube to finish building before you see the results, however, your data source must be able to handle the potential load of multiple refreshes.
To create dashboards built on live connections, you create live models. These data models include connection and credential details to the data sources. After you have created your live model, you publish it. Publishing the live model adds it to your list of data sources from which you can select when working with dashboards.
The following features are not supported in live connections:
- Pulse alerts
- Box & Whisker plot
- Certain analytical functions such as Mode and Standard Deviation
- Changing live data sources from dashboards
- Custom SQL tables and columns
Frequently Asked Questions
Q: I cannot connect to my data source?
A: As the connection is live, the data source must be available for Sisense to connect. Also, if your credentials changes, you must update your data set so Sisense can continue to connect and refresh the data.
Q: No data sources are displayed when trying to add one?
A: In Windows Services, verify that the following are running, and if not, restart them:
Q: If I use Windows Authentication with my SQL server, what do I enter in the Username and Password fields?
A: Enter the Location and leave the Username and Password fields blank.
Q: After entering a data set name, the Done button is not displayed:
A: Make sure the data set’s name is unique. You cannot create data sets with the same name.