)
We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to create DBCPConnectionPool in Syncfusion Data Integration Platform

Platform: Big Data Platform |
Control: General |
Published Date: April 24, 2017 |
Last Revised Date: November 12, 2019

This document provides steps to configure Database Connection Pooling service to access JDBC data source like SQL server, Oracle, MySQL in Data Integration Platform.

We can add controller service in two ways: 

  • Adding controller service for dataflows 
  • Adding Controller service for reporting tasks

Adding controller service for dataflows

Step 1

 Select Configuration from operate panel.

Operate Panel

Step 2

In the “Process Group Configuration”, Navigate to “Controller Services” tab.

Controller Services tab

Step 3

Click on “+” icon to create new controller service.

Add Icon

Step 4

In Add controller service window, select “DBCPConnectionPool” and click add

Add Controller Service Dialog

Step 5

In Process Group Configuration window, click on “EDIT” icon to configure the controller services.

Process Group Configuration  "EDIT” icon

Step 6

Go to “Properties” tab in “Configure Controller Service” window and give the below details to connect with different data source.

Field 

DataSource

Format 

Example 

Database Connection URL 

SQL server

jdbc:sqlserver://<ipaddress>or<hostname>:<portno>;database=<databasename> 

jdbc:sqlserver://localhost:1433;database=demo  

Oracle

jdbc:oracle:thin:@{IP address}:<portno>:{ dbname } 

jdbc:oracle:thin:@localhost:1521:demo 

MY SQL

jdbc:mysql://{IP address}:<portno>/{dbname} 

jdbc:mysql://localhost:3306/demo 

Database Driver Class Name 

SQL server

com.microsoft.sqlserver.jdbc.SQLServerDriver 

SQL server - com.microsoft.sqlserver.jdbc.SQLServerDriver 

Oracle

oracle.jdbc.driver.OracleDriver 

Oracle - oracle.jdbc.driver.OracleDriver 

MY SQL

com.mysql.jdbc.Driver 

MySQL - com.mysql.jdbc.Driver 

Database Drive Locations 

SQL server

Database driver jar file path URL.

Note:

Download the JDBC jar which is compatible with Java 8(for V2.1.0.16 and later) and give the input directory path for the jar.

Link to download SQL Server JAR -https://www.microsoft.com/en-in/download/details.aspx?id=11774

 

 

file :///c:\jdbc\sqljdbc4-3.0.jar

Oracle

Database driver jar file path URL.

Note:

Download the JDBC jar which is compatible with Java 8(for V2.1.0.16 and later) and give the input directory path for the jar

Link to download Oracle Server JARhttp://www.oracle.com/technetwork/apps-tech/jdbc-112010-090769.html

 



 file:///c: \jdbc\ojdbc6.jar

MY SQL

Database driver jar file path URL.

Note:

Download the JDBC jar which is compatible with Java 8(for V2.1.0.16 and later) and give the input directory path for the jar. 

Link to download MySQL JAR – https://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.18

 

 

file:///c:\jdbc\mysql-connector-java-5.1.18.jar

Database User    

 

Data base user name 

Username 

Password 

 

Data base Password 

***** 

Max Wait Time 

 

The maximum amount of time that the pool will wait (when there are no available connections) for a connection to be returned before failing, or -1 to wait indefinitely. 

500 millis 

Max Total Connections 

 

The maximum number of active connections that can be allocated from this pool at the same time, or negative for no limit. 

Controller Service Configuration Page 

Once after entering the required details, click Apply

Step 7

Click on the Enable button as shown below.

Enable button icon

 

 

Enable Controller Service dialog

Step 8

After enabling “Controller Services” close the Process Group Configuration dialog.

Process Group Configuration dialog 

Finally, you have created “DBCPConnectionPool” for the data source, now you can use your created DBCPConnectionPool in your processors to connect with the required data source using configure option for processor.

Processor Configuration Page

For more details, Please refer our help documentation link: https://help.syncfusion.com/data-integration/user-guide#adding-controller-services-for-dataflows 

Note:

If we create controller service for dataflows in root processor group (“Data Flow” by default), then it will be automatically inherited to the child processors groups. If we create controller service in child processor group, it will not be inherited by parent processor groups. 

 

Adding controller service for reporting tasks

To add a Controller Service for a reporting task, select Controller Settings from the Management tab. This displays the Data Integration Settings window. 

Controller Settings option  

 

If you have created any Controller services within this Global controller settings, this is used only for Reporting Tasks.  

For more details, please refer our help documentation link: 

https://help.syncfusion.com/data-integration/user-guide#adding-controller-settings-for-reporting-tasks 

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon