Fetching Child Tables

In the Schema Browser view, you can add child tables to a table under a specific destination.

Procedure

  1. In the Schema Browser view, expand the database destination for which you want to fetch a table.
  2. Expand the table node and select a parent table.
  3. Right-click the parent table node and from the pop-up menu, click Fetch Child Table.
  4. In the Table name Pattern window, enter a search criteria and click OK.
    For example, if you want to fetch a table that starts with "ORDER_DETAILS", you can specify ORDER_DETAILS% 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.
  5. 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, the default schema must have the proper access privileges to the referenced schema. For more information, see Referencing an External Schema.
  6. To fetch more child tables, repeat Step 1 to Step 5.

What to do next

If you do not create Publication Service or Subscription Service, after you fetch a table in the Schema Browser view, you can drag the fetched table into the All Adapter Services panel to create an adapter service.

If you have created Publication Service or Subscription Service without fetching a table, after you fetch a table in the Schema Browser view, you can add this table to the adapter service by dragging the fetched table into the Schema tab.