Anaplan Upload
In this Article
This page is no longer maintained (Jul 12, 2023). For the most current information, go to Anaplan Upload.
Overview
You can use the Anaplan Upload Snap to upload binary files to Anaplan models. Text encoding will be UTF-8.
Prerequisites
None.
Support for Ultra Pipelines
Works in Ultra Task Pipelines.
Snap Input and Output
Input/Output | Type of View | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Binary |
| Any Snap that produces a binary output. For example, File Reader | Binary file data that would be used in an Anaplan action (such as processing an import), typically a flat text file, column separated. |
Output | Document |
| N/A | A document output, however, an error output is a binary output. |
Snap Settings
Field Name | Field Dependency | Description | |||
---|---|---|---|---|---|
Label* | N/A | Specify 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* | N/A | Specify the workspace that contains the target model. Default value: N/A | |||
Model* | N/A | Specify the model on which you want the Snap to operate. Default value: N/A | |||
Server filename* | N/A | Specify the file name for an Anaplan server file. Default value: None | |||
Overwrite file | N/A | Select this checkbox to overwrite the Anaplan server file. Else, an error is displayed if the file with the same name already exists. | |||
Override server settings | N/A | Select this checkbox to override the settings saved on Anaplan's server for Separator, Text Delimiter, Header Row, and First Data Row. Default value: Not selected | |||
Separator | N/A | Choose a column separator for the Snap to use. The available options are:
Default value: TAB
| |||
Text Delimiter* | N/A | Choose the text delimiter for the Snap to use. The available options are:
Default value: DOUBLE_QUOTE Anaplan server might ignore this setting and try to auto detect. | |||
Header Row* | N/A | Specify the integer value indicating the header row for the binary input. Note that the Anaplan server might ignore this setting and try to auto detect. | |||
First Data Row* | N/A | Specify the Integer value indicating the first data row for the binary input. Note that the Anaplan server might ignore this setting and try to auto detect. | |||
Retry limit* | N/A | Specify the maximum number of connection retry attempts the Snap must make in case of a connection failure. If the retry attempts exceed the configured value, the Pipeline execution fails and an error message is displayed. Default value: 3 | |||
Retry interval* | N/A | Specify 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 and so on. Default value: 3 | |||
HTTP timeout* | N/A | Specify the connection timeout value in seconds. In case of a connection failure, the Snap aborts the Pipeline execution. Default value: 60 | |||
Snap Execution | N/A | 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.Examples
The example assumes that you have configured and authorized a valid Anaplan account (see Configuring Anaplan Accounts) to be used with this Snap. The following Anaplan Upload Snap uploads a file from SnapLogic projects to Anaplan Workspace. The Anaplan Upload Snap is described using the following Pipeline:
- Reads file data from your SnapLogic projects using the File Reader Snap.
- Uploads the data to a newly created file on your Anaplan Workspace using the Anaplan Upload Snap.
The File Reader Snap reads the 123.csv file (a comma separated file) from SnapLogic projects:
Then, the Anaplan Upload Snap creates a new file myNewFile.csv and uploads the 123.csv file data in it. The myNewFile.csv is made available on the Anaplan Workspace, SnapLogic QA, and Model, Anaplan Snap Tests. Note that, you must specify123.csv file formats (Such as Separator, Text Delimiter, & Header Row) for the Snap to upload the file data:
Upon successful validation of the Snap, you will see a data preview that gets the details of the uploaded file:
Downloads
Important steps to successfully reuse Pipelines
- Download and import the Pipeline into SnapLogic.
- Configure Snap accounts as applicable.
- Provide Pipeline parameters as applicable.
Snap Pack History
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.