Loading of attachments in bulk
Load attachments in bulk, for example, linking invoices to utility account records as supporting evidence.
To load attachments in bulk, you configure a file loading data service and associate it with a file loading data pipeline with the target system set to attachments.
A system pipeline to process attachments is automatically created and connected to all enabled file loading data services. You need to create a custom pipeline only for special file handling scenarios such as renaming and delaying attachments before loading them. For more information, see Configuring a file transformation and loading pipeline.
Note: If you want to specify additional parameters that are required for
attachment loading, you must configure a custom data pipeline.
The end-to-end flow is as follows:
- Create a data service under the category File Loading:
- To load data from an Amazon S3 bucket, set the data service type to Amazon S3 (Cloud Storage). For more information, refer to Amazon S3 data service.
- To load data from Amazon SFTP, set the data service type to Amazon Transfer (SFTP). For more information, refer to Amazon SFTP data service.
- To load data from an Amazon mailbox, set the data service type to Amazon Simple Email (Mailbox). For more information, refer to Amazon mailbox service.
- Optionally, configure a custom file loading pipeline:
- Specify Attachments as the target system.
- Specify a filename pattern to use when looking for attachments to load.
- Select the data services to poll.
- Select none (pass-through) as the data transformer.
- Specify any additional parameters that are required for attachment loading such as delay time or file renaming.