17 Replies Latest reply: Sep 18, 2013 2:25 PM by Rishabh Awasthi RSS

FTP in Data Services

Manu Gupta
Currently Being Moderated

Dear gurus,

 

I am not able to extract data from FTP on dataservices.

I am giving my FTP xxx.xxx.xxx.xxx in the Host.

 

The UserID and the Password.

 

Now i am not able to access the file still.

 

 

Can you please guide me how to use FTP in Data Services.

 

 

Regards,

Den

  • Re: FTP in Data Services
    Manu Gupta
    Currently Being Moderated

    Any suggestions ??

    • Re: FTP in Data Services
      Paul Kessler
      Currently Being Moderated

      You did not provide any information, so I am assuming you are trying to transfer data from SAP.  Have you tried to connect from FTP command line?  This may be a permission issue.  The account used to open the FTP session must have authority to read files created by SAP.  This article may be useful:

       

      Link:http://wiki.sdn.sap.com/wiki/display/BOBJ/ftptransportmethod

      • Re: FTP in Data Services
        Manu Gupta
        Currently Being Moderated

        1. Yes i have tried connecting through CMD that was my issue initially but its resolved now so i am able to access it via the command line.

         

        2. But through data services, i just need to access a file which is at FTP so i make a Flat File Datasource and in source i give FTP details now when i am trying to select the directory its not allowing me / taking me the to FTP location.

         

        Thanks for your previous response Paul, I will look through the document and i hope the above two points would help to explain my problem better.

         

         

        Awaiting reply.

         

        regards,

        Den

      • Re: FTP in Data Services
        Manu Gupta
        Currently Being Moderated

        Here is what i am giving and still its not working::: Its not even able to access the file.

         

         

        Host ::  ftpd.rsc.dd.intra

         

        User ::  FTPUSER

         

        Password ::  Password

         

        Directory ::

         

        FILE::    /Data/in/TWS.xls

         

         

        Kindly suggest if you have any answer.

        • Re: FTP in Data Services
          Suresh Avala
          Currently Being Moderated

          I'm assuming BODI server is on Windows server box. In that case, you need to move .xls file from ftp to windows shared directory which can be accessible by BODI windows service account. You need to mention Windows shared directory path in the data store. I came to know this while discussing with unix team but yet to try. Even I'm going through the same issues.

          Note: I'm using SAP shared directory transport method.

           

          Thanks,

          Suresh

          • Re: FTP in Data Services
            Manu Gupta
            Currently Being Moderated

            Thanks Suresh. I am also checking but that doest really solve my problem.

             

            Please let me know when you find your solution.

             

            Regards N thanks again.

            Den

            • Re: FTP in Data Services
              Paul Kessler
              Currently Being Moderated

              Your response indicates that you are not trying to extract data from SAP.  You are trying to read a file using FTP.  Is this correct?  If so, are you configuring the flat file format object for custom transfer?  In the Technical Manuals, the section in DS Designer Guide,  File formats, File transfers has details about this.

               

              Paul

              • Re: FTP in Data Services
                Manu Gupta
                Currently Being Moderated

                Thanks for the reply Paul.

                 

                I have checked in the Tutorial and the designer guide. There is nothing there which is not obvious thing which one knows.

                 

                They are not helpful at all in this scenario to me.

                 

                Yes i am trying to read a file using FTP.

                 

                Yes i am configuring the flat file format object for custom transfer.

                 

                Let me know if you have more inputs.

                 

                regards,

                Den

                • Re: FTP in Data Services
                  Paul Kessler
                  Currently Being Moderated

                  Is DS installed on Windows or Unix?

                  • Re: FTP in Data Services
                    Manu Gupta
                    Currently Being Moderated

                    Hi Paul and Suresh,

                    Many Thanks for the reply.

                     

                    Data Services is installed on WINDOWS machine and FTP is installed on LINUX machine in my system.

                     

                    Now i am not able to access FTP from Data Services, is there anything that i need to do ? Some setting or adapter etc ?

                     

                    Regards,

                    Den

                     

                    Edited by: Dennis on Oct 21, 2010 11:29 AM

                     

                    Edited by: Dennis on Oct 21, 2010 12:08 PM

                    • Re: FTP in Data Services
                      Paul Kessler
                      Currently Being Moderated

                      Dennis,

                       

                      The issue may be the manner in which you have implemented Custom Transfer.  If you are able to manually open an FTP session and get the file then you know that the FTP account works.

                       

                      Try this procedure:

                      1.  In the DS Designer Guide, go to the chapter on File Transfers

                      2.  At the end of the section on Custom transfer system variables for flat files, copy the script that is listed there

                      3.  Paste the script into notepad and save it to your hard drive as myftp.bat

                      4.  Use these custom transfer values:

                      Program executable:  <path>\myftp.bat
                      User name:  FTPUSER
                      Password:   <password>
                      Arguments:  $AW_USER $AW_PASSWORD '<local_path>' 'TWS.xls' 'ftpd.rsc.dd.intra'
                      

                      <path> is the path to the FTP executable on your Windows server

                      <local_path> is the path to where you want FTP to drop your file

                      ftpd.rsc.dd.intra is the remote FTP server that you specified earlier

                       

                      In the job, Data Services will execute the this command string:

                      myftp.bat FTPUSER <password> 'local_path' 'TWS.xls' 'ftpd.rsc.dd.intra'
                      

                      In the script, the arguments are assigned to variables in the order they appear, and the variables are used to generate an FTP command file.  Finally, the FTP command string is executed.

  • Re: FTP in Data Services
    Rishabh Awasthi
    Currently Being Moderated

    Please check for the  permissions on the file at FTP Location it should be rwx(777) .

     

    Regards,

    Rishabh

Actions