{"id":4431,"date":"2015-05-04T04:46:47","date_gmt":"2015-05-04T04:46:47","guid":{"rendered":"http:\/\/www.jitendrazaa.com\/blog\/?p=4431"},"modified":"2016-08-31T18:30:31","modified_gmt":"2016-08-31T18:30:31","slug":"using-dataloader-and-ant-to-backup-salesforce-data-on-ftp-server-video","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/using-dataloader-and-ant-to-backup-salesforce-data-on-ftp-server-video\/","title":{"rendered":"Using Dataloader and ANT to backup Salesforce data on FTP or SFTP server – Video"},"content":{"rendered":"

We will be using command line dataloader from Salesforce and ANT script to extract data from Salesforce and backup on FTP server. I would recommend to go through this article first to get familiar with basics of commandline dataloader<\/a> and followed by this article to get some insight that how we can use ANT with dataloader<\/a>.<\/p>\n

There can be hundreds of use cases where we need to backup data from salesforce and we have thousands of options. We can use Jitterbit, Mulesoft, Dataloader.io or some big ETL tools like BOOMI or informatica. However sometimes clients are not willing to pay hefty \u00a0amount on licensing cost of ETL tools and I love open source. In this article, we will be using open source solution to very common problem of backing up data on FTP server.<\/p>\n

Complete code is available on my github account as well<\/a> in case you need it.<\/p>\n

\"Use<\/a>
Use Dataloader and ANT to back CSV file on FTP Server<\/figcaption><\/figure>\n

Considering you know how to use command line dataloader, first challenge would be how to get it worked using ANT. Below code snippet show how we can create ANT macro to invoke dataloader to extract data.<\/p>\n

\r\n<macrodef name="export_Account">\r\n        <sequential>\r\n            <java classname="com.salesforce.dataloader.process.ProcessRunner" classpath="D:\\Program Files (x86)\\salesforce.com\\Data Loader\\dataloader-33.0.0-uber.jar" failonerror="true">\r\n                <sysproperty key="salesforce.config.dir" value="config"\/>\r\n                <arg line="process.name=Account"\/>\r\n            <\/java>\r\n        <\/sequential>\r\n    <\/macrodef>\r\n<\/pre>\n
Once data is extracted, we can copy csv file created by dataloader to ftp server using below code<\/p>\n
\r\n<ftp server="${ftpServer}" port="${ftpPort}" userid="${ftpUserName}" password="${ftpPassword}" passive="yes" ` binary="no">\r\n        <fileset dir="${localFolder}">\r\n          <include name="**\/*.csv"\/>\r\n        <\/fileset>\r\n      <\/ftp>\r\n<\/pre>\n
parameters like “ftpServer”, “ftpPort” are coming from build.properties file. You can use FTP task<\/strong> from ANT to move local file to FTP server. Complete detail of capability and syntax of this task can be found on official site.<\/a><\/p>\n
Complete code of build.xml<\/strong><\/p>\n
\r\n<?xml version="1.0" encoding="UTF-8"?>\r\n<!-- \r\n@Author : Jitendra Zaa \r\n@Blog : https:\/\/jitendrazaa.com \r\n@Description : This ANT script depends on external dependency that can be downloaded from "http:\/\/commons.apache.org\/proper\/commons-net\/download_net.cgi". : once downloaded, jar files can be added in any folder which should be available to Windows shell. : Some suggested path - ANT bin directory, Java lib directory. Or in any directive that is added in PATH env variable. : Getting started with Dataloader - https:\/\/www.jitendrazaa.com\/blog\/salesforce\/tutorial-of-command-line-dataloader-salesforce\/ : Dataloader and ANT - https:\/\/www.jitendrazaa.com\/blog\/salesforce\/automate-command-line-dataloader-using-ant-with-dynamic-arguments-and-query\/ -->\r\n<project name="Export" default="all">\r\n    <property file="build.properties"\/>\r\n    <property environment="env"\/>\r\n    <macrodef name="export_Account">\r\n        <sequential>\r\n            <java classname="com.salesforce.dataloader.process.ProcessRunner" classpath="D:\\Program Files (x86)\\salesforce.com\\Data Loader\\dataloader-33.0.0-uber.jar" failonerror="true">\r\n                <sysproperty key="salesforce.config.dir" value="config"\/>\r\n                <arg line="process.name=Account"\/>\r\n            <\/java>\r\n        <\/sequential>\r\n    <\/macrodef>\r\n    <target name="all">\r\n        <export_Account \/>\r\n    <ftp server="${ftpServer}" port="${ftpPort}" userid="${ftpUserName}" password="${ftpPassword}" passive="yes" ` binary="no">\r\n        <fileset dir="${localFolder}">\r\n          <include name="**\/*.csv"\/>\r\n        <\/fileset>\r\n      <\/ftp>\r\n    <\/target>\r\n<\/project>\r\n<\/pre>\n
sample configuration settings in build.properties<\/strong><\/p>\n
\r\nftpServer=YOUR FTP SERVER\r\nftpPort=21\r\nftpUserName=USERNAME\r\nftpPassword=FTP PASSWORD\r\nlocalFolder=C:\\\\Users\\\\Jitendra\\\\Desktop\\\\SFDC to FTP\r\n<\/pre>\n
Using SFTP with ANT<\/strong><\/p>\n