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.

You can use the following ways to fetch a stored procedure:

Procedure

  1. In the Schema Browser view, expand the database destination.
  2. Right-click the procedure node and from the pop-up menu, click Fetch Procedure.
  3. In the Store Procedure Download Dialog window, select the stored procedure or function you want to fetch and click OK.
    You can also specify the following options in the Procedure Schema Information panel. For details about these options, see Procedure Schema Information Reference.

What to do next

If you do not create custom RPC Service, after you fetch a stored procedure in the Schema Browser view, you can drag the fetched procedure into the All Adapter Services panel to create such an adapter service.