Fetching Tables

Each service of Publication Service or Subscription Service must be associated with a table that describes the data the service receives from or sends to the database.

You can use the following ways to fetch tables and child tables from a database destination:
  • Use the Schema Browser view.
  • Use the Schema tab of an adapter service.
  • Use the Remote Business Object tab in the Create Service Wizard window.

The following procedure describes how to fetch tables using the Schema Browser view.

For details on how to fetch tables using the Schema tab, see Specifying a Schema.

You can also fetch child tables. For more information, see Fetching Child Tables.

Prerequisites

Ensure that a destination is created in the Schema Browser view by clicking Link Connection To Schema Browser after you create an adapter connection.

Procedure

  1. In the Schema Browser view, expand the database destination from which you want to fetch a table.

  2. Right-click the table node and from the pop-up menu, click Fetch Table.

  3. In the Table name Pattern window, enter the search criteria. Click OK.
    For example, if you want to fetch a table that starts with "CUSTOMER", you can specify CUSTOMER% as the search criteria.

    Note: You can choose to fetch a set of tables at one time from a database. However, you can fetch only one stored procedure or function at each time, because a unique name must be specified for each stored procedure or function.
  4. In the Table Download Dialog window, select the table you want to fetch and click OK.

    If you want to reference an external schema, you can specify the schema name in the Other Schema field and click Add From Other Schema to load its tables. However, you must have the proper access privileges to the referenced schema. For more information, see Referencing an External Schema.
Contents
Search Results