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 |
