Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Data Integration Connections

Data Integration Connections

FTP/SFTP Connection Rules and Guidelines

FTP/SFTP Connection Rules and Guidelines

Consider the following rules and guidelines for FTP/SFTP connections:
  • IDMC
    does not lock the target file while writing to the file. To prevent data corruption, verify that only one task writes to a target file at any given time.
  • If metadata in the local target file and remote target file are different,
    IDMC
    overwrites the metadata of the remote target file with the local target file at run time.
  • To find the row count of rows loaded into the local target file, open the job details from the
    All Jobs
    or
    My Jobs
    page.
  • In Windows, you cannot select FTP/SFTP directory on a mapped drive through the
    Browse for Directory
    dialog box. You can access a network directory by browsing My Network Places. You can also enter the directory with the following format:
    \\<server_name>\<directory_path>
    If the
    Browse for Directory
    dialog box does not display My Network Places, you might need to configure a network login for the Secure Agent service.
  • Error messages for FTP/SFTP connections might only reference FTP or SFTP. Read any error message that references FTP or SFTP as an error message for an FTP/SFTP connection.

0 COMMENTS

We’d like to hear from you!