JDBC BIC Automatic Activity - EnterWorks_Process_Exchange_(EPX) - 10.5

EnterWorks Process Exchange (EPX)

Product type
Software
Portfolio
Verify
Product family
EnterWorks
Product
Precisely EnterWorks > EnterWorks Process Exchange (EPX)
Precisely EnterWorks
Precisely EnterWorks > EnterWorks
Version
10.5
Language
English
Product name
Precisely EnterWorks
Title
EnterWorks Process Exchange (EPX)
Copyright
2023
First publish date
2007
ft:lastEdition
2024-01-18
ft:lastPublication
2024-01-18T18:45:39.198479

The JDBC BIC provides the capability to execute a SQL query or stored procedure in EPX or EPIM database. The Java Database Connectivity (JDBC) BIC provides the ability to execute a single SQL statement or a stored procedure against a JDBC-compliant database (or against an Open Database Connectivity (ODBC)-compliant database, if a built-in JDBC driver exists for it). The JDBC BIC can also be used to connect to the Content Exchange Server RDBMS.

To configure a JDBC BIC activity correctly, you must know the name of the JDBC driver you are using, the connection string, and the user login ID and password for the JDBC-compliant database. You must also know the SQL statement that you want to use or the name of the stored procedure in the database and all of its parameters (if any). Finally, you are required to enter a name for the hash table where the results will be placed.

The JDBC BIC does not provide much control over what work item properties are created so it should be used sparingly. If the need is to retrieve data from Enable and/or to invoke a stored procedure (which should at a minimum return success/fail status), the SQL Set Properties BIC should be used instead.