...
To create a datasource to connect to a database using the management console, see Creating Datasources .
Defining queries
A query is parametrized consists of parameters and it describes how to map the result to an XML element. It is similar to a function that maps some parameters to an XML element. A query's definition does not indicate how the parameters are acquired. Instead, it just lists the parameters that are needed, assuming that the parameters will be provided. If the query is at a top level (i.e., direct child of <data>) then either an operation definition or a resource definition provides the context for the parameters. If the query is nested within a <result> element, then the parameter names refer to column names of the result table described in the <result> element of the XML.
...