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

  1. In the navigator, click Proficy System > Proficy System > Databases > Database Connection.
  2. Click Add Connection.
  3. In the Name and Description fields, enter a name and description for the resource.
  4. In the Displays panel, click Database Editor.
  5. From the Provider drop-down list, select SQL Data Provider.
  6. 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.

  7. If you selected...Enter...
    Simple
    1. In the Server field, enter a server name.
    2. In the Database field, enter a database name.
    3. In the Port field, enter a port number.
    4. In the Timeout field, enter time in seconds.
    Advanced
    • A SQL connection string for your database connection.
  8. From the Authentication drop-down list, select SQL Server Authentication.
  9. In the User Name field, enter a name.
  10. In the Password field, enter a password.
  11. Click Save.