Page Comparison

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.  

...

1. 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.46.0-integrator Localtab title On Windows Go to Start Menu -> Programs -> WSO2 -> Enterprise Integrator 6.46.0 Integrator. This will open a terminal and start the ESB profile.

2. Access the management console: https://localhost:9443/cabon
3. Sign in using admin as the username and password.
4. Open the Configure tab and click Datasources.
   This will open the Datasources screen.

5. Click Add Datasource and enter the following details corresponding to the AccountDetails database:

   Datasource Type	RDBMS
   Name	AccountDetails
   Datasource provider	Leave Default selected.
   Database Engine	MySQL
   Driver	com.mysql.jdbc.Driver
   URL	jdbc:mysql://localhost:3306/AccountDetails
   User 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.

6. Save the datasource.

...