Sign in

Introducing

Ideagen Community

Introducing

Ideagen Community

Articles in this section

See more
  1. Coruson
  2. Using Coruson
  3. Galileo

Galileo Technical Overview

Alan Blair
  • Updated
Follow
Who is this article for?

 Coruson administrators or data scientists.

 Access keys for Galileo are required.

Users submit data into Coruson (such as completing audits or submitting reports) and so administrators or senior management will often require analytics to be performed. Coruson has a number of options available for retrieving data to perform analysis.

This article outlines the steps required to begin using Galileo, Ideagen's data warehouse, as part of your business intelligence, and also provides some initial steps on connecting via Microsoft PowerBI and Postman. This does not provide details on specific steps on how to perform the data analysis as these steps vary depending on the tools you use.

To make Galileo easier to learn, this article is split into 3 sections so that you can either walk through the steps in sequence or you can jump to the section relevant to what you are doing with Galileo:

  1. Introduction to Galileo
  2. Galileo Vs Other Coruson Analytic Options
  3. Further Reading

1. Introduction to Galileo

Galileo is a Coruson data warehouse. It has been designed to surface the data in ways that help to provide good performance on complex queries and expose related data in an efficient manner.

Galileo uses database views to present the data to users. Some of these views may be able to provide all the data required by a user for their reports, while others will allow complex data to be pulled from multiple locations (e.g. fetching a unique ID from one view and using it to pull associated data from another).

The analysis can be performed by connecting to Galileo and performing your queries or you can load the data into a larger database system for more extensive querying or for integration with data collated from other systems.

Important: Galileo does not provide real time data from Coruson. However, the day refreshes frequently throughout the day so that the data will feel "fresh" when performing an analysis.

2. Galileo Vs Other Coruson Analytic Options

Galileo is one of many options available for performing Coruson analysis however it is the one that is most frequently refreshed with the greatest access to data:

  Galileo Jaspersoft Javelin Data API Platform API
Refresh Frequency Continually Approx. 2-3 Time Per Day Once Per Day Approx. 2-3 Time Per Day Live Data
Coruson Data Available All Modules All Modules All Modules Reports & Documents Reporting and forms only
Connectable Tools Power BI
Postman
Excel		 Jaspersoft Only Any tool capable of injecting CSV exports Any tool capable of API queries Any tool capable of API queries
Connection Method Dedicated API Jaspersoft Web Interface Daily download in CSV form Dedicated API Dedicated API
Cost Free of Charge 1 Daily Rate Implementation Free of charge Free of Charge1 Free of Charge
Data Limit 50Gb Daily 1 No Limit No Limit No Limit 2 No Limit 2
Implementation Services None Construction of Views
Updates for New Forms
Updates for Form Changes		 None None None
Support Availability Connection
Bug Triage		 View Management Export Management Bug Triage Bug Triage
  1. Data usage limits apply. Additional data bundles can be purchased from your account manager.
  2. There is no limit to the amount of data that can be returned but poorly performing queries can lead to a query timeout.

 

3. Further Reading

Article Comments

0 comments