How to create DBCPConnectionPool in Syncfusion Data Integration Platform
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.
Step 2
In the “Process Group Configuration”, Navigate to “Controller Services” tab.
Step 3
Click on “+” icon to create new controller service.
Step 4
In Add controller service window, select “DBCPConnectionPool” and click add
Step 5
In Process Group Configuration window, click on “EDIT” icon to configure the controller services.
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 JAR - https://www.oracle.com/database/technologies/jdbc-drivers-12c-downloads.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://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.18/mysql-connector-java-5.1.18.jar
| 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. | 8 |
Once after entering the required details, click Apply
Step 7
Click on the Enable button as shown below.
Step 8
After enabling “Controller Services” close the 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.
For more details, Please refer our help documentation link: https://help.syncfusion.com/data-integration/user-guide#adding-controller-services-for-dataflows
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.
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: