Sign in

Articles in this section

  1. Coruson
  2. Using Coruson
  3. Galileo

How to Connect to Galileo Using Microsoft Excel

Alan Blair
  • Updated
Follow
Who is this article for?

 Coruson administrators or data scientists.

 Access keys for Galileo are required.

Galileo is Ideagen's data warehouse for Coruson, which allows you to connect and perform your own analysis of your Coruson data.

This article outlines the steps required to connect to Galileo using Microsoft Excel. This does not provide details on specific steps on how to use the data and instead focuses on how to connect only.

  1. Activate the Data Tab
  2. Connect to Galileo
  3. Further Reading
Before you proceed, please ensure you have your data warehouse URL and the access keys for Galileo. For details on how to request these please visit How to Request Galileo Access.

1. Activate the Data Tab

In order to connect to Galileo via Excel you will need to activate the data tab. To do this:

  1. Launch Excel.
  2. Click File, then Options.
  3. Click on the Data tab.
  4. Activate the data options you require.

2. Connect to Galileo

To connect to Galileo:

  1. Launch Excel.
  2. Open the Data tab.
  3. Click on Get Data, then From Other Sources, and finally Blank Query.
  4. Click Advanced Editor (located in the Query section of the Home ribbon).
  5. Enter the below power query code:
let
 Source =OData.Feed("https://tenant.ideagendata.com/odata/", null,
 [
 Headers = [#"X-IdeagenDataAPIKey"= "ACCESSKEY" ]
 ])
in
    Source
  1. Update the code with your tenant and access key.

mceclip1.png

  1. Click [Done].

Once connected you can see the full list of table views available within Galileo.

Need help with Excel? Please visit the Microsoft Excel data support page.

3. Further Reading

Article Comments

0 comments