Creating Live Models and Adding Live Connections
Applicable to Sisense on Linux and Microsoft Windows
Creating Live Models
Before you can analyze dashboards, you need create a live model.
To create a live model:
- Open Sisense and click Data in the top menu. Your ElastiCubes and live models are displayed.
- Click . The Add new Live Connection dialog box is displayed.
- In Title, enter a name for your live model and click Save. An empty model is displayed in the Model Editor.
Adding Live Connections
An alternative to importing data into an ElastiCube is to connect directly to the source through a live data connection. With Live Connect, queries can be processed directly in the data source. This allows you to work with only the result set from a query, rather than doing large imports from the source. You may want to leverage this method if you have invested in a high performance database or want to tap into real-time functionality.
For a short video overview of working with live data, see below.
Each live data source has its own requirements. For documentation for the relevant live data sources, see the table below:
|Google BigQuery||Connecting to Google BigQuery|
|MemSQL||Connecting to MemSQL|
|MySQL||Connecting to MySQL|
|Oracle||Connecting to Oracle|
|PostgreSQL||Connecting to PostgreSQL|
|Redshift||Connecting to Redshift|
|Snowflake||Connecting to Snowflake|
|SQL Server||Connecting to SQL Server|