# 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="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FhvxO8Kna6oL6iXRPc39p%2FQuery_Login.png?alt=media&#x26;token=ff5da420-7409-431e-82e2-8b7620e0cb07" 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="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FYbK5mjXdZSTmZpwaNItB%2FCache_DataMapping.png?alt=media&#x26;token=6235904a-2630-4ee1-9b72-b58df634229f" 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="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FZ7TqgliqzJ2jAGD9AFch%2FQuery_DataMapping.png?alt=media&#x26;token=91cf79c9-01fb-47c5-ae4c-3080a4a96181" 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="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FlKYsDcktj3MhaN0ndMvV%2FQuery_Usage.png?alt=media&#x26;token=e13eb6f6-22a6-4e64-9145-95c05a80362b" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://learn.squirrel365.io/components-functions-and-connections/overview-2/infoburst/xdc-connections.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
