With the Administration application, you can configure CIMPLICITY Logger as a Proficy Portal historical data source by opening the Historical folder and selecting the CIMPLICITY HMI Logger node. The Administration application displays the following fields:
See the following for detailed procedures:
To add a CIMPLICITY HMI Logger connector using the MSDE/CIMPLICITY SQL driver | To add a CIMPLICITY HMI Logger connector using a non-MSDE/CIMPLICITY SQL driver
If the data source you are adding is not for an MSDE or CIMPLICITY SQL database (for example, the data source is MS SQL Server or Oracle), refer to To add a CIMPLICITY HMI Logger connector using a non-MSDE/CIMPLICITY SQL driver.
In the Proficy Portal client application, click the Administration button on the main toolbar. The Administration application appears.
Click the Connectors & Data Sources button. A directory tree appears.
Expand the Historical folder and click the CIMPLICITY HMI Logger node in this folder. The Add New CIMPLICITY HMI Logger Data Source window appears.
In the Logical Name field, enter the name of the data source.
Select the MSDE or CIMPLICITY SQL option.
In the Database Computer Name field, enter the host name of the computer that the database is running on.
In the User Name field, enter the user name that is required to connect to the database.
In the Password field, enter the password needed to connect to the database.
Select the Database Time Zone of the CIMPLICITY projects that are logging into the database.
If your CIMPLICITY database logging has been configured to store the timestamp milliseconds in a separate "msec" column, select the Has "msec" Column check box.
If you selected the Has "msec" Column check box, enter the column name in the "msec" Column Name field.
Click the Apply button to save your changes. The Test, Copy, Remove, and Reset Browse Cache buttons appear.
Click the Test button to see if your connection is functioning properly. You will receive a message that the data source test passed or that it failed. If the test passed, you are ready to retrieve data. If the test failed, refer to Verifying a CIMPLICITY Logger Connection.
This procedure applies to data sources such as MS SQL Server, Oracle, or DB2. If the data source you are adding is for an MSDE or CIMPLICITY SQL database, refer to To add a CIMPLICITY HMI Logger connector using the MSDE/CIMPLICITY SQL driver.
In the Proficy Portal client application, click the Administration button on the main toolbar. The Administration application appears.
Click the Connectors & Data Sources button. A directory tree appears.
Expand the Historical folder and click the CIMPLICITY HMI Logger node in this folder. The Add New CIMPLICITY HMI Logger Data Source window appears.
In the Logical Name field, enter the name of the data source.
Select the Advanced option.
From the Driver list, select the driver name. The URL Syntax and Example URL fields are filled in automatically (from the JDBC Configuration Utility).
In the User Name field, enter the user name you will connect to the database with.
In the Password field, enter the password you will connect to the database with.
In the Database URL field, enter the URL of the database you are connecting to. You can use the URL Syntax and Example URL fields to help you determine the URL.
Select the Database Time Zone for the CIMPLICITYserver.
If the CIMPLICITY database returns a msec column, select the Has "msec" Column check box and enter the column's name.
Click the Apply button to save your changes. The Test, Copy, Remove, and Reset Browse Cache buttons appear.
Click the Test button to see if your connection is functioning properly. You will receive a message that the data source test passed or that it failed. If the test passed, you are ready to retrieve data. If the test failed, refer to Verifying a CIMPLICITY Logger Connection.
