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

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.