Anaplan Write
On this Page
Snap type: | Write | |||||||
---|---|---|---|---|---|---|---|---|
Description: | This Snap is used to write input record documents into Anaplan.
| |||||||
Prerequisites: | [None] | |||||||
Support and limitations: | Works in Ultra Pipelines | |||||||
Account: | This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Anaplan Account for information on setting up this type of account. | |||||||
Views: |
| |||||||
Settings | ||||||||
Label | Required. The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline. | |||||||
Workspace | Required. The workspace that contains the target model. Default value: N/A | |||||||
Model | Required. The model on which you want the Snap to operate. Default value: N/A | |||||||
Import name | Required. List of the export ID's available in a model. | |||||||
Server filename | Required. Filename for an Anaplan server file. | |||||||
Overwrite file | If selected, the Anaplan server file is overwritten. Otherwise, an error will occur if the file already exists. | |||||||
Override server settings | Select this check box to override the settings saved on Anaplan's server for Separator and Text Delimiter. Default value: Not selected | |||||||
Separator | Choose the column separator for the Snap to use the following available options:
Default value: TAB
| |||||||
Text Delimiter* | Choose the text delimiter for the Snap to use the following available options:
Default value: DOUBLE_QUOTE Anaplan server might ignore this setting and try to auto-detect. | |||||||
Upload only | If selected, uploads the server file and does not run an import job. | |||||||
Retry limit | Specifies the maximum number of connection retry attempts in case of a connection failure. If the retry attempts exceed the configured value, the pipeline execution fails and an error message appears. Default value: 3 | |||||||
Retry interval | Specifies the minimum retry time interval in seconds. Enter the time interval for the Snap to retry a connection request after a failed connection. The time increases exponentially between failures. For example, if the timeout is set to 3 seconds, the first timeout is at 3, the second is at 4.5 etc. Default value: 3 | |||||||
HTTP timeout | Specifies the connection timeout value in seconds. In case of a connection failure, the Snap aborts the pipeline execution. Default value: 60 | |||||||
Snap Execution | Select one of the three modes in which the Snap executes. Available options are:
|
Temporary Files
During execution, data processing on Snaplex nodes occurs principally in-memory as streaming and is unencrypted. When larger datasets are processed that exceeds the available compute memory, the Snap writes Pipeline data to local storage as unencrypted to optimize the performance. These temporary files are deleted when the Snap/Pipeline execution completes. You can configure the temporary data's location in the Global properties table of the Snaplex's node properties, which can also help avoid Pipeline errors due to the unavailability of space. For more information, see Temporary Folder in Configuration Options.
Example
The example assumes that you have configured & authorized a valid Anaplan account (see Configuring Anaplan Accounts) to be used with this Snap. The following Anaplan Write Snap writers to a file in your Anaplan Workspace. The Anaplan Write Snap is described using the following pipeline:
The pipeline:
- Reads a CSV file from your SnapLogic projects using the File Reader Snap.
- Parses the file data using the CSV Parser Snap.
- Writes/imports the file/file-data on your Anaplan Workspace using the Anaplan Write Snap.
The File Reader Snap reads the actor.csv file (a comma separated file) from SnapLogic projects:
Then, the CSV Parser Snap parses the actor.csv file data for Anaplan Write Snap to write it on the Anaplan Workspace. The Anaplan Write Snap writes to a file sample_1.csv in the Anaplan Workspace,SnapLogic QA, and Model, Anaplan Snap Tests:
Note that, selecting Upload Only in this Snap uploads the file as a new file on your Anaplan Workspace. This is the same operation as performed in Anaplan Upload Snap. Not selecting the Upload Only option, updates/appends the file data (based on the input data) to an existing file in the Anaplan Workspace.
After a successful validation of the Snap, you will see a data preview that gives the status of the write operation and details of the file written/imported to Anaplan Workspace: