Create an Esri spatial ETL tool

Available with Data Interoperability license.

Workbench allows you to create workflows to move data between formats and applications that often involve more than a format-to-format translation. Datasets can contain more complex components that may not fit the requirements of the destination system. To preserve key aspects of the data and load it seamlessly into the target application, you may need to adjust the data model, contents, descriptive elements, and the coordinate system. This is known as data transformation, and it is one of a spatial ETL tool's core capabilities.

A spatial ETL tool is a geoprocessing tool that either references or contains the FMW file. The geoprocessing ETL tool allows the Workbench tool to be used in ArcGIS Pro. To support this workflow, there are a few ways to use the ETL tool that best suits your needs.

Default ETL tool

The default behavior is to create a new spatial ETL tool and a default FMW file, which is automatically referenced by that ETL tool. This method is a way to create a new FMW file already referenced by the new ETL tool you created.

  1. Right-click a toolbox Toolbox in the Catalog pane, point to New, and click Spatial ETL Tool.

    The Tool Properties dialog box appears.

  2. Define an appropriate Name and Label, use the default FMW file in your Workspace parameter, and click OK.
  3. The Workbench application is launched.
  4. Choose Format from the drop-down list, or click more formats to open the FME Reader Gallery dialog box, and click OK.
  5. Click the browse button, browse to the file, and click Open.
  6. Click the Parameters button to edit the default FME reader parameters.

    Parameters can include optional and required settings and vary among formats.

  7. In the Writer section of the dialog box, click Format from the drop-down list, or click more formats to open the FME Reader Gallery dialog box, and click OK.
  8. Click the browse button, browse to the file, and click Open.
  9. Click the Parameters button to edit the default FME reader parameters.

    Parameters can include optional and required settings and vary among formats.

  10. Click OK.

    Workbench opens with a diagram of your dataflow.

Reference an existing FMW file to an ETL toolbox

If you already have an FMW file authored either in ArcGIS Pro or in FME Desktop, you can use that in ArcGIS Pro. You must attach the FMW file to an ETL tool so it can be used in ArcGIS Pro. This workflow allows you to share your FMW files with others or run them in the geoprocessing environment.

  1. Right-click a toolbox Toolbox in the Catalog pane, point to New, and click Spatial ETL Tool.

    The Tool Properties dialog box appears.

  2. Define an appropriate name and Label value.
  3. For the Workspace parameter, choose the Existing ETL workspace from the list and browse to an existing FMW file you have on disk.

    The ETL tool now references that FMW file.

  4. To make further edits to the FMW file, right-click the spatial ETL tool and click Edit.

    Workbench opens and loads the FMW file.

Embedded FMW files

Embed the FMW file in the toolbox to share a single toolbox file containing multiple ETL tools. You must embed the ETL tool source when sharing ETL web tools.

  1. Right-click Spatial ETL Tool Toolbox in the Catalog pane and click Properties.

    The Tool Properties dialog box appears.

  2. Define an appropriate name and Label value.
  3. Use the Options/Import FMW check box to embed the ETL web tool.

Import an Esri spatial ETL tool from ArcMap

You can share Esri spatial ETL tools authored using ArcMap with ArcGIS Pro 1.4 and later.

  1. From the Catalog pane, navigate to an existing ArcMap spatial ETL tool.
  2. Right-click Spatial ETL Tool Toolbox and click Edit.
    Workbench opens and loads the ETL workspace.

The workspace can now be run or modified and saved as a new FMW file.