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/.
|