You can send and receive JSON messages by default via WSO2 Enterprise Integrator's (WSO2 EI) ESB profile. See the topics given below to understand how data can be exposed in the JSON format, and how data can be changed by sending JSON payloads. In this tutorial, you will use a data service that exposes RDBMS data.
| Tip |
|---|
|
If you have not tried the Exposing a Datasource as a Data Service tutorial previously follow the steps given below: - Download the RDBMSDataService from here.
- Download the product installer from here, and run the installer.
| Insert excerpt |
|---|
| Installing the Product |
|---|
| Installing the Product |
|---|
| nopanel | true |
|---|
|
Download the JDBC driver for MySQL from here. Unzip it, get the <MySQL_HOME>/mysql-connector-java-8.0.16.jar JAR, and place it in the <EI_HOME>/lib directory. | Note |
|---|
If the driver class does not exist in the relevant folders when you create the datasource, you will get an exception, such as 'Cannot load JDBC driver class com.mysql.jdbc.Driver'. |
Start the WSO2 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 |
|---|
sudo wso2ei-6.46.0-integrator |
|
| Localtab |
|---|
| | Go to Start Menu -> Programs -> WSO2 -> Enterprise Integrator 6.46.0 Integrator. This will open a terminal and start the ESB profile. |
|
|
- Go to product's management console:
https://localhost:9443/carbon - Enter
admin as the username and password. - Click Add > Data Service > Upload.
- Browse and add the
RDBMSDataService.dbs file you downloaded.
|
...