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:

Connector	More Information
Google BigQuery	Google BigQuery Live
MemSQL	Documentation
MySQL	MySQL Live
Oracle	Oracle Live
PostgreSQL	PostgreSQL Live
Redshift	Amazon Redshift Live
Snowflake	Connecting to Snowflake
SQL Server	SQL Server Live