CSV Sample

Note that WSO2 EI is shipped with the following changes to what is mentioned in this documentation:

<PRODUCT_HOME>/repository/samples/ directory that includes all Data Integration samples is changed to <EI_HOME>/samples/data-services/.
<PRODUCT_HOME>/repository/samples/resources/ directory that includes all artifacts related to the Data Integration samples is changed to <EI_HOME>/samples/data-services/resources/.

Using CSV files is an easy and common way of storing simple tabular data. This sample demonstrates the usage of a CSV file as a datasource for data services in WSO2 Enterprise Integrator (WSO2 EI).

About the sample

The CSV file (Products.csv), stored in the <EI_HOME>/samples/data-services/resources/ folder, contains data about the products that are manufactured in an automobile company. Products refer to cars/motorocyles. The data table has the following columns: "ID", "Name", "Classification" and "Price". The sample data service used in this demonstration (CSVSampleService.dbs) contains a single operation named getProducts , which lists all the products that are manufactured by the company.

See Data integration for a definition of data services and operations.

Building the sample

The sample data service named CSVSampleService should be deployed using the instructions in Samples Setup.

Executing the sample

The sample service can be run using the TryIt tool, which is bundled with WSO2 EI, or a code-generated java client sample as discussed in Data Services Clients.

Follow the steps below to test this functionality using the TryIt tool:

Log in to the management console of your server and click List under Services in the navigator. The data service named CSVSampleService will be listed.
Click Try this service to open the TryIt tool.
Select the "getProducts" operation and click Send to execute the request. You will get a product list in the response as shown below.