XDC Connections

This article outlines the properties for both the XDC Cache and XDC Cache Query Connectors.

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.

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

To add a connector to your project open the CONNECTIONS drawer in the object browser, select the appropriate entry from the dropdown box, and click the plus button:

The connection will appear in the CONNECTIONS drawer of the object browser. Select it to access its properties in the property panel.

---

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.

---

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.

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.

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.