×

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.
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.
Create a SQL database connection
You can create a basic database connection to use for configuring SQL service provider 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

Create a SQL database connection

You can create a basic database connection to use for configuring SQL service provider statements and procedures.

About this task

Note: You can have 100 database connections with a total of 500 statements.

Note: You can have 100 database connections with a total of 500 statements.

Procedure

In the navigator, click Proficy System > Proficy System > Databases > Database Connection.
Click Add Connection.
In the Name and Description fields, enter a name and description for the resource.
In the Displays panel, click Database Editor.
From the Provider drop-down list, select SQL Data Provider.
In the Connection Details section, select one of the following radio buttons.
- To fill predefined fields, click Simple.
- To enter a user-defined string, click Advanced.

If you selected...	Enter...
Simple	In the Server field, enter a server name. In the Database field, enter a database name. In the Port field, enter a port number. In the Timeout field, enter time in seconds.
Advanced	A SQL connection string for your database connection.

From the Authentication drop-down list, select SQL Server Authentication.
In the User Name field, enter a name.
In the Password field, enter a password.
Click Save.