Supercharge your Proficy solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Explore our Proficy 2024 releases!

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

Workflow IPI
Get Started
Tutorials
Orientation
Configure Your Environment
Security
Resource Information and Configuration
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.
    - 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.
      - Database Connections
        You can connect to your established data sources through either a SQL connection or an ODBC connection.
      - Database Statements
        You can use statements to either update or query a database.
      - Create a SQL database connection
        You can create a basic database connection to use for configuring SQL service provider statements and procedures.
      - Configure a stored procedure for using the SQL service provider
        After creating a database connection, you can configure stored procedure for a SQL service provider.
      - Configure a database statement for a SQL service provider
        After creating a database connection, you can configure database statement for a SQL service provider.
      - Bind a return value to a DataGrid using form server methods
        To display a data table in a Silverlight form, you must bind the return value using server methods.
    - 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
Forms and User Displays
Building and Configuring Workflows
eSOP
ActiveX Task Controls
Service Interfaces
Operator Task List in the Workflow Client
Best Practices

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.