RDBMS

This topic describes how you can add RDBMS datasources to your data service. This allows you to service enable data from a relational database for your data service. 

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. It opens the RDBMS-specific options as shown below: 

The options in the above window are described below:

datasource type

There are two types of RDBMS datasources as follows:

• Default
  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.
  

Database engine

The database management system. In the above example, we take MySQL.

Driver class/URL

Depending on the database engine, copy the relevant JDBC driver to <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.

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.