Query as a Web Service, comonly known as QaaWS is a connectivity option provided by SAP Business Objects. QaaWS tools provides users with an ability to create Web Services, these Web Services can be consumed from any tool or appliction which uses Web Services to fetch data.
QaaWS follows a Client Server architecture, wherein you have have a QaaWS Client tool residing on the users machine and a Server component where the actual QaaWS queries are stored
Below are step by step instructions for creation of QaaWS queries.
Before you can login in to QaaWS Client, you should have the Host details added. To do the same, click on the ‘Host’ button provided on the QaaWS login window.
The ‘Manage Hosts’ window shown below will open up,
Click on ‘Add…’ on the Manage Hosts window to add new Host details to the QaaWS client, the below “Edit a Host” window will open up. Add in the details,
Name: To Identify the Host. Name can be any name.
URL: The Web Service URL
CMS: Name of the CMS you wish to connect to
User: User details.
Authentication: This detail will be auto populated depending on the CMS you connect to and the authentication its using.
Once the Host details are added, the given host name will be visible in the drop down on the credentials window. Enter the relevant details and login to QaaWS
Once inside QaaWS, you can create a new query, or edit or delete an existing one. To create a new query for this example, click on Query > New > Query…
A Wizard window to Publish new Web Service will open up, where you can assign a name to the Web Service to be created. Add a description in the given description box
You can click, on the ‘Advanced Parameters…’ window, if you wish to modify the details related to the Web Service, like Server its pointing to – in Web Service Base URL box. Set the session time out settings and the authentication mode
To confirm the change, click ok. You will be back in the Credentials window, click Next on the Credentials window
As Step 2, the wizard window will place before you the list of available universe. To choose a Universe, on which you want to base your query
On completion of Step 2, in Step 3, all the objects from the selected Universe will be displayed. The Interface will be similar to the Web Intelligence query panel used for creation of Web Intelligence reports.
Choose the objects and set the filters, as per your Web Service design requirement
The Step 4, will allow you to preview the various components of the query. Like the Input parameters like prompts, filters etc. Output parameters will be all the objects that you want to see data for.
At the lower bottom of the window, you will be able to see a sample preview of the data to be fetched to show the correcteness of the query.
If all the details in above window are as per your expectation, then you can click on ‘Publish’ to publish the query. The query will be saved on your server, and will be visible in the available queries listings in QaaWS client
In QaaWS Client, Click on your QaaWS query in the tree node listings on the left half of window, on right you will be able to see its WSDL URL. You can use this WSDL in Xcelsius Data connections to fetch data from the Universe.