Exposing a Carbon Datasource as a Data Service
- Former user (Deleted)
A Carbon datasource is an RDBMS or a custom datasource created using the ESB profile of WSO2 Enterprise Integrator (WSO2 EI). You can simply use that as the datasource for a data service. A Carbon datasource is persistent, and can be used whenever required.Â
Creating a Carbon datasource
See Managing Datasources for instructions on how to create a Carbon datasource. Be sure to copy the JDBC driver relevant to the database engine to one of the locations given below.
- If the driver is a JAR file, add it to theÂ
<EI_HOME>/lib directory, so that it will be converted to an OSGI bundle and copied to theÂdropins directory during server startup. For example, if you are using MySQL, you would specifyÂcom.mysql.jdbc.Driver as the driver and would copyÂmysql-connector-java-5.XX-bin.jar to this directory. - If the driver is already an OSGI bundle, you can directly add it to theÂ
<EI_HOME>/dropins directory.Â
If you do not copy the driver to the relevant directory, you will get an exception similar to "Cannot load JDBC driver class com.mysql.jdbc.Driver" when you create the datasource.
Creating a data service using the Carbon datasource
Follow the instructions in Exposing a Datasource as a Data Service and when you get to the Add New Data Source screen, select Carbon Data Source as the data source type. You get a drop-down list from which an existing Carbon data source can be selected as shown below.Â
Also, see the samples in Data Integration Samples.