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 dataflowsStep 1Select Configuration from operate panel.
Step 2In the “Process Group Configuration”, Navigate to “Controller Services” tab.
Step 3Click on “+” icon to create new controller service. Step 4In Add controller service window, select “DBCPConnectionPool” and click add
Step 5In Process Group Configuration window, click on “EDIT” icon to configure the controller services.
Step 6Go to “Properties” tab in “Configure Controller Service” window and give the below details to connect with different data source.
Once after entering the required details, click Apply Step 7Click on the Enable button as shown below.
Step 8After 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 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 tasksTo 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:
|
This page will automatically be redirected to the sign-in page in 10 seconds.