AX 2012 AX 2009 and Secure FTP / SFTP Integration AX2012 AX2009

This post demonstrates how to integrate AX 2009/2012 with Secure FTP.

I have used the WINSCP tool to achieve SFTP file read and write

Steps overview:-
    1. Download WINSCP and Place it in proper folder (For instance folder name is WINSCP)
    2. Give AOS service account full permission to the WINSCP folder (this is required when you run it in Batch)
    3. Run/Configure WINSCP.exe, - This is a mandatory setup
    4. Copy the host key - this key is used in X++ to call the SFTP
    5. Create a bat and script file for execution inside WINSCP folder - You can handle this in X++ code
    6. You can use the same folder to download/upload the file

Below code used to get the file from SFTP

static void SFTP_GETFILES(Args _args)
{
    TextIo                  textIoFile;
    Set                     permissionSet;
    FileName                filePath, batchFileName, scriptFileName;
    InteropPermission       interopPerm;

    System.Diagnostics.Process              process;
    System.Diagnostics.ProcessStartInfo     processStartInfo;
    System.Exception ex;
    ;
    filePath = 'C:\\WINSCP\\'; //WINSCP folder

    batchFileName = filePath + 'readfile.bat';
    scriptFileName = filePath + 'readfileScript.txt';

    try
    {
 
        //Creating BAT File
        permissionSet = new Set(Types::Class);
        permissionSet.add(new FileIoPermission(batchFileName, "W"));
        CodeAccessPermission::assertMultiple(permissionSet);
        textIoFile = new TextIo(batchFileName , "W", 0);
        CodeAccessPermission::revertAssert();
        textIoFile.write(strFmt('winscp.com /script=%1',scriptFileName));
        textIoFile = null;
     

        //Creating SCRIPT File
        permissionSet = new Set(Types::Class);
        permissionSet.add(new FileIoPermission(scriptFileName, "W"));
        CodeAccessPermission::assertMultiple(permissionSet);
        textIoFile = new TextIo(scriptFileName , "W", 0);
        CodeAccessPermission::revertAssert();
        textIofile.write('open sftp://sftp_username:#sftp_password@sftp.xyz.com -hostkey="ssh-rsa 1024 cd:Host key"');
        textIoFile.write(strFmt('get /SFTP_FOLDERNAME/* %1', filePath));     //get the file from SFTP
        //textIoFile.write(strFmt('mv /SFTP_FOLDERNAME/*.txt /SFTP_FOLDERNAME/Archive/')); //Use this code to move the file inside SFTP
//textIoFile.write(strFmt('put %1 /SFTP_FOLDERNAME/', filePath + "\\" + "Uploadfile.txt"));
//Use this code to upload the file to SFTP
        textIoFile.write('exit');
        textIoFile = null;
     

        //EXECUTE SFTP
        new InteropPermission(InteropKind::ClrInterop).assert();
        process = new System.Diagnostics.Process();
        processStartInfo = new System.Diagnostics.ProcessStartInfo();
        processStartInfo.set_FileName(batchFileName);
        processStartInfo.set_WorkingDirectory(filePath);
        process.set_StartInfo(processStartInfo);
        process.Start();//this method call the SFTP
        process.WaitForExit();
        CodeAccessPermission::revertAssert();

        interopPerm = new InteropPermission(InteropKind::ClrInterop);
        interopPerm.assert();
        System.IO.File::Delete(batchFileName);
        System.IO.File::Delete(scriptFileName);
        CodeAccessPermission::revertAssert();

    }
    catch (Exception::CLRError)
    {
         ex = ClrInterop::getLastException();
         if (ex != null)
         {
            ex = ex.get_InnerException();
            if (ex != null)
            {
                error(ex.ToString());
            }
        }
    }
}

You can refer WINSCP portal for more details and commands
Hope this helped you to understand the AX and SFTP integration.

Happy DAXing,

Cheers,
Arun