Data Model
👤 This documentation is intended for Administrators and Data Admins.
Note: Self Service Dashboards is an additional feature. Site administrators can contact their Account Manager for additional information.
This section describes data models in Sisense, how to connect to data sources, and how to avoid common mistakes when preparing the schemas.
<div>
<UL>
<LI><a href="#DataModel">Live Models</a>
</LI>
<UL>
<LI><a href="#LiveConnect">Live Connect</a></LI>
<LI><a href="#CreatingLive">Creating Live Models</a></LI>
</UL>
<LI><a href="#Navigate">Navigating the Data Page</a>
<LI><a href="#FAQ">Frequently Asked Questions</a></LI>
</UL>
</div>
<HR>
<a name="DataModel"></a>
Live Models
Self Service Dashboard support Live Models which run queries directly against the data source. Sisense performs no additional caching on the data. This provides near real-time data updates in the dashboard, though live connections rely on the source database for all queries. This means the queries are only as fast the data source.
In Sisense, Designers create live models to represent how data is brought into Sisense and how it should be used when supporting dashboards.
From the Data page, a list of all the data models can be viewed that were created by the user or that were shared with the user.
<a name="LiveConnect"></a>
<a href="#top">Back to top</a>
Live Connect
With live connections, dashboards can be refreshed manually or set them to refresh automatically every few seconds. Sisense Live Connect queries are run directly against the data source.
To create dashboards built on live connections, live models need to be created. These data models include connection and credential details to the data sources. After the live model was created it can be published. Publishing the live model adds it to the list of selectable data sources when working with dashboards.
<a name="CreatingLive"></a>
<a href="#top">Back to top</a>
Creating Live Models
A live model needs to be created before a dashboard can be analyzed.
To create a live model, first open the Self Service Dashboard tab and then click Data in the top menu. The live models are displayed here.
Click the +Live button. The Add new Live Connection dialog box is displayed. In Title, enter a name for the live model and click Save.
Next, select the desired connector.
An empty model is displayed in the Model Editor. Enter the connector credentials and click 'Next'.
Note: Below is an example of Amazon Redshift Connection. Other connectors may require different information. Details of each connector can be found in the table below.
For a short video overview of working with live data, see below.
<table style="width:100%">
<tr>
<th>Connector</th>
<th>More Information</th>
</tr>
<tr>
<td>Google BigQuery</td>
<td> <a href="https://documentation.sisense.com/latest/managing-data/connectors/bigquerylive.htm">Google BigQuery</a> </td>
</tr>
<tr>
<td>MemSQL</td>
<td> <a href="https://documentation.sisense.com/latest/managing-data/connectors/memsqllive.htm">Connecting to MemSQL Live</a> </td>
</tr>
<tr>
<td>MySQL</td>
<td> <a href="https://documentation.sisense.com/latest/managing-data/connectors/mysql-live.htm">MySQL Live</a> </td>
</tr>
<tr>
<td>Oracle</td>
<td> <a href="https://documentation.sisense.com/latest/managing-data/connectors/oracle-live.htm">Oracle Live</a> </td>
</tr>
<tr>
<td>PostgreSQL</td>
<td> <a href="https://documentation.sisense.com/latest/managing-data/connectors/postgresql-live.htm">PostgreSQL Live</a> </td>
</tr>
<tr>
<td>Redshift</td>
<td> <a href="https://documentation.sisense.com/latest/managing-data/connectors/redshift-live.htm">Amazon Redshift Live</a> </td>
</tr>
<tr>
<td>Snowflake</td>
<td><a href="https://documentation.sisense.com/latest/managing-data/connectors/snowflake-live.htm">Connecting to Snowflake</a> </td>
</tr>
<tr>
<td>SQL Server</td>
<td><a href="https://documentation.sisense.com/latest/managing-data/connectors/sqllive.htm">SQL Server Live</a> </td>
</tr>
</table>
<a name="Navigate"></a>
<a href="#top">Back to top</a>
Navigating the Data Page
The Data page contains a list of all live models the user created or that have been shared with the user.
On the right side of the page, the live models that the user recently worked on, created, or have been shared with can be found. In addition, on the left side, live models can be located using the Search field.
Each tile contains information about the status of the live model, its owner, and who it is shared with it. To open a model, click the three dots icon on the top right of the live model tile or it can manage it by clicking and selecting one of the following options:
- Duplicate: Click to create a copy of a live model. See Duplicating Data Models for more information.
- Dependencies: Click to see what entities are using the live model. Entities include drill hierarchies, dashboards, widgets (from other dashboards), and alerts.
- Delete: Click to delete a live model. If the live model does not have any entities dependent (dependencies) on it, then a popup will appear to confirm deletion. Otherwise, dependencies will need to be remapped to another data source. See Deleting ElastiCubes and Live Models for more information.
- Go to Admin: Opens the Data Source tab in the Admin page to manage live model.
- Query Settings: Manage result limits and query timeouts for live model builds.
<a name="FAQ"></a>
<a href="#top">Back to top</a>
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 credentials changes, then the data set must be updated so Sisense can continue to connect and refresh the data.
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. A data sets cannot be created with the same name.
Related Topics
<a href="#top">Back to top</a>
