A Carbon datasource is a RDBMS or a custom datasource created using the Datasources sub menu of the Configuration menu in the management console. You can simply use that as the datasource of a data service. A Carbon datasource is persisted, and can be used whenever required. To create a Carbon datasource, see Adding datasources .
After creating a Carbon datasource, be sure to copy the JDBC driver to:
- <PRODUCT_HOME>/repository/components/lib directory
- <PRODUCT_HOME>/repository/components/dropins
For example, cp mysql-connector-java-5.XX-bin.jar /home/user/wso2ds/wso2-dataservices-XX/repository/components/lib.
Next, simply use that datasource at the time a data service is created. Follow the steps in Creating datasources. When you select Carbon datasource as the datasource type at the time a datasource is created, you get a drop-down list from which an existing Carbon datasource can be selected. For example:
To write a query to this datasource, see Writing Data Service Queries.