×

Have You Seen Workflow Lately? Click here to check out all the new features in the latest version.

Supercharge your GE solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Learn more about the Proficy 2024 releases, by signing up for one of our upcoming events.

Home
Data Administration
Data Sources
Data Sources
Workflow provides the ability to connect to external data sources to access the data contained within those applications.
GE Historian Data Source
The GE Historian data source allows you to connect to Historian servers to read from and write to Historian data tags. You add Historian tags to Workflow and then use those tags as data sources throughout Workflow.
GE Historian Synchronization Tips
The following information provides guidelines for improving the performance of your GE Historian synchronization process.

Workflow Products Documentation

Data Administration
- Data Administration Introduction
- Electronic Signatures and Audit Trails
- Data Sources
  - Data Sources
    Workflow provides the ability to connect to external data sources to access the data contained within those applications.
    - Configure a data source item for a resource
      This procedure is used to configure data source items for equipment, events, and workflows.
    - GE Historian Data Source
      The GE Historian data source allows you to connect to Historian servers to read from and write to Historian data tags. You add Historian tags to Workflow and then use those tags as data sources throughout Workflow.
      - Add a GE Historian server
        You can add an GE Historian server as a data source.
      - Change the GE Historian server
        You can connect to a new GE Historian server at any time and maintain all the links to equipment properties, condition events, and workflow data items. You retain the alias for the server but change the server address.
      - View and synchronize GE Historian tags
        You can browse the status of current tag and event details available on the GE Historian server, as well as resynchronize all server tags with client tags.
      - Remove orphaned GE Historian tags from Workflow
      - GE Historian Synchronization Tips
        The following information provides guidelines for improving the performance of your GE Historian synchronization process.
    - OPC Client Data Source
      An OPC client provides direct access to data served by OPC Data Access (DA) servers without relying on GE Historian as a bridge between an OPC server and Workflow.
    - OPC UA Client Data Source
      The OPC Unified Architecture (UA) client provides direct access to data served by OPC UA servers.
    - Database Service Providers
      The database service provider allows you to connect to data sources and retrieve or update information for SQL and ODBC statements and procedures.
    - Data Types
      Data types define the format that data is stored in and displayed as for variables, specifications, and other resources.
- Archives
- Custom Property Types
- Transferring Workflow
- Reporting

GE Historian Synchronization Tips

The following information provides guidelines for improving the performance of your GE Historian synchronization process.

Indexes on the Historian_Tag table

If the indexes are badly fragmented due to many deletes and/or inserts, which can occur if the synchronization has been attempted multiple times, the process will be slow. You can rebuild the indexes using SQL Server Management Studio as follows.

Expand the Historian_Tag table.
Right-click the Indexes folder, and then select Rebuild All.

Rebuilding the indexes should be performed before you attempt to synchronize. It should also be performed as a maintenance operation after the initial synchronization so that the table is in a good state for later synchronizations.

Memory on SQL Server: The initial synchronization is memory-intensive. The more RAM available to the SQL Server, the faster it will be. Ideally, SQL Server is on a dedicated computer. You should also ensure that SQL Server is configured with an appropriate Maximum server memory setting and not the default value, which is effectively infinite. For more information, see http://www.sqlchicken.com/2012/02/setting-memory-limits/.

SQL server recovery model

Testing has shown that if the recovery model for the SOADB is set to Simple vs. Full, database operations complete faster. However, there are other considerations with regard to data recovery that you must be aware of. For more information, see https://msdn.microsoft.com/en-us/library/ms189275.aspx.

Setting SOA to manual synchronization: A setting can be added to the ProficyServer.exe.config file that prevents automatic synchronization when Workflow Server starts. With large systems, manual mode can be used so that the synchronization process is triggered only when it is explicitly initiated.; To prevent automatic synchronization, under the <appSettings> section, add the entry <add key="HistorianManualSyncOnly" value="true" />.