...
3. The "Create Data Service" page appears. Fill in the fields and click "Next." The Data Service name is mandatory.
| Info |
|---|
Info: |
...
| Info |
|---|
Note: Before saving, you can click on the 'Test Connection' button. If the database connection is successful, you will get the following a 'connection is successful' message: |
5. After saving, the added data source page appears. You can edit or delete the Data Source. To proceed click "Next."
6. The "Queries" page appears.
Initially your service does not include any queries. Click on 'Add New Query' to add a new query, input/output mappings, events etc. to your Data Service. Enter query details using which values will be extracted. Specify how the SQL response is mapped to output XML.
Example 1:
Query ID : customersInBostonSQL
SQL Statement : select *, from Customers where city = 'Boston' and country ='USA'
Example 2:
Query ID : customerAddressSQL
SQL Statement : select *, from Customers where contactLastName = ? and contactFirstName = ?
The following query needs two parameters for execution. The Input Mapping section is used to specify these input parameters.
To extract information you need to create a query relevant to the structure of the response. Give a name to the query, and select the data source which was created in the previous step. Specify the CQL query and parameters and click Save.
Query ID : getUsers
Data Source : CassandraDatasource
CQL : select 'key', 'username', 'password' from USER
To define how the output looks like, click the Add Output Mapping button. For example, 
Once you have entered the output mapping details, click on Main Configuration and then the Save button.
7. Once a new query is added, it will be listed as follows:
...