Fetching Tables and Stored Procedures

You can use the Schema Browser view to fetch tables, stored procedures, functions, and packages from a database destination.

The following figure shows the Schema Browser view with fetched tables and stored procedures.

The fetch action following a query only downloads the descriptors for various fetched objects instead of the entire object content. The descriptor contains information, such as the name of a fetched object, associated connection, columns or parameters of the fetched object, data type of the columns or parameters, and so on.

An actual object is downloaded in situations, such as service creation and schema import.

For details on how to fetch tables and stored procedures, see Fetching Tables and Fetching Stored Procedures.

  • 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.
  • Fetching Child Tables
    In the Schema Browser view, you can add child tables to a table under a specific destination.
  • Fetching Stored Procedures
    Custom RPC Service must be associated with a stored procedure or a SQL statement that describes a client request that the adapter has to execute.
  • Referencing an External Schema
    You can reference a different schema than the default schema to fetch a table. To reference an external schema, the default schema must have the proper access privileges. The privileges are set on a command line.