Configuring the Job - 7.3

CyberArk
Version
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Vault > CyberArk components
Data Quality and Preparation > Third-party systems > Vault > CyberArk components
Design and Development > Third-party systems > Vault > CyberArk components
Last publication date
2024-02-21
subscription

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.
    Note: 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.
      Note: 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.
      Note: 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.