CoolaData has the ability to query data from any linked or external data sources. This functionality can be used together with Client Side Joins  to provide the capability to blend data from CoolaData’s data source and any external data sources.

Cooladata offers data integration with Amazon Redshift. Seamlessly join data sets together before enriching, analyzing and visualizing them together with all other data sources. You can query any Redshift DB by passing the connection string to CoolaData and enabling access to IPs over your Redshift.

Connect to an existing database

If you have a db in your organization which you like to query, set up the connection string to access it directly through CoolaData.

Why is this useful?

• Getting a unified view – data is collected in many systems and a unified view enables analysts to present a comprehensive picture.
• Query, visualize and share data from existing data sources – once a connection string is set, you can use CoolaData’s Analytical Document to query it by using our CQL widget.
• Join data together – use our fusion widget to join data from several data sources.
• Generate materialized views – set queries to run data aggregations and record the results in any data source we are connected to.