Toad allows you to connect to SAP® Business Objects through the Query as a Web Service (QaaWS) component to view and query data in QaaWS Queries.
See also, About SAP Business Objects Data Sources.
Note: This feature is available in the Toad Data Point Professional Edition only.
To create a Business Objects connection
Enter the connection information in the Create New Connection dialog. Review the following for additional information:
Enter the Business Objects URL to which you want to connect. This is the URL to the Query as a Web Service component of the Business Objects installation. See Important Information about Business Objects Connections for more information.
Note: The URL should be in the following format:
Enter the password to use when connecting.
Tip: After connecting, you can set a master password to further secure your connection in Tools | Options| Environment | Security.
|Category||(Optional) Select an existing category or create a new one. |
Note: In NoSQL and Business Intelligence connections, Toad automatically saves the password in the connections.xml file as obfuscated text, as well as in Toad. To add additional password security, use Toad's Master Password feature.
Click Connect to connect immediately while saving the connection information. Optionally, click Save to save the connection without connecting.
Upon creating an initial connection, Toad automatically maps the data source objects. This process runs in the background, and until it is finished, you may experience a delay when attempting to access these objects.
To create a Business Objects connection in Toad, you must connect to the Query as a Web Service component in Business Objects. The connection URL should have the format:
Where <server> corresponds to your web server address, and <port> corresponds to the port where you set up in your web server. (dswsbobje is the default name of the Query as a Web Service web application.)
An example URL is http://server01:8080/dswsbobje/qaawsservices.
For more information about the Business Objects component, Query as a Web Service, see the documentation at http://help.sap.com/businessobject/product_guides/xir2PP/en/qaaws.pdf.