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.
Follow the steps from 1 to 3 in creating a data service using various data sources to get the Add New Data Source screen shown below. Then, select RDBMS as the datasource type, to open the RDBMS-specific options as shown below:
The options in the above window are described below:
There are two types of RDBMS datasources as follows:
For the default type, connection properties such as driver class, URL and credentials must be entered as shown in the example above.
- External datasource
If you need to add a datasource supported by an external provider class such as
com.mysql.jdbc.jdbc2.optional.MysqlXADataSource, select the external option and enter the name and value of connection properties by clicking Add Property. For example,
After an external datasource is created, it can be used as a usual datasource in queries.
The database management system. In the above example, we take MySQL.
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.
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 Datasource Password.
Datasource configuration parameters
For information, see Datasource Configuration Parameters.
Dynamic user authentication
For information, see Dynamic User Authentication.
To write a query to this datasource, see Writing Data Service Queries.