Live Data Logon view

Live Data grid - Live Data Logon view

This view is used to specify connections to one or more telemetry databases.

The view is displayed by double-clicking a live data configuration object in the Model Group window, then selecting the Live Data Logon tab.

Notes:

Item Description
Left-most column

If clicked, selects the whole row.

A forward triangle indicates the current row.

An asterisk indicates where a new object can be created by entering its details (in this case, a connection name).

Fields
Connection Name

User name for the connection.

Database Type

Drop-down list of supported database types and connection methods:

  • JET
  • Oracle
  • SQL Server
  • ODBC (IT administrators, see ODBC connection information below)
  • PI
    Note: InfoWorks WS Pro requires the classic PI OLEDB provider and not the Enterprise OLEDB provider. Both providers can be installed side by side and do not interfere with each other. However, some of the functionality required byInfoWorks WS Pro is available only through the classic provider.
  • CSV (IT administrators, see CSV database connection information below)
  • iHistorian
  • ClearSCADA
  • SQL Server (ODBC)
  • JET (ACE)
  • Info360
  • PI Web API
  • Info360.com
  • Generic (Rest) – a bespoke REST API

    Note: The Generic (Rest) connector allows your company to implement a special REST API to connect to your own telemetry system. The page Implementing the Generic (Rest) API for telemetry will give suitable guidance to your IT department.
Time Zone

Leave blank if all telemetry data for this connection is in local time. This setting cannot take account of daylight saving changes to local time.

If the telemetry data for this connection is in Coordinated Universal Time (UTC), choose this option from the dropdown list. Telemetry data in UTC is not affected when local time is adjusted for daylight saving.

If the telemetry data is coming from different time zones, set the UTC minus or UTC plus time zone for each connection. Results will be coordinated.

You can return to a blank field by selecting it and pressing Delete.

Client / Driver

Enabled when Database Type is set to SQL Server or SQL Server (ODBC).

Note: Ignore the value in this field for all other database types.

Available options are:

  • SQL Server 2005
  • SQL Server 2008
  • SQL Server 2012
  • OLE DB Driver 18 for SQL Server
  • ODBC Driver 11 for SQL Server (valid only for SQL Server (ODBC) databases)
  • ODBC Driver 13 for SQL Server (valid only for SQL Server (ODBC) databases)
Net Service Name

Enabled when Database Type is set to Oracle.

The name that was used to identify this particular Oracle database instance on your PC.

Server

Enabled when Database Type is set to SQL Server, PI, iHistorian, ClearSCADA, PI Web API, or Generic (Rest).

Name of the server on which the telemetry database is stored.

For PI Web API:

This field is used for the server name, for example devdata.osisoft.com

This must be the server name only; the rest of the URL must not be entered. InfoWorks WS Pro will prepend and append characters to construct a URL of the form https://devdata.osisoft.com/piwebapi

Connection is made using HTTP/TLS. By convention, this defaults to port 443. If the server is configured to use a different port, you can enter this as part of the server name, for example devdata.osisoft.com:1234 (This method of specifying the port is widely used for http and not specific to InfoWorks WS Pro).

For Generic (Rest):

This will contain the base URL, as provided by your IT department, similar to https://MyTelemetry:3000

Database

Enabled when Database Type is set to SQL Server or PI Web API.

Name of the telemetry database.

Logon Type

Enabled when Database Type is set to SQL Server, Oracle, ODBC, PI, iHistorian, ClearSCADA or PI Web API.

Logon type can be:

  • Trusted - uses the Windows NT username and password as authentication when accessing the database
  • Username / Password - requires username and password to be entered in the grid
Username

Enabled when Database Type is set to Info360 or when Logon Type is set to Username / Password.

Username to log on to database.

Password

Enabled when Database Type is set to Info360 or when Logon Type is set to Username / Password.

Password to logon to database. The password will be displayed as asterisks in the grid view.

Command Timeout (s)

Timeout, in seconds, for obtaining values from the data feeds.

For PI Web API:

The value in this field will be used for each request made to the server. Updates of data that bring back more than 1000 data points will require multiple requests (although if there is a problem, the timeout will most likely occur on the first request and update will fail at that point).

Maximum Feed Failures ~
Creation User

Enabled when Database Type is set to Oracle or PI Web API.

Note: The text entered in the Creation User field is case sensitive.

Filename/Folder

Enabled when Database Type is set to JET, CSV, or JET (ACE).

For JET:

This is the name of the telemetry database (including the path to the database).

Tip: It is highly recommended to specify a UNC path as multi-user installations are the typical configuration. However, paths with drive letters can be used if the telemetry database is local (for demonstration purposes for example).

For CSV:

This is the location of the folder containing the CSV data files.

Connection String

Enabled when Database Type is set to ODBC or PI Web API.

For ODBC:

This parameter is required by ODBC and sets the string used to open the live data source.

For PI Web API:

A single parameter can be entered here: no_cert

This is case insensitive and must be spelt as shown. If this is used, the certificates on the server will not be validated.

Schema

Enabled when Database Type is set to ODBC.

Defines the schema to use. The schema can be:

  • typed in by the user
  • selected from a list of schemas by choosing Select schema from the context menu. See below for more details.

The schema is database dependent. (In Oracle it is the creation user, in SQL Server it is dbo or sys, and in Access there is no schema.)

Info360 URL

Enabled when Database Type is set to Info360.

This is the Info360 server URL.

If
http://demo.server/scadawatch
is the address of the Info360 server appearing in your web browser,
/api/
should be appended to the end of it in the Info360 URL field. In other words, this field should read http://demo.server/scadawatch/api/.
Main context menu options
Copy Copies the value(s) of the selected cell(s) to the clipboard. Several cells can be selected in the same row.
Test connection Tests the connection to the corresponding telemetry database.
Select schema Opens the Select Schema dialog, for choosing the schema to use from the telemetry database. Valid for ODBC database types only.
Properties

Displays the Live Data Logon Object Properties window showing the properties for a single live data.

ODBC connection information

Connection using the Microsoft ODBC Administrator program

Connection to Microsoft Azure datawarehouse

CSV database connection information