Settings Tab - EnterWorks_Process_Exchange_(EPX) - 10.5

EnterWorks Process Exchange (EPX)

Product type
Software
Portfolio
Verify
Product family
EnterWorks
Product
Precisely EnterWorks > EnterWorks
Precisely EnterWorks
Precisely EnterWorks > EnterWorks Process Exchange (EPX)
Version
10.5
Language
English
Product name
Precisely EnterWorks
Title
EnterWorks Process Exchange (EPX)
Copyright
2023
First publish date
2007

The default Settings tab contains the Driver, Connection String, User ID, Password, and Database Encoding fields; the Access Type options (SQL and Stored Procedure); and the SQL Statement and Result Set fields.

If you select the Stored Procedure option, the SQL Statement field disappears and the SP Name and Parameters fields appear, along with the DataType, IO Type, and Precision lists, and the Value field.

  1. In the Driver field, type the name of the JDBC driver that the activity will use. Remember that in order to successfully use this driver, its .jar file must be copied to the proper directory, and its classpath must be referenced in the JDBCBic.config file (see "Classpath Configuration," on page 4 for more information).
  2. Type the proper connection string for the driver in the Connection String field.

    For SQL Server, the connection string can take the following format:

    jdbc:jtds:sqlserver://<db_hostname>:<port>/<database_name>;SelectMethod=cursor

    In this format, <db_hostname> is the hostname of the server, which is set to localhost by default. The <port> refers to the number the server is listening on. It defaults to the SQL Server standard port number (1433, if the default was accepted during installation). Finally, <database_name> refers to the name of the database which defaults to EPX (if the default was accepted during installation).

  3. In the User ID and Password fields, type the username and password required in order to connect to the database.
  4. If you have enabled double-byte character support (DBCS) for EPX, the Database Encoding field is editable, allowing you to change the encoding format if necessary. The default value is 8859_1.

    If you need to connect to a JDBC-compliant database that does not share this same encoding format, you must replace the default with the correct format.

    For non-DBCS EPX installations, the Database Encoding field appears dimmed and the default encoding format is not editable.

  5. Select the desired Access Type option, either SQL or Stored Procedure, and proceed to appropriate section, either "Configuring the SQL Option," below or "Configuring the Stored Procedure Option," on page 12.
  6. Save the data entered and proceed to another tab by clicking Apply. Clicking OK will also save the data entered and exit the JDBC BIC editor. To cancel saving the data entered, click Cancel.