This option automatically creates a data service using a given database structure. When generating a data service, the server takes its table structure according to the structure specified in the datasource and automatically creates the SELECT, INSERT, UPDATE, and DELETE operations.
...
| Info |
|---|
The ESB profile of WSO2 EI comes with the datasource management feature, which allows users to create any RDBMS datasource or custom datasource that is used by the server to connect to databases or external data stores. See Managing Datasources in the WSO2 Administration Guide for instructions on how to use this feature. Note that these pre-defined datasources can also be added to a data service as Carbon datasources. |
Follow the steps given below.
Start the ESB profile.
Panel borderColor #542989 bgColor #ffffff borderWidth 1 Localtabgroup Localtab active true title On MacOS/Linux/CentOS Open a terminal and execute the following command:
Code Block wso2ei-6.4.0-integrator
Localtab title On Windows Go to Start Menu -> Programs -> WSO2 -> Enterprise Integrator 6.4.0 Integrator. This will open a terminal and start the ESB profile. - Access the management console:
https://localhost:9443/cabon - Sign in using
adminas the username and password. - Open the Configure tab and click Datasources.
This will open the Datasources screen. Click Add Datasource and enter the following details corresponding to the
AccountDetailsdatabase:Datasource Type RDBMS Name AccountDetails Datasource provider Leave Default selected. Database Engine MySQL Driver com.mysql.jdbc.DriverURL jdbc:mysql://localhost:3306/AccountDetailsUser Name Enter your MySQL server's username. Password Enter your MySQL server's password.
If you have not assigned a password, keep this field empty.
Tip Want to make sure that your datasource is connected to the database? Click Test Connection to find out.
- Save the datasource.
...