Running DRM Exports to FTP Sites

Today, let’s look at a type of external connection, which is seldom used, in my experience. We will be looking at running exports to an FTP site in this post. To illustrate, I’ve set up an FTP site on hostedftp.com (excellent cloud FTP provider). You could also be using your organization’s FTP server.

In this case, the server name is: us3.hostedftp.com. The site uses the default FTP port, 21. Now, let’s shift our attention to DRM. To set up an FTP site, navigate to Administer > New > External Connection.

On the pane that opens up, you can enter your credentials. Make sure to select “FTP” as the connection type.

You can run a test to see if your connection information is accurate.

That all looks good. Let’s now set up a simple export to test out the functionality. The screenshot below, is from a simple hierarchy export. The “device” needs to be set to Server; you will then be able to see an option to set up the FTP connection.

Once you provide a file name, you can run the export, as usual.

You will see the extracted file on the FTP site.

Bonus Points

What if you wanted to export to specific directories? You can do that as well. I’ve set up a directory below, on my FTP site.

I’ve made a slight change to my export now. I’ve added the directory name to the file name.

Once I run the export, you can see the export file in the directory.

In Conclusion…

One of the downsides to this functionality, is that DRM still does not support Secure FTP (SFTP). Other than that, there you have it, a simple example on how to run exports to an FTP site.

Avatar

About Vijay Kurian

Known as the Clem Fandango of EPM consulting, Vijay Kurian has been developing enterprise solutions for companies for the last 12 years (increment years if reading post-2015). Having worked with Essbase, Planning, DRM and other assorted technologies during that time, he’s made the frankly, average decision, to write about them. He is, surprisingly, an Oracle ACE Associate. He hopes to contribute frequently to US Weekly, People and Sensible Chuckle magazines on improving reporting solutions, creating master data management systems and zzz…

6 Comments

  1. Nice Post…This is really Helpful for me..
    Can you please share your experience on Associated Group.

  2. Hi Vijay,

    Hope you are doing great..
    Vijay could you please guide me or share your inputs , in how to configure the DRM with HFM and Planning.
    In how many ways we can migrate the data from DRM to Planning and HFM.

    Please share your inputs.

    • Hi,
      if you have EPMA for Planning and HFM, then:
      1. You can create interface table exports out of DRM, then import and deploy to those applications.
      2. Set up the DRM > EPMA integration. This can be complicated.

      If you have classic Planning:
      1. Standard parent child exports from DRM, with required properties. Then use ODI or the Outline Load Utility to load master data into Planning.

  3. Awsome Vijay .Thanks a lot for the quick replay.

  4. Hi Vijay,
    ANy Idea on the below issue.

    In DRG one of the Approver pushed back the DRG request . But the request went to the wrong submitter .Once the Request is pushed back it will go to all the submitter ? .

Leave a Reply

Your email address will not be published. Required fields are marked *