Toad Data Point 5.0 - User Guide

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

  1. Click on the Connections toolbar (ALT+F+N).
  2. Select SAP Business Objects from the Group list.
  3. 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. See Set Connection Categories for more information.

    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. See Security Options for more information.

  4. Click Connect to connect immediately while saving the connection information. Optionally, click Save to save the connection without connecting.

  5. 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.

 

  

Related Topics

Documentos relacionados