Set up native SQL data

Global Administrators can use Process Manager to create stored procedures. These resources are then available for use in the Native SQL Data process.

Add or edit resources for the Native SQL Data process

  1. In Process Manager, click   Admin Setup >  Native SQL.

    The Native SQL Data Admin Setup dialog opens. The two drawers list any existing resources.

  2. To edit a resource, select it. The features are described below.

Create a stored procedure

  1. In the Stored Procedure drawer, click .
  2. Type a Display name for the stored procedure (up to 100 characters). This is the name that appears in the Native SQL Data process.
  3. Select the DSN of the data source that you want to use.
  4. Type the Stored procedure name (up to 64 characters) exactly as it appears in the data source.
  5. Optionally, type a Description for the stored procedure.
  6. For the Timeout period accept the default (120 minutes) or specify your own value.
  7. In Parameters, add any values that the stored procedure requires. The data types available are text and numeric.
  8. Select I approve this Stored Procedure/SSIS Package ….