# 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>
