Query as Web Service is an add-on feature for ETO. Contact your Account Manager if you are interested in having this feature enabled.
Downloading the Query as a web Service Designer installation files
Go to http://s3browser.com/
Click “Download S3 Browser”
Click the file to open it
Select "I accept the agreement"
Select a folder to save the Browser or choose the default option
Start the S3 Browser application
Click Accounts > Add New Account
Account Name: BO_Client_Tools
Account Type: Amazon S3 Storage
Access Key ID: AKIAI2U7HMBHBQWBCXSQ
Secret Access Key: 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
Click Add new account
Click Buckets > Add External Bucket (Ctrl+E)
Enter “ssg-business-objects-client-tools” (without quotation marks)
Click Add External Bucket
Open the bucket in the explorer on the left side of the window
Right-click on the zipped folder: BI42_SP4_Client_Tools.zip
Save to your Documents folder
Installing the Query as a Web Service Designer tool
Once downloaded, open the zipped folder and extract the files to your Documents folder
Open the folder called “SBOP_BI_PLAT_4.2_SP4_CLNT_WIN_”
Open the DATA_UNITS folder
Open the BusinessObjectsClient folder
Double-click the setup application and work through the setup steps
Logging into the QaaWS Designer application
Login to ETO software
Click on your name in the upper right-hand corner of ETO and click Live Office Account Info. Note your User Name, Password, and Server information to be used in the following steps.
Open the Query as a Web Service Designer application
Click Host and Add
In the Name field: Your discretion, recommend using your database name (e.g. etoclient123) or user name
In the URL field: delete the text that is autogenerated after tabbing out of the name field. Open the Query as a Web Service (QaaWS) End Point URLs help article and locate the URL in the section titled “The End Point URLs for each Cluster” that matches the server in your live office account information. Paste this URL into the URL field.Punctuation and capital letters are important for our purposes.
In the CMS field: Copy and paste from “Server” in Live Office Account Info
In the User field: Copy and paste from User Name in Live Office Account Info and ensure no trailing spaces
If you receive a yellow warning indicator next to URL, click back into that field and wait for the warning to clear. If it does not, ensure that all the login information is correct, including the case of the letters in the URL.
Authentication will turn to “Enterprise”
Select the host record you just created in the drop-down
Ensure the proper system and username were populated
Copy and paste your password from the Live Office Account Info in ETO (ensure no trailing spaces)
Click OK to login
Using the QaaWS Designer application
Select Query > New > Query
WebServiceName = title of your query
Select the required Standard or Custom Report Universe from the list (includes all universes you have access to in ETO Results)
Drag the necessary output objects into the Results Objects box like you would in ETO Results
Drag any required filter objects into the Filter Objects box
Review the sample (first 50 rows) output for accuracy
Note the query’s unique URL
Using the WSDL Generator
Open the WSDL generator link for your ETO environment (found in the Query as a Web Service (QaaWS) End Point URLs article)
Login to ETO software
Click on your name in the upper right-hand corner of ETO and click Live Office Account Info
Copy your User Name, Password, and Server > CMS into the fields in the WSDL generator login page. Ensure you copy no trailing spaces into those fields.
Hit Go to login
This page will contain wsdl links to the XML that can be utilized to access the queries externally.
The output of the WSDL generator will be XML that can be executed by code external to ETO to generate the output of your queries and used with other systems. This tool has been used to produce ETO data sets that are then sent to data warehouses and external funder databases. Social Solutions can help you troubleshoot issues with your queries and any XML parser issues from the XML that is generated, but will be unable to support the code that you insert the XML into.
For additional questions regarding Query as a Web Service, please contact customer support at:(866) 732-3560 ext. 2 or firstname.lastname@example.org.