Fetching Child Tables

Data models typically contain tables that share column data through a relationship. You can configure Publication Service or Subscription Service to include related data from another table as a child table when an adapter service publishes or subscribes to data.

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 the search criteria. 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.