RDBMS

RDBMS datasources allow you to create a data service using a relational database as the data storage type.

You can get the Add New Datasource screen shown below on the management console by executing steps 1 to 3 in creating a data service. 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 Passwords.

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.