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.

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 hopes to contribute frequently to US Weekly, People and Sensible Chuckle magazines on improving reporting solutions, creating master data management systems and zzz…

Leave a Reply

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