Skip to main content

Set up VTScada

Configure a User Account

The VTScada application must be secured with a user that has internet client access privileges. To access these settings, click the Application Configuration button from the VTScada Application Manager.

  1. image4.png

    In the Application Configuration, select Edit Security on the left.

    image6.png
  2. Select Accounts

  3. Select the user to edit.

  4. Select Add on the right.

  5. Under Page Access, choose Thin Client Access or Thin Client Monitor Access depending on the version.

  6. Under Account Control, choose Remote Data Access.

  7. Under Application Configuration, choose Remote Tag Value/History Retrieve or Tag Modify depending on the version.

  8. Click OK.

  9. Click Apply to save the changes.

Configure the ODBC Server

To retrieve historical data, the VTScada application must be configured as an ODBC server.

image3.png

In the VTS Application Manager (VAM), select the Hamburger list in the upper left and choose Thin Client/Server Setup or VTScada Internet Client/Server Setup depending on the version.

  1. image4.png

    Under the Realms tab, in the Authorization Realms section, click Add to open the Add Realm dialog.

    image5.png
  2. Specify a Name

  3. Under HTTP check Enable

  4. Set Port Number to 81.

  5. Click OK.

Under the Applications Available On ODBCRealm section,

  1. Click Add to add the application to the ODBC Realm.

    image6.png
  2. Select the Application to add.

  3. Click OK.

Select the Application Configuration image5.png button from the VTScada Application Manager

  1. Click Edit Properties.

  2. Click Advanced Mode.

  3. To add a property, click Insert.

    image8.jpeg
  4. Set the Property Name to SOAPServicesRealmName

  5. Set Value to the name specified for your ODBC Realm.

Restart the application after adding this property for the changes to take effect.

Historical Data Limitations

The number of rows returned from VTScada is limited to 10000 by default. If necessary, the SQLQueryMaxResultRows property can be changed to return more rows.

  1. In the Application Configuration, click Edit Properties. If the property does not exist, it can be added by clicking Insert.

  2. Set the Property Name to SQLQueryMaxResultRows and set Value to the desired maximum.

    image9.png

    If the property does exist and is greyed out, select it, click Copy and then change Value as needed.

ODBC Set up

  • To access VTScada history data, the VTScada ODBC driver must be installed.

  • On the machine where access is required, run VTSODBCDriverInstall.exe to install the ODBC driver. This is distributed with VTScada.

DSN

After installing the driver, an ODBC data source (DSN) can be created.

  1. From the Project Explorer, select the Tools tab

  2. Select DSN Settings to open the Microsoft ODBC Data Sources Administrator utility

  3. Select the System DSN tab

  4. Select Add

    image10.png
  5. Under Name, select VTScada ODBC Driver and click Finish. This opens the VTScada ODBC Setup dialog.

    image11.png
  6. For DSN enter a name that does NOT match the name of the VTScada application.

  7. For VTS Server, enter the fully qualified domain name of the machine running the VTS application or the IP address.

  8. The Port and SSL settings should match that was entered when configuring the ODBC Realm described in a previous section.

  9. Enter that User ID and Password of a user having internet client access privileges.

  10. Click Test Connection to test the validity of the setup. The application must be running for this to succeed.

  11. If user groups are enabled, the User ID specified must be a member of the user group that matches the VTS Realm specified to connect.