How to use "JDBC Call Procedure" in BW5

In some business cases, you may have to call DB - Stored Procedures inside of your Tibco Business process.

Here, I am going to explain step by step approach..

In real-time, DB team will create stored procedures and share those details with Tibco team.

For learning purpose, create a simple stored procedure in MySQL DB.

Here, the procedure "getAllEmpDetails " being called in Tibco Business process..

CREATE DEFINER=`root`@`localhost` PROCEDURE `getAllEmpDetails`()

BEGIN

    SELECT * FROM EMP;

 END

    SELECT * FROM EMP;

Next, create DB-Connection in Tibco BW

Sample Business Process:

Configure "JDBC Call Procedure" activity with proper details..as shown above

WriteToFile activity

Finally, file has been created.

Thanks for reading :-)