Create SAP Business Objects Connections
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
- Click
on the Connections toolbar (ALT+F+N).
- Select SAP Business Objects from the Group list.
-
Enter the connection information in the Create New Connection dialog. Review the following for additional information:
URL 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:
http://<server>:<port>/dswsbobje/qaawsservices
Password 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.
Important Information about Business Objects Connections
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:
http://<server>:<port>/dswsbobje/qaawsservices
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.
Tips:
- To specify a default value for a column parameter, select a Query and click
.
- Read about the considerations and limitations of working with Business Objects in Toad in About SAP Business Objects Data Sources.
- Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.
- You can specify a proxy server to use for Business Intelligence and NoSQL connections at Tools | Options | Database | Data Services.