Adding a Destination

You can add destinations for multiple back-end data sources, for example, SAP and databases. Each destination represents the root of a repository, and when expanded, the destination displays a hierarchical structure representing the organization of the back-end system.

If a destination is added for a database, when expanded, the nodes for tables, stored procedures, or functions are displayed.

You can add a database destination to the Schema Browser view by launching the Application Explorer Wizard window.

Procedure

  1. Open the Schema Browser view in one of the following ways:
    • From the main menu, click Window > Show View > Other to open the Show View window. Then click TIBCO Adapters > Schema Browser and click OK.
    • Click the Browsing Schema link in the Adapter Services tab of the adapter configuration editor.

  2. Launch the Application Explorer Wizard window in one of the following ways:
    • Right-click Schema Browser, and click Add New Destination from the pop-up menu.

    • Click the Add button from the action bar of the Schema Browser view.

  3. In the Application Explorer Wizard window, select Database from the Application Type list. Click Next.
  4. In the Basic Information window, specify a display name and provide a description if necessary. Click Next.
  5. Specify the database connection details in the New Connection Information window. Click Test Connection and ensure that the information is correct.
    For details about a database connection, see New Connection Information.
    Note: To ensure that the adapter works correctly, the database connection created in the Schema Browser view has to be the same as the one you configured in the adapter configuration.
  6. Click Finish.
    A destination with the name you specified is added in the Schema Browser view and you can expand it to show top-level objects.