Skip to main content
Delphix

SFTP File Masking using Absolute or Relative Path (KBA7762)

 

KBA

KBA# 7762

 

At a Glance

Summary: This page describes a new feature, available in 6.0.9.0 and newer releases, where a flag can be used to set if the SFTP should use Absolute or Retaliative Path. 
Applies to:  This applies to SFTP only and in version 6.0.9.0 and newer releases.
UI: UI: Environment > Connector >  SFTP Connector popup
  • Flag: 'User Directory as root'.
API: API: fileConnector
  • Key: "userDirIsRoot" (value:false/true) (optional)
Limitation: Not applicable to Profiling (as Data Level Profiling isn't available on File Masking).

Applicable Delphix Versions 

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.9.0

Issue

Some SFTP servers have the ability to configure a User root directory. In that case, the path entered in the SFTP Connector should be relative to that directory.

In other cases (a User root directory has not been configured) - the path should be absolute (default on openSSH based SFTP servers).

Configurations

The configuration is True or False and set through a flag:

User Directory as root Absolute/Relative Comment
False (default) The Path is Absolute. Most common and default on openSSH.
True The Path is Relative to the defined root. Use this if configured on your SFTP Server.

Example

In this example, an SFTP server has a user-root-configured-directory  '/user/customer/sftp_files' and this directory contains  a folder with a file '/masking/file1.txt'.

Absolute/Relative Example
Absolute '/user/customer/sftp_files/masking/file1.txt'
Relative '/masking/file1.txt'

User Interface

If the Path defined is relative to the Use-home-dir as configured on the SFTP Server, check the User Directory as root box.

KBA7762 Masking UI SFTP Connector - Use Directory as Root .png

API

This can also be set using the API.

  • API EndPoint: fileConnector
{
  "connectorName": "Test SFTP Connector",
  "environmentId": 2,
  "fileType": "DELIMITED",
  "connectionInfo": {
    "connectionMode": "SFTP",
    "path": "/delimited",
    "host": "yourSFTPServer",
    "loginName": "xxxxx",
    "password": "xxxxx",
    "port": 22,
    "userDirIsRoot": true
  }
}

 


Related Articles

The following articles may provide more information or related information to this article: