Integration Category: Databases

Cooladata offers data integration with Microsoft SQL Server. Both data sets can seamlessly get analyzed together with all other data sources.

 

 

Cooladata Google Cloud Storage integration enables you to upload your data files onto Google Bucket. By doing this your data files are also automatically loaded to Cooladata giving you the ability to analyze and query the data on Cooladata platform right then and there. Just upload the content of any CSV or JSON file from a Google Cloud Storage bucket into your CoolaData project. This type of integration is typically used to enrich your CoolaData events with your own data. CoolaData creates a dedicated bucket for you in Google Cloud Storage and then automatically uploads the file name and file type that you specify every hour.

To upload content into CoolaData from a Google Cloud Storage Bucket –

1. Contact your CoolaData customer success representative or write to support@CoolaData.com. Ask them to create a Google Cloud Storage bucket for you into which you can dump your CSV and JSON files to be integrated into CoolaData.
2. Upload your files into this Google Cloud Storage bucket. For example, by using the UPLOAD FILES button in the Google Cloud Platform user interface. You could also use the gsutil tool in order to automate this process. See the following link for some useful commands: https://cloud.google.com/storage/docs/gsutil

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.

 

CoolaData provides the capability to query data from linked (external) sources. This functionality can be used together with Client Side Joins, and provide the opportunity to blend data from CoolaData’s data source and external data sources.

Cooladata offers data integration with Google BigQuery. Seamlessly join data sets together before enriching, analyzing and visualizing them together with all other data sources. Query any Big Query dataset by enabling CoolaData account access. Once access is in place, direct queries to the Big Query table you wish to work on.

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.

 

 

You can query any MySQL DB by passing the connection string to CoolaData and enabling access to CoolaData IPs over your MySQL.