English

How To: Create a spatial ETL tool template with the ArcGIS Data Interoperability extension

Summary

The instructions provided describe how to create a spatial ETL (extract, transform, and load) tool template when creating custom ETL tools with the ArcGIS Data Interoperability extension. This process is useful when it is necessary to open the Feature Manipulation Engine (FME) Workbench application and bypass the Create Translation Workspace Wizard.

Procedure

1. Launch ArcMap from the Start menu.

Note:
This procedure requires installing and authorizing the ArcGIS Data Interoperability extension. To do this in ArcMap, click Customize > Extensions, and check the Data Interoperability check box.

2. In the Catalog window, create a new toolbox. To create a toolbox, use the instructions provided in the following Help document, Creating a toolbox.

3. Right-click the new toolbox, and select New > Spatial ETL Tool. The Create Translation Workspace Wizard opens.

4. Specify the source data format as "NULL (Nothing)", and click Next.

5. For the source data location, use the default option, “<Unused>", and click Next.

6. Specify the destination data format as "NULL (Nothing)", and click Next.

7. Click Finish. The FME Workbench application for the ArcGIS Data Interoperability extension opens.

8. In the Navigator window of the FME Workbench application, right-click the NULL reader, and select Delete Reader.

9. In the Navigator window of the FME Workbench application, right-click the NULL writer, and select Delete Writer.

10. To save the tool, click the File menu, and select Save.

11. Close the FME Workbench application.

12. In the Catalog window, right-click the spatial ETL tool, select rename, and rename the tool with a name such as ETL_Template.

In the future, use the following steps to open the FME Workbench application:
1. Copy and paste the spatial ETL tool to a toolbox.
2. Right-click the copied tool.
3. Select Edit to open the FME Workbench application.

Once the Workbench application is open, 'readers' or 'writers' may be inserted and tools may be manipulated as necessary.

Related Information