SAP Knowledge Base Article - Public

2761653 - Integration Center: Simple & Calculated File Names

Symptom

This KBA has been drafted to review the options available for Integration Center file names for simple outbound jobs

In Integration Center, we have two variations of file naming functionality available:

  • Simple File Naming
  • Calculated File Name

 

Please review the below 'Resolution' section for an in-depth review of each of these functionalities.

Environment

  • SuccessFactors BizX
  • Integration Center

 

Resolution

In the 'Destination Settings' section of Integration Center:

dest_tab.png

 

Simple File Name:

simple_file_name.png

  • Simple File naming conventions can be used for most integrations 
  • Using simple filenames, we can append date and datetime suffix, to uniquely identify files based upon each execution
    • The date time suffix can be implemented down to the millisecond level (this will suffice for most integrations)
  • For the 'File Extension' option, we can define the file extension / format the output file should use (.csv  .txt  .xml  .dat)
  • The File Folder' is a required field and is used to define the destination of the output file

   

  

Calculated File Name:

calc_file_name.png

  •  The 'Calculated File Name' functionality was introduced primarily for Attachment output
    • i.e. each output record comes in the form of an attachment and requires individual / unique filename

      

Procedure outlined in the Integration Center Guide:

    1. Go to Admin Center > Integration Center.

    2. From Integration Center landing Page, select My Integrations.

    3. From the Integration Center > My Integrations page, choose + Create More Integration Types.

    4. From the Choose Integration Type page, select the following:
      • Trigger type as Scheduled.
      • Source Type as SuccessFactors.
      • Destination Type as SFTP.
      • Format as Attachment

    5. Select Create. When you select Create button, you are directed to the Integration Center - Create a New Scheduled ATTACHMENT File Output Integration page.

    6. Select the Starting Entity.
      • Let us consider an example of selecting the Starting entity as Candidate and fetching the resume
      • PLEASE NOTE: To be compliant with data privacy laws, you cannot use attachment or photo as the starting entity. You must use the navigation properties to access any attachment.

    7. Enter the integration name and select Configure Fields tab.

    8. Go to Filter and Sort [page 56] if you want to filter for any specific Candidates.

    9. Go to Destination Settings [page 61] page to enter the SFTP details. Use Calculated File Names to generate unique file names per attachment.
      • Let us consider an example of creating a file name for Carla Grant user.
      • In the New Calculated Field Name popup, select Field Value = and associate the Operand as Candidate Id, by selecting Associate Field Entity Tree View Candidate Id.
      • Select the Operator as Concatenate/Append from the dropdown and enter the Operand as _.
      • Again select the Operator as Concatenate/Append from the dropdown and enter the Associated Field as FileName, by selecting Associate Field Entity Tree View JobsApplied Resume FileName. 
      • You can see the Calculated Value as 1_CarlaGrant.doc, where 1 is the Candidate Id and CarlaGrant.doc is the file name.
      • Click Ok

    10. Schedule the integration (if needed) and provide the frequency, start and End dates. Refer Scheduling [page 80] for more information.

    11. Go to Review and Run [page 83] and check the details. Save the integration and click Run Now to run immediately. Save and click Set Schedule to run at a specific scheduled time.

    

** ALL IMAGES HAVE BEEN TAKE FROM A LOCAL SALES DEMO SYSTEM **

    

Keywords

  • Integration Center IC
  • Complex File Name
  • Calculated File Name
  • Simple File Name
  • Attachment
, KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Core all versions