> For the complete documentation index, see [llms.txt](https://learn.squirrel365.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.squirrel365.io/components-functions-and-connections/overview-2/infoburst/xdc-connections.md).

# XDC Connections

{% hint style="success" %}
**Who can use this feature?**

The **XDC Connections** can be used by those with the **Builder** subscription plan.

For more details, see our [**pricing comparison matrix**](https://squirrel365.io/pricing/).
{% endhint %}

The **XDC** Connections can be used to connect the Squirrel project to an external InfoBurst database.

There are two different **XDC** connections:

* **XDC Cache** - allows a data cache to be read from an Infoburst environment to a range in the Squirrel spreadsheet.
* **XDC Cache Query -** allows a cache query to be read from an Infoburst environment table to a range in the Squirrel spreadsheet

## Common XDC Properties – Credentials

An Infoburst URL and login credentials are required to use the **XDC** connectors. These can be obtained from the Infoburst webpage, as well as the URL port.

### XDC Login Credentials

The '**Infoburst URL**' is used to access followed by a port to identify the specific environment.

After entering the URL, all that is needed is a '**Username**' and '**Password**'.

All three of the credential fields can be bound to cells in the spreadsheet.

<figure><img src="/files/YC7YMjZIoQsDtmF9Xuds" alt=""><figcaption></figcaption></figure>

***

## Mapping the connection to the spreadsheet

After connecting to the database, the **DATA MAPPING** properties will populate which is where you can define the cache or cache query to be brought into Squirrel.

***

### XDC Cache

The **XDC Cache** DATA MAPPING properties will populate a list of the existing caches within the connected database. After making a selection, the dropdown will outline the number of caches selected.

<figure><img src="/files/WKL5v76u08ZdmGJmDdLK" alt=""><figcaption></figcaption></figure>

The selected caches will populate the fields below to bind their location to the spreadsheet. The **Cache** connections will define the number of columns within the cache, and how many columns will need to be selected in the 'Binding' range.

***

### XDC Cache Query

The **XDC Cache Query** DATA MAPPING properties will populate a list of the existing cache queries within the connected database. After making a selection, the dropdown will outline the number of queries selected.

<figure><img src="/files/lB0XfJxa240JVRUeeutI" alt=""><figcaption></figcaption></figure>

The selected caches will populate the fields below to bind their location to the spreadsheet.

***

## Triggering the connection

Like most connections, the properties panel has a **USAGE** drawer that provides control of the connector's triggers.

* **Refresh on Load** - as described, the connection will trigger and the data will be brought through to the spreadsheet on the load of the project. This can be previewed in Debug and Preview modes.
* **Refresh on Interval** - defines an Interval that the connection will refresh. When selected, an input will populate where a period of seconds can be defined for the connection to refresh.
* **Refresh on Cell Changes** - sets the trigger to refresh on the change of another cell. This property utilizes **Conditional Logic**. For more information on **Conditional Logic** and its uses, see [**this article**](https://learn.squirrel365.io/getting-started/dynamic-visibility#conditional-logic).

<figure><img src="/files/2PclDPoNJiLPhCCpZyhe" alt=""><figcaption></figcaption></figure>