Chapter 2. Reference

Table of Contents
2.1. Connection
2.2. Data Points
2.3. Log

2.1. Connection

These are the required and optional parameters for making a connection to a Vine Server instance, DataHub instance or SkkyHub service.

Host Name

The name or IP address of the host computer for the Vine Server instance or DataHub instance, or the IP address for the SkkyHub service.

Port

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

User Name

The user name required by the SkkyHub service, DataHub instance or Vine Server instance, if any.

Password

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

Options

Use WebSocket

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

Use SSL

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

Accept invalid certificates

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

Connect automically

Attempts to make the connection to the data source when the worksheet is opened.

Throttle updates

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.

Proxy Settings

Host Name

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

Port

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

User Name

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

Password

The corresponding password.

Security Settings

Config Password

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

For all connections

Connect button

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

Status messages

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