Skip to end of metadata
Go to start of metadata

Introduction

A temporary storage write activity interacts with a temporary storage connection to write data as a target in an operation or a script. After configuring a temporary storage connection, you can configure as many temporary storage activities as you like for each temporary storage connection.

NOTE: Cloud Agents that are version 10.10 or higher have a temporary storage file size limit of 50 GB per file. Those who need to create temporary files larger than 50 GB are encouraged to use Private Agents.

Creating a Temporary Storage Activity

From the design canvas, open the Connectivity tab of the design component palette:

Within the Endpoints filter, click the temporary storage connection block to display activities that are available to be used with a temporary storage connection:

To create an activity that can be configured, the activity must first be added to an operation on the design canvas. To add an activity to an operation, drag the activity block from the palette to the operation.

For more information about the parts of an operation and adding activities to operations, see Operation Creation and Configuration.

Accessing Menu Actions

After a temporary storage activity has been added to an operation, menu actions for that activity are accessible from the project pane in both the Workflows and Components tabs, and from the design canvas:

  • Project Pane: In the Workflows or Components tab of the project pane, hover over an activity name and click the actions menu icon  to open the actions menu.

  • Design Canvas: Within the operation, click an existing activity block to open the actions menu.

Each of these menu actions is available:

  • View/Edit: This opens the activity configuration screen for you to configure the activity. For details, see Configuring a Temporary Storage Write Activity later on this page.
  • Delete: This is used to permanently delete the activity (see Component Dependencies, Deletion, and Removal).
  • Rename: This positions the cursor on the activity name in the project pane for you to make edits.
  • View Dependencies: This changes the view in the project pane to display any other parts of the project that the activity is dependent on (see Component Dependencies, Deletion, and Removal).
  • Remove: Available only from the actions menu on the design canvas, this removes the activity as a step in the operation without deleting it from the project. When you remove an activity that is adjacent to a transformation, if schemas are provided within that activity, they will no longer be referenced by the transformation. Removed components can be accessed or permanently deleted from the project pane (see Component Dependencies, Deletion, and Removal).
  • Deploy: This deploys the activity and any components it is dependent on (see Component Deployment).
  • Configurable Deploy: This opens the deployment screen, where you can select project components to deploy (see Component Deployment).
  • Add to group: This opens a prompt to create a new custom group or to add the component to an existing group. Custom groups are an organizational tool to help organize a project (see Component Groups).
  • Duplicate: This creates a copy of the activity as a new, unreferenced component. Upon creating the component copy, the cursor is positioned on the component name within the project pane for you to rename the component.

Configuring a Temporary Storage Write Activity

Follow these steps to configure a temporary storage write activity:

CAUTION: After successful execution of a temporary storage write activity, by default any files written to temporary storage will be cleaned up by the Jitterbit cleanup service after 24 hours.
TIP: On Private Agents, the file cleanup setting can be changed through the Private Agent configuration file under the [FileCleanup] section by changing the FrequencyInHours.

Step 1 – Enter Basic Information and Provide File Schema

TIP: Fields with a variable icon support using global variablesproject variables, and Jitterbit variables. Begin typing an open square bracket [ into the field or click the variable icon to display existing variables to choose from.

  • Name: Enter a name to use to identify the temporary storage write activity. The name must be unique for each temporary storage write activity and must not contain forward slashes (/) or colons (:).

  • Provide Request Schema: The request schema defines the structure of data that will be used by the temporary storage write activity. Whether a request schema is required depends on if the activity will be used as the target of a transformation (see When to Use a Schema). For instructions on completing this section of activity configuration, refer to Schemas Defined in an Activity.

    NOTE: As an alternative to providing a schema during activity configuration, you can define a schema directly within a transformation (see Schemas Defined in a Transformation). File schemas defined directly in a transformation take precedence over those configured as part of an activity.
  • Path (Optional): Enter the folder path that you want to write to within the temporary storage directory, or enter multiple paths separated by a comma (for example, folder1, folder2). If no path is entered, the files will be written to directly within the default temporary storage folder. To write to a new or existing temp storage sub-directory, enter the existing folder path(s) contained within the temp storage directory.

    WARNING: These special characters cannot be used in file paths: ~%, $", <, >, :?.

    However, some special characters are allowed: !@#^&*()[]';. In addition, either a forward slash / or a backslash \ can be used as a path separator.

    NOTE: The default temporary storage directory used by Jitterbit Harmony is the temporary directory of the agent's operating system. Typically:

    • Windows: C:\Windows\Temp\jitterbit\TemporaryStorage
    • Linux: /tmp/jitterbit/TemporaryStorage

    On Private Agents, the default temporary storage directory can be changed through the Private Agent configuration file. To do so, under the [OperationEngine] section, set TemporaryStorageRootDirectory to an absolute path to an existing directory.

    On Cloud Agents, the default temporary storage directory cannot be changed. However, since the path is relative, if a file has been written to temporary storage with a particular path, that same file can be retrieved from temporary storage using the same path if created within the same operation chain. For additional explanation, see Important Notes under Temporary Storage.

  • Filename(s): Enter the name of the file(s) that you want to write to within the path(s) entered above. Any of the filename keywords are available to generate unique filenames (for example, result[date][time].[ext]). If specifying data in ZIP format, see the Compression options described below.

  • Optional Settings: Click to expand additional optional settings:

    • Do not create empty files: Select this checkbox to skip creating the target file if there is no target data.

    • Append to file: Select this checkbox to append to existing target file instead of overwriting.

    • Write headers: Select this checkbox if you are using a flat text target and want to write headers (column/field names) to the first line.

    • End of line Type: Specify how to write line breaks when writing to a target. Note that end-of-line characters in the data itself will not be converted. The options are as follows:

      • Default: Standard end-of-line characters for the platform the agent is running on.

      • Windows: CRLF (ASCII 13 and ASCII 10).

      • Unix: LF (ASCII 10).

    • Character Encoding: Specify character encoding to define a specific character encoding for the target file. If you leave the field blank, Jitterbit Harmony will try to detect the encoding. If you want to overwrite the default, you can choose from any of the encoding types listed in Character Encoding.

    • Compression: Select the checkbox for Compress Target Files if you want the target data to be compressed. These options become available:

      • Format: Use the dropdown to select the desired compression format. Currently, only ZIP format is supported.

      • File names in archive(s): Enter the name of the target file(s) to be compressed within the archive. Any of the filename keywords are available to generate unique filenames. File(s) will automatically be written into the archive at the root level.

        TIP: To keep the filename(s) in the archive the same as the filename(s) defined in the target, enter [file].[ext].

      • Mode: Use the dropdown to select from these modes:

        • Overwrite: This mode will overwrite the existing archive.
        • Append: If the archive is not encrypted, this mode will add compressed files to the existing archive. Appending to an encrypted ZIP file is not supported.
      • Password: To encrypt the archive, enter the desired password.

      • Encryption mode: If a password is supplied, use the dropdown to select between the two available encryption modes: AES and Standard ZIP.

  • Save & Exit: If enabled, click to save the configuration for this step and close the activity configuration.
  • Next: Click to temporarily store the configuration for this step and continue to the next step. The configuration will not be saved until you click the Finished button on the last step.
  • Discard Changes: After making changes, click Discard Changes to close the configuration without saving changes made to any step. A message will ask you to confirm that you want to discard changes.

Step 2 – Review Data Schema

  • Data Schema: If provided during activity configuration, the request data schema is displayed. If the operation uses a transformation, the data schemas will be displayed again later during the transformation mapping process, where you can map to target fields using source objects, scripts, variables, custom values, and more. You can also define schemas directly in a transformation.

  • Add Plugin(s): Plugins are Jitterbit- or user-provided applications that extend Harmony's native capabilities. To apply a plugin to the activity, click to expand this section and select the checkbox next to the plugin to be used. For additional instructions on using plugins, including details on setting any required variables used by the plugin, see Plugins Added to an Activity.

  • Back: Click to temporarily store the configuration for this step and return to the previous step.
  • Finished: Click to save the configuration for all steps and close the activity configuration.
  • Discard Changes: After making changes, click Discard Changes to close the configuration without saving changes made to any step. A message will ask you to confirm that you want to discard changes.

Next Steps

After configuring a temporary storage write activity, you can use it within an operation or script as described below.

Completing the Operation

After configuring a temporary storage write activity, complete the configuration of the operation by adding and configuring other activitiestransformations, or scripts as operation steps (see Operation Creation and Configuration). You can also configure an operation's operation settings, which include the ability to chain operations together that are in the same or different workflows (see Operation Settings).

Temporary storage write activities can be used as a target with these operation patterns:

Other patterns are not valid using temporary storage write activities. See the validation patterns on the Operation Validity page.

This example setup depicts one common operation setup using a temporary storage write activity:

A common design pattern for using temporary storage is provided in Persisting Data for Later Processing Using Temporary Storage (This pattern uses Design Studio as an example, but the same concepts can be applied in Cloud Studio).

When ready, deploy and run the operation (see Operation Deployment and Execution) and validate behavior by checking the operation logs (see Operation Logs).

Using Temporary Storage Activities in Scripts

Temporary storage write activities that have already been configured as part of an operation can also be referenced in a script for use with certain script functions that use a targetId as a parameter. For example:

To add a configured temporary storage activity to a script to be referenced by one of these functions, drag the configured activity from the Endpoints tab of the script component palette to the script. Or, if you already know the function you want to use, add it from the Functions tab first; then position the cursor after the opening parenthesis of the function and press Control+Space to display a list of autocomplete suggestions. Select an activity to insert the activity reference into the script.

For more details on referencing activities in scripts, see Endpoints on the Jitterbit Script page.

On This Page

Last updated:  Jan 17, 2020

  • No labels