Galileo Technical Overview
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
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 |
- Data usage limits apply. Additional data bundles can be purchased from your account manager.
- 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
- Getting Started with Galileo
- Galileo Structure & Entity Relationship Diagrams (ERDs)
- Galileo Responses & Usage Limits
- How to Request Galileo Access
- How to Connect to Galileo Using Microsoft Power BI
- How to Build Table Relationships in Galileo using Power BI
- How to Connect to Galileo Using Postman
- How to Connect to Galileo Using Microsoft Excel