Chapter 2. Reference

The name or IP address of the host computer for the DataHub instance, or the IP address for DataHub for Azure.

The port number on the host computer or 443 for DataHub for Azure accounts. Port 80 is standard for WebSocket connections, and 443 for SSL (see below).

The user name for the DataHub instance or DataHub for Azure.

The corresponding password. The Save button allows you to save the password with this worksheet.

This is required for connections to DataHub for Azure, and optional for a DataHub instance. It ensures that the connection is outbound-only from the DataHub Add-in. Port 80 (see above) is standard for this option when used without SSL.

Provides the option of using SSL. Port 443 (see above) is standard for this option, when used alone or with the WebSocket option, such as with DataHub for Azure.

Allows the SSL connection to be made even if the security certificate is invalid.

Causes the workbook to attempt a connection when it is opened.

Lets you control the rate (in milliseconds) at which updates come into Excel over this connection. This is helpful for reducing bandwith or system resource use. The default (0) allows updates as fast as possible.

The name or IP address of the host computer for the proxy server.

The port number on the host computer for the proxy server.

The user name required by the proxy server, if any.

The corresponding password.

Entering a password here and saving the worksheet will encrypt the DataHub Add-in configuration stored within the worksheet. Once a password is set, any user opening the worksheet would need to open this configuration panel and enter the password to establish the data connection.

Sends a request for a connection (or disconnect) according to the current configuration.

Displays the status of the connection. These all get logged, and can be viewed in the Log tab.