[+]
[-]
 [+]
 [+]
 [-]
   
   
   
   
   
   
   
   
   
   
Updated on 6/10/2019
Commissions Data Loader Publication
Perform an Outbound Transfer
Direct link to topic in this publication:

PREVIOUS  |  NEXT

Perform an Outbound Transfer

Quick Links

Pre-requisites

Custom file type should be defined as per the Outbound File Type Settings.

Steps

Perform the following steps to extract data from Commissions:

  1. Define the corresponding outbound file type in Outbound File Type Settings.
  2. Create a custom HANA table. This will be the source for the outbound data.
  3. Create a custom HANA stored procedure and define the extraction logic within the custom stored procedure. This will populate the custom table. For the outbound process, you must have the stored procedure with the OUT parameter of type VARCHAR as the FIRST parameter.

    Example: Without Parameters

    CREATE PROCEDURE TMP_STAGEPARTICIPANT_NEWSP_NOINPARAMS (OUT FILENAME varchar(120))

    AS
    BEGIN
    ....
    END;



    Example: With Parameters

    CREATE PROCEDURE TMP_STAGEPARTICIPANT_NEWSP_WITHINPARAMS (OUT FILENAME varchar(120), IN batchName VARCHAR(255))

    AS
    BEGIN
    ....
    END;
  4. To run the outbound file type, drop a trigger file in the inbound folder of the SFTP Dropbox. The trigger file should have the same file type that is defined in the outbound file type settings. Optionally, you can pass parameters separated by a comma in the trigger file. All parameters are passed in the same order to the HANA stored procedure. The trigger file initiates the outbound extract job and upon completion, an outbound extract is generated in the outbound folder of the dropbox.

Note:  The OUT parameter is a mandatory parameter. It is used by CDL to create the file with the name specified in the OUT parameter. Ensure this field is populated when creating outbound extracts.  





Related Topics