Setting up an Informatica Export Process

Prepare your server

1. Navigate to your server where your Informatica Agent is installed and create a docs directory under C:\<FTP Path>\informatica\TargetX\ (Ie.C:\<FTP Path>\informatica\TargetX\docs).
2. Open your Command Prompt in windows within the server and navigate to C:\<FTP Path>\informatica\TargetX in a command line window.
3. Type echo %CD% > .infaccess
4. Within Informatica, create a new connection under Configure
5. Your connection type will be FileIO, runtime environment should match the one used above to create the docs directory. 
6. Parent Directory = C:\<FTP Path>\informatica\TargetX
7. Check Overwrite Target Files
8. Save

Create Attachment export Task 1 in Informatica

1. The task will be an insert task; enter the required fields and press Next. 
2. The Source connection will be your production Salesforce; the source object is Attachment. Check the Field that says to include Archive and Deleted data within the Source step.
3. Target - use your connection that references the server where the drop box is. 
4. Select Create Target and press OK to hold the Attachment field data.
5. Data filters: create a data filter of Deleted = True.
6. Select Clear Mapping to remove all mappings. Then add mappings for only Attachment ID, Deleted, Parent ID, and File Name.

Create Attachment export Task 2 in Informatica

1. The task will be an insert task. The source will be the connection used for Target in your first task. The object should be the new target file created in the previous task. 
2. For Target, select the FileIO connection, then choose the docs folder
3. Navigate to the Mappings step and map File Name to File Name field. 
4. Next to File Content as Base64 String field mapping, click the lookup icon with the magnifying glass.
5. Lookup connection will be your production Salesforce connection
6. Lookup fields will be the Attachment ID, and the output value will be Body.
7. Save

Create a Task Flow

1. Under Design, click Task Flows and then press the New button to create the flow.
2. Add the first task and then the second task.
3. Save

From this point, you could run the Task flow to get the attachments into your server where you created the docs directory.