Setting the Partner Admin tool database connectivity

In PAT, one database configuration must be present. To open PAT, the path set to the Environment Variables in Windows must not contain any spaces in their folder names during IEC Tools setup.
Note: Before setting up in PAT, you must retrieve any update from IEC server and tools through CCSS.
  1. Access the PA tool.
  2. Select File > Database Settings.
  3. On the Database settings window, click New to display the Create new database item window.
  4. Specify the information to use when you configure the database setting and database communication channels.
    This table shows the database fields definition and default value:
    Field Definition
    Name Specify a descriptive name for this database.
    DB URL

    Specify the URL for the JDBC connection string.

    • If the database is configured with the default port number and not installed as a named instance, use this URL format:

      jdbc:sqlserver://[host]:[port number]

    • If the database is installed as a named instance, use any of these format:

      jdbc:sqlserver://[host]:[port number]\[instance name]

      jdbc:sqlserver://[host]\[instance name]
    DB Name

    Specify a database name.
    Schema

    Specify a schema to use.

    Default value is dbo.
    User Specify a case sensitive database user name to access the database.
    Password Specify a case sensitive database password for the user.
    Driver

    Specify the JDBC driver class to use. By default, this is configured as:

    com.microsoft.sqlserver.jdbc.SQLServerDriver
    Tr. Isolation

    Optionally, use this field to set up the database communication channel only. You configure the database communication settings in the Database tab in Manage > Communication.

    Select an isolation level for this transaction.

    • TRANSACTION_SERIALIZABLE

    • UNKNOWN_TRANSACTION_ISOLATION

    • TRANSACTION_NONE

    • TRANSACTION_READ_COMMITTED

    • TRANSACTION_READ_UNCOMMITTED

    • TRANSACTION_REPEATABLE_READ

    • TRANSACTION_SERIALIZABLE
  5. Click Test to verify the database connection.

    If an error occurs, click show stack trace to show the database connection log. Check your database connectivity to correct the error and click OK to proceed.

  6. Click OK to save the new settings.
  7. Click OK to finish and go back to the Database settings window.
  8. Select the database configuration from the list and click Use.

    An asterisk shows under the column Use to indicate a database in use.

  9. Close and exit.