---
title: "Introduction to Datacube"
slug: "clone-introduction-to-the-datacube"
updated: 2025-09-26T19:30:57Z
published: 2025-09-26T19:30:57Z
canonical: "docs.foundationhub.com/clone-introduction-to-the-datacube"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.foundationhub.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Introduction to Datacube

**What is Datacube?**

Datacube is a collection of tables on the server that store the data in FoundationHub. It helps you easily access this data in a table format.

These tables include information about:

- Interested Parties
- Grantees
- Vendors
- Funds and Securities
- Transactions

**Accessing Datacube with MS Excel**

Datacube can be accessed using MS Excel.

In Excel, from the Data Menu, click on “Get Data”.

![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-LGZ44RIU.png)

From the dropdown list, select “From SQL Server Database”.

![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-07P78MPK.png)

In the dialog box, enter your Institution’s server credentials and click OK. In the next dialog box, enter your Username and Password. Please contact your Client Service Representative for help with this information.

![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-XWMFG7JO.png)

![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-9K8T56WY.png)

Now you can see a list of tables with your institution’s contacts and transactions information. From this list, select a table and click on “Load”.

![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-UVR4C69O.png)

The data in the table can now be viewed. Click on [this link](/v1/docs/clone-datacube-tables) to learn more about each table.

![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-A5UDVZV3.png)

**Linking Datacube Tables in MS Excel**

The Datacube tables can be linked to create reports. In Excel, from the Data Menu, click on “Get Data”.

![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-LGZ44RIU.png)

From the dropdown list, select “From SQL Server Database”.

![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-07P78MPK.png)

In the dialog box, enter your Institution’s server and database credentials. Please contact your Client Service Representative for help with this information.

Next, click on “Advanced options”. Using SQL statements, you can link the tables to create reports containing information which you request.

![](https://cdn.document360.io/579d62e3-92d9-438c-a119-f0014c5f7cc0/Images/Documentation/image-YXQWIZ72.png)