Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Box Connector

Box Connector

Creating a Synchronization Task with Box Targets

Creating a
Synchronization
Task with Box Targets

When you want to upload, download, or delete objects in Box or write data to CSV files in Box, specify a Box connection while configuring the target in a
synchronization
task.
  1. In
    Data Integration
    , click
    New
    Tasks
    .
  2. Select
    Synchronization Tasks
    , and click
    Create
    to create a synchronization task.
    The
    Definition
    tab appears.
  3. Configure the following fields on the
    Definition
    tab:
    Field
    Description
    Task Name
    Name of the
    synchronization
    task.
    The name of a
    synchronization
    task must be unique within the organization. A
    synchronization
    task name can contain alphanumeric characters, spaces, and the following special characters:_ . + -. A
    synchronization
    task name is not case sensitive.
    Description
    Description of the
    synchronization
    task. Maximum length is 255 characters.
    Task Operation
    Specify the target task operation. Choose one of the following options:
    • Insert for the upload, download, and write data to CSV file Box object operations.
    • Delete to delete Box objects.
  4. Click
    Next
    to specify the source connection. Choose one of the following options:
    • Select a flat file connection that points to the location of the
      upload.csv
      ,
      download.csv
      , or
      delete.csv
      files.
    • Select a source connection that connects to the source from which you want to read data from.
  5. Select
    Single
    as the source type.
  6. Specify the Box source object. Specify one of the following options:
    • The
      upload.csv
      file to upload Box objects.
    • The
      download.csv
      file to download Box objects.
    • The
      delete.csv
      file to delete Box objects.
    • The name of the source object that you want to read data from and write data to a CSV file in Box.
  7. Click
    Next
    to specify the target connection and target object.
  8. Select a Box connection.
  9. Specify the Box object. Specify one of the following options:
    • Upload to upload Box objects.
    • Download to download Box objects.
    • Delete to delete Box objects.
    • The name of the CSV file to which you want to write the source data.
  10. Click
    Next
    to configure the field mappings. Perform any of the following steps based on your requirements.
    1. Click
      Edit Types
      in the Source column to edit the precision and scale of the source objects. Note that this option is not available for all source types.
    2. Click
      Automatch
      to match source and target fields with similar names.
    3. Click
      Edit Types
      in the Target column to edit the data type, precision, and scale of the target object.
    4. Select a source field and drag it to the target field to map the source and target fields. Repeat for all the fields that you want to map.
    5. Click the
      Add or Edit Expression
      icon to define a field expression to transform data.
    6. Click
      Validate Mapping
      to validate all the field mappings.
    7. Click
      Clear Mapping
      to clear all the field mappings.
  11. Click
    Next
    to configure a schedule and advanced options. Perform any of the following steps based on your requirements.
    1. Click
      Run this task on schedule
      and specify the schedule you want to use.
    2. Configure the email notification options.
    3. Configure advanced options for the task.
    4. Configure the advanced source and target properties.
    5. Specify the execution mode.
  12. Click
    Save
    and then
    Finish
    .
  13. From the
    Explore
    page, select the task, and click
    Actions
    Run
    .
    In
    Monitor
    , you can monitor the status of the logs after you run the task.

0 COMMENTS

We’d like to hear from you!