TIBCO Tutorial: How To Connect To MySQL Database In TIBCO Designer

By | February 21, 2014

While developing business processes in TIBCO BW using designer, you can connect to different types of database systems like Oracle, MS SQL, MySQL etc. to perform different types of operations in database.

In this step by step tutorial, I will explain how you can connect to MySql database in TIBCO to query data from a mysql table.

Step 1: Create MySql database table and insert Data:

We need to have some data in our MySql database table which we will query later in subsequent steps in this tutorial. I have already created a database in MySQL with the name db_test with a table tbl_employees. I have also added two records in this table as shown below:
mysql database values

 

Step 2: Configure JDBC Connection for MySQL in TIBCO BW Project:

Once we have our MySQL database up and running, we need to configure JDBC connection in our TIBCO project for MySQL database.

You need to select following values in JDBC configuration while connecting to MySQL database in TIBCO:

1. Connection Type: JDBC

2. JDBC Driver: com.mysql.jdbc.Driver

3. Database URL: Here you need to specify the Host and Port at which your MySQL database server is listening. In my case, Host is Localhost and port is 3306. We also specify database name in our database url string here.

4. User Name: MySQL database user name

5. Password: MySQL database password

 

Please note that you should have MySQL JDBC Connector Jar file present in the path tibco\tra\5.x\lib in order to connect your TIBCO application with MySQL database.

In my case, you can see in below screenshot that MySQL JDBC connector JAR file is present in this lib path:

mysql connector jar file in tra lib folder of tibco

Below screenshot shows all the fields populated for connecting to MySQL database in TIBCO:

mysql jdbc connectionc onfiguration

Step 3: Create TIBCO Process to query data from MySQL database:

Now we have data available in our MySQL database table and we have also successfully configured our MySQL JDBC connection, we are now good to go for developing a BW process in designer to query data from this table.

Below is a simple process for querying data from MySQL database. We are simply querying employee names (emp_name) from MySQL table using the connection that we configured in step 2 of this tutorial:

mysql jdbc query configuration

 

Step 4: Test process for Querying data from MySQL database in TIBCO:

After validating the process successfully, we now load the process in Designer Tester and see if it successfully connects and fetches data from MySQL database table.

As you can see below, code has run successfully and data base been queried from the MySQL table.

test results getting data from mysql database in tibco

 

 

Ajmal Abbasi

Ajmal Hussain Abbasi is a TIBCO Consultant By Profession with more than 6 years experience in TIBCO products. He has extensive practical knowledge of TIBCO Business Works, TIBCO Spotfire, TIBCO BE, EMS and TIBCO ActiveSpaces. He has worked on a number of highly critical integration projects in Telecom sector by using his skills in Tibco Designer, Adapters, TIBCO EMS, RV, Administrator, TIBCO BE, TIBCO ActiveSpaces etc. Ajmal Abbasi is also experienced in developing solutions using Oracle PL/Sql, Linux and Java. You can contact Ajmal Abbasi for Consultancy, Technical Assistance and Technical Discussions.

More Posts - Website - Facebook - LinkedIn

One thought on “TIBCO Tutorial: How To Connect To MySQL Database In TIBCO Designer

  1. Xzip

    Hey,

    Thanks for this little tutorial. Is there a way to connect to a SSL-MySQL-Database with Client-Cert + Key + CA?

    Kind regards,
    Xzip

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *