Fetching Tables
Each service of Publication Service or Subscription Service must be associated with a table that describes data the service receives from or sends to the database.
- Use the Schema Browser view. This way is used in the following procedure.
- Use the Schema tab of an adapter service. For details, see Fetching a Table After Creating Publication Service and Fetching a Table After Creating Subscription Service.
- Use the Remote Business Object tab in the Create Service Wizard window. For details, see Fetching a Table When Creating Publication Service and Fetching a Table When Creating Subscription Service.
Prerequisites
Ensure that a destination is created in the Schema Browser view by clicking the Link Connection To Schema Browser link after you create an adapter connection.
Procedure
- In the Schema Browser view, expand the database destination from which you want to fetch a table.
- Right-click the table node and from the pop-up menu, click Fetch Table.
-
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 "CUSTOMER", you can specify CUSTOMER% as the search criteria.
-
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.
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.