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.