This topic describes how you can add RDBMS datasources allow you to create a your 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 . 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 :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.
| Warning |
|---|
If the driver class does not exist in the relevant folders when you create the datasource, you get an exception. For example, 'Cannot load JDBC driver class com.mysql.jdbc.Driver'. |
Use as secret alias
For information, see Securing PasswordsDatasource Password.
Datasource configuration parameters
...