Skip to main content Skip to complementary content

Setting up the Job

Procedure

  1. Open the Basic settings view of the tSambaConnection component by double-clicking the component and do the following.
    1. Enter the IP address of the Samba host in the host field.
    2. If user authentication is enabled in the Samba host, enter user name and password in the username and password fields.
    3. Enter the domain name in the Domain field.
      If the Samba host is not configured with a domain, leave this field empty.
  2. Open the Basic settings view of the tSambaInput component by double-clicking the component and do the following.
    1. Select Use an existing connection and select the tSambaConnection component from the Component List drop-down list.
    2. Enter the name of the shared folder set in the Samba host in the Share directory field (SmbShare in this example).
    3. Enter the path to the file which you want to insert data into in the Remote path field (/abc/customers.csv in this example).
    4. Click the Guess schema button and then click OK if the schema displayed is correct.
      You can also create the schema manually by clicking the [...] button next to Edit schema. In this case, make sure the schema conforms to the structure of the file.
    5. Select CSV from the File Type drop-down list.
      Information noteNote: Currently, the tSambaInput component supports csv files and JSON files only.
    6. Select the field separator from the Field separator type drop-down list (; in this example).
    7. Set the other options according to the configuration of your machine.
  3. Open the Basic settings view of the tFileOutputDelimited component by double-clicking the component and do the following.
    1. Enter the path to the file where the local data is stored in the File Name field (localdata.csv in this example).
      Information noteNote: Make sure the local data has the same columns as that of the file stored in the Samba host (customers.csv in this example).
    2. Make sure the field separator in the Field Separator field is the same as that set in the previous step.
    3. Select the Append option.
    4. Click Sync columns to make sure the schema is the same as that of the tSambaInput component.
    5. Leave the other options as they are.
  4. Open the Basic settings view of the tFileInputDelimited component by double-clicking the component and do the following.
    1. Click the [...] button next to Edit schema and add the same columns as those of the tFileOutputDelimited component.
    2. Enter the path to the file where the local data is stored in the File name/Stream field (localdata.csv in this example).
      Information noteNote: You can also enter the file name by placing the cursor in the File name/Stream field, pressing Ctrl + Space, and then selecting tFileOutputDelimited_1.FILE_NAME from the list that appears.
    3. Leave the other options as they are.
  5. Open the Basic settings view of the tSambaOutput component by double-clicking the component and make sure the component has the same settings as those of the tSambaInput component.
  6. Save the Job.

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 – please let us know!

Leave your feedback here