FME / ArcGIS 9 Data Interoperability Extension
FME / ArcGIS 9 Data Interoperability Extension
Extract, Transform, Load - Spatial ETL
About us Founded: 1993
Target markets: GIS & GPS vendors, Telecom and utilities, Oil & gas, Government agencies
Head office: Vancouver, Canada
World-wide Reseller network: 100 resellers, 30 countries
# of Employees: 45
International User base: 4000+
Extract, Transform, Load - Spatial ETL
Overview Data Interoperability Extension Overview ArcCatalog
– File Browse – FME Root
ArcMap
– Adding FME data
ArcToolbox
– Quick Import and Export – Customized Import and Export
Model Builder: FME Datasources and Tools Product Demo Q&A Extract, Transform, Load - Spatial ETL
ArcGIS Desktop Interoperability Extension
ArcCatalog – – –
ArcMap –
Users can browse FME-supported formats directly from the Catalog tree. FME Datasources root node provides access to database formats and allows use of customized reader settings. Users can create customized formats.
Adds same FME datasource capabilities as ArcCatalog.
Toolbox – – –
Adds Import, Export, and FME Transformation tools to ArcToolbox. FME Tools created and maintained using FME Workbench. FME Datasources and Tools can be used within Model Builder.
Extract, Transform, Load - Spatial ETL
ArcGIS Desktop Interoperability Extension
Extract, Transform, Load - Spatial ETL
ArcCatalog (File Browse)
Extract, Transform, Load - Spatial ETL
ArcCatalog (File Browse)
Extract, Transform, Load - Spatial ETL
ArcCatalog (FME Root)
Extract, Transform, Load - Spatial ETL
ArcCatalog (FME Root)
Extract, Transform, Load - Spatial ETL
FME Datasource Creation FME Workspace
Graphically create workflow from source data to destination data. Manipulate geometry and attribution for all FME formats. Intuitive interface makes custom translations easier Exposes all FME functionality in a graphical format. Integrated with FME Universal Viewer. Step 1 Extract: Drag your source dataset on to the workspace
Step 2Transform: Adjust the way your data flows from its source to the destination
Extract, Transform, Load - Spatial ETL
Step 3 Load: Load your data into the destination Translation dialog box
FME & ArcMap
Extract, Transform, Load - Spatial ETL
ArcToolbox / FME Integration New root-level toolbox
in ArcToolbox contains a quick import and export. Translates into Personal GDB
Extract, Transform, Load - Spatial ETL
ArcToolbox / FME Integration Optional root-level
toolbox in ArcToolbox contains all saved FME Interoperability tools.
Extract, Transform, Load - Spatial ETL
ArcToolbox / FME Workbench Integration Create new tools within the FME Workbench
environment.
Extract, Transform, Load - Spatial ETL
ArcToolbox / FME Workbench Integration Reader, Writer, and Transformer parameters can be
exposed in Workbench. They then become parameters of the tool in ArcToolbox.
Extract, Transform, Load - Spatial ETL
FME Parameters in Workbench
Extract, Transform, Load - Spatial ETL
FME Parameters in ArcGIS
Extract, Transform, Load - Spatial ETL
ModelBuilder & FME Workbench Similar at first glance, but really quite different
technologies Both are graphical programming environments Workbench: – Pure data flow diagram – Unit of operation is a feature – No looping or branching – Writes FME scripts
ModelBuilder – Graphical batch creation – Models exportable as Python scripts – Unit of operation is a dataset, or table – Looping and branching possible
Complementary Technologies – Workbench can be used to create processes within ModelBuilder Extract, Transform, Load - Spatial ETL
ModelBuilder / FME Workbench Integration • Configured tools can then be used in ArcToolbox and ModelBuilder in the same way as other models and tools.
Extract, Transform, Load - Spatial ETL
ArcGIS Interoperability Extension Demo ArcCatalog File Browse Add multiple MapInfo files at once Create a custom datasource built from a
pipeline DGN file. – Level 1, Color red (3) Pipelines – Level 1, Color yellow (4) 4 Footprints – Level 2 and Level 54 Parcels Create polygons
Extract, Transform, Load - Spatial ETL
Interoperability Products 1. ArcGIS Desktop Interoperability Extension 2. ArcGIS Server/ArcIMS Data Delivery
Extension 3. ArcGIS Server Extensions a) Plug-in datasource b) Foreign GIS connectors c) Check-out/Check-in edit capability
4. ArcGIS Engine Interoperability Extension
Extract, Transform, Load - Spatial ETL
SAFE SOFTWARE The Spatial ETL Experts Thank You
Extract, Transform, Load - Spatial ETL
Extract, Transform, Load - Spatial ETL
About us Founded: 1993
Target markets: GIS & GPS vendors, Telecom and utilities, Oil & gas, Government agencies
Head office: Vancouver, Canada
World-wide Reseller network: 100 resellers, 30 countries
# of Employees: 45
International User base: 4000+
Extract, Transform, Load - Spatial ETL
Overview Data Interoperability Extension Overview ArcCatalog
– File Browse – FME Root
ArcMap
– Adding FME data
ArcToolbox
– Quick Import and Export – Customized Import and Export
Model Builder: FME Datasources and Tools Product Demo Q&A Extract, Transform, Load - Spatial ETL
ArcGIS Desktop Interoperability Extension
ArcCatalog – – –
ArcMap –
Users can browse FME-supported formats directly from the Catalog tree. FME Datasources root node provides access to database formats and allows use of customized reader settings. Users can create customized formats.
Adds same FME datasource capabilities as ArcCatalog.
Toolbox – – –
Adds Import, Export, and FME Transformation tools to ArcToolbox. FME Tools created and maintained using FME Workbench. FME Datasources and Tools can be used within Model Builder.
Extract, Transform, Load - Spatial ETL
ArcGIS Desktop Interoperability Extension
Extract, Transform, Load - Spatial ETL
ArcCatalog (File Browse)
Extract, Transform, Load - Spatial ETL
ArcCatalog (File Browse)
Extract, Transform, Load - Spatial ETL
ArcCatalog (FME Root)
Extract, Transform, Load - Spatial ETL
ArcCatalog (FME Root)
Extract, Transform, Load - Spatial ETL
FME Datasource Creation FME Workspace
Graphically create workflow from source data to destination data. Manipulate geometry and attribution for all FME formats. Intuitive interface makes custom translations easier Exposes all FME functionality in a graphical format. Integrated with FME Universal Viewer. Step 1 Extract: Drag your source dataset on to the workspace
Step 2Transform: Adjust the way your data flows from its source to the destination
Extract, Transform, Load - Spatial ETL
Step 3 Load: Load your data into the destination Translation dialog box
FME & ArcMap
Extract, Transform, Load - Spatial ETL
ArcToolbox / FME Integration New root-level toolbox
in ArcToolbox contains a quick import and export. Translates into Personal GDB
Extract, Transform, Load - Spatial ETL
ArcToolbox / FME Integration Optional root-level
toolbox in ArcToolbox contains all saved FME Interoperability tools.
Extract, Transform, Load - Spatial ETL
ArcToolbox / FME Workbench Integration Create new tools within the FME Workbench
environment.
Extract, Transform, Load - Spatial ETL
ArcToolbox / FME Workbench Integration Reader, Writer, and Transformer parameters can be
exposed in Workbench. They then become parameters of the tool in ArcToolbox.
Extract, Transform, Load - Spatial ETL
FME Parameters in Workbench
Extract, Transform, Load - Spatial ETL
FME Parameters in ArcGIS
Extract, Transform, Load - Spatial ETL
ModelBuilder & FME Workbench Similar at first glance, but really quite different
technologies Both are graphical programming environments Workbench: – Pure data flow diagram – Unit of operation is a feature – No looping or branching – Writes FME scripts
ModelBuilder – Graphical batch creation – Models exportable as Python scripts – Unit of operation is a dataset, or table – Looping and branching possible
Complementary Technologies – Workbench can be used to create processes within ModelBuilder Extract, Transform, Load - Spatial ETL
ModelBuilder / FME Workbench Integration • Configured tools can then be used in ArcToolbox and ModelBuilder in the same way as other models and tools.
Extract, Transform, Load - Spatial ETL
ArcGIS Interoperability Extension Demo ArcCatalog File Browse Add multiple MapInfo files at once Create a custom datasource built from a
pipeline DGN file. – Level 1, Color red (3) Pipelines – Level 1, Color yellow (4) 4 Footprints – Level 2 and Level 54 Parcels Create polygons
Extract, Transform, Load - Spatial ETL
Interoperability Products 1. ArcGIS Desktop Interoperability Extension 2. ArcGIS Server/ArcIMS Data Delivery
Extension 3. ArcGIS Server Extensions a) Plug-in datasource b) Foreign GIS connectors c) Check-out/Check-in edit capability
4. ArcGIS Engine Interoperability Extension
Extract, Transform, Load - Spatial ETL
SAFE SOFTWARE The Spatial ETL Experts Thank You
Extract, Transform, Load - Spatial ETL
