Skip to main content Skip to complementary content

Configuring the Job

Availability-notesubscription

Procedure

  1. Double-click the tCyberarkInput component to open its Basic settings view and:
    • Enter testAppDemo, test, root, and myTestPW in the corresponding fields (as shown in the following figure).
    • Click the Guess schema button to retrieve the schema from Cyberark.
    Information noteNote: If the guess schema operation is successful, a column named secret appears in the schema.
  2. Double-click the tFixedFlowInput component to open its Basic settings view and:
    • Click the [...] button next to Edit schema and add three columns in Schema editor: Name (type String), City (type String), and Zip (type String).
    • Click Yes when prompted to propagate the changes.
    • Select Use Inline Content and enter the content shown in the following figure in the Content field.
    • Leave the other options as they are.
  3. Double-click the tFileOutputExcel component to open its Basic settings view and:
    • Check the Write excel2007 file format (xlsx) option.
    • Specify the path to the output file in the File Name field (D:/test.xls in this scenario).
    • Check and make sure that the Define column auto size table has the same columns that are added in the schema editor in Step 2, that is, Name, City, and Zip.
      Information noteNote: You can also add the columns manually by clicking the [...] button next to Edit schema or simply clicking the Sync columns button.
    • Check the Protect file option, click the [...] button to the right of the Password field, and enter ((String)globalMap.get("tCyberarkInput_1_SECRET")) in the dialog box.
    • Leave the other options as they are.
  4. Double-click the tFileInputExcel component to open its Basic settings view and:
    • Check the Read excel2007 file format (xlsx) option.
    • Specify the path to the file to retrieve data from in the File name/Stream field (D:/test.xls in this scenario).
    • Click the [...] button next to the Password field and enter ((String)globalMap.get("tCyberarkInput_1_SECRET")) in the dialog box
    • Click the [...] button next to Edit schema and add three columns in Schema editor: Name (type String), City (type String), and Zip (type String).
    • Click Yes when prompted to propagate the changes.
    • Leave the other options as they are.
  5. Double-click the tLogRow component to open its Basic settings view and:
    • Click the [...] button next to Edit schema and make sure the same three columns as those added in the Schema editor in the previous step are listed.
      Information noteNote: You can also add the columns manually by clicking the [...] button next to Edit schema or simply clicking the Sync columns button.
    • In the Mode area, select Table (print values in cells of a table) to display the results in a table on the console.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here