RDBMS datasources allow you to create a data service using a relational database as the data storage type.
You can get the Add New Data Source screen shown below on the management console by executing This topic describes how you can add RDBMS datasources to your data service. RDBMS datasources are used to service enable data from a relational database.
| Info |
|---|
Note that the instructions given here explains how to create RDBMS datasources that are specific to the data service. Alternatively, RDBMS datasources can be defined for your server using the instructions given here, which you can add to any data service as a Carbon datasource. |
Follow the steps from 1 to 3 in creating a data service using various data sources. Then to get the Add New Data Source screen shown below. Then, select RDBMS as the datasource type. It opens the , to open the RDBMS-specific options as shown below:
The options in the above window are described below:
...
Depending on the database engine, copy the relevant JDBC driver to to the <PRODUCT_HOME>/repository/components/lib directory. For example, cp mysql-connector-java-5.XX-bin.jar /home/user/wso2ds/wso2-dataservices-XX/repository/components/lib.
...