Dynamic Workspaces Demystified: Your Path to Streamlined Data Management

ElizabethHamming 23 views 61 slides Sep 11, 2024
Slide 1
Slide 1 of 61
Slide 1
1
Slide 2
2
Slide 3
3
Slide 4
4
Slide 5
5
Slide 6
6
Slide 7
7
Slide 8
8
Slide 9
9
Slide 10
10
Slide 11
11
Slide 12
12
Slide 13
13
Slide 14
14
Slide 15
15
Slide 16
16
Slide 17
17
Slide 18
18
Slide 19
19
Slide 20
20
Slide 21
21
Slide 22
22
Slide 23
23
Slide 24
24
Slide 25
25
Slide 26
26
Slide 27
27
Slide 28
28
Slide 29
29
Slide 30
30
Slide 31
31
Slide 32
32
Slide 33
33
Slide 34
34
Slide 35
35
Slide 36
36
Slide 37
37
Slide 38
38
Slide 39
39
Slide 40
40
Slide 41
41
Slide 42
42
Slide 43
43
Slide 44
44
Slide 45
45
Slide 46
46
Slide 47
47
Slide 48
48
Slide 49
49
Slide 50
50
Slide 51
51
Slide 52
52
Slide 53
53
Slide 54
54
Slide 55
55
Slide 56
56
Slide 57
57
Slide 58
58
Slide 59
59
Slide 60
60
Slide 61
61

About This Presentation

Ever felt overwhelmed by messy data, countless workspaces, and the never-ending task of managing multiple datasets? Dynamic workspaces could be the answer you’re looking for.

Imagine a single workspace that adapts to any data, handling various types, attributes, and formats with ease. No more con...


Slide Content

Dynamic Workspaces
Demystified: Your Path to
Streamlined Data
Management

Dan
Minney

Customer Solutions Specialist


Chris
Berger

Customer Solutions Team Lead

Meet the Team

Welcome to Livestorm.
A few ways to engage with us during the webinar:


Audio issues? Click this for 4 simple
troubleshooting steps.

How to download slides
1.Hover over the
slide deck in the
webinar room
2.Click this button

Agenda
1Introduction & Components of a Dynamic Workspace
2Use cases & demos
3The SchemaScanner Transformer
4Advanced Dynamic Workflow
5Conclusion
7Resources and Q&A

Poll:
How many hours do you
use FME weekly?

1
Introduction

One platform, two technologies
FME Form FME Flow
Build and run data workflows Automate data workflows

FME Flow Hosted
Safe Software managed instance
fme.safe.com/platform
FME Enterprise Integration Platform

Number of supported data types in FME
1995 2000 2005 2010 2015 2020 2023…
10 100 300 500
GIS
CAD
Database
XML
Raster
3D
BIM
Web
Point
Cloud
Cloud
Big
Data
IOT
Gaming
BI
Indoor
Mapping
AR/VR
Generative
AI
Cloud
Native
Tabular
Unrivalled Data Support

What is a Dynamic Workspace?
A Workspace that integrates data without predefined source and/or destination
schemas.
Adaptive & Versatile
●Schema is determined at runtime, adapting to the data on the fly.
●Easily adjusts to different data structures and formats as they are encountered.

Why use a Dynamic Workspace?
Schema independent workspaces are beneficial because they can handle varying
inputs, whether that be changing data types, attributes, formats or feature types
●Minimal long-term maintenance
●Can handle varying output formats
●Better suited for un-predictable source datasets
When to use one?
●Best used for simple translations between formats
●Helpful if the structure of the source data might change

Fixed Schemas
Traditional workspaces are tightly bound to source and destination schemas.

Dynamic Schemas
Dynamic workspaces break up the dependence on a set schema by creating a
universal layout to handle the data

Source: In the Reader, use the Merge Feature Type parameter to enable dynamic
inputs



Components of a Dynamic Workspace

Destination: In the Writer, enable Dynamic Schema Definition
Components of a Dynamic Workspace

On the Start Tab, select Generate Workspace and choose Dynamic Schema
Easy Place to Start

Automating Dynamic
Workspaces

Event Driven Real Time
FME Flow Apps
-Submit Jobs and Trigger Automations
-Stream or Download Job Results

FME Flow Automations
-Polling Services
-Email Received, FTP/S3/Directory Modified, etc.

FME Flow REST API
-Job as a Webhook
FME Flow Automations
-Push Services
-Webhook/Message Received, Topic Notified,
etc.
FME Flow: Automating Dynamic Workspaces

Form & Flow: Dynamic Workspaces Concepts
FME Flow Automations:
Run a Dynamic Workspace

FME Form Authoring:
Dynamic Workspaces
●Data-driven data integration that is
adaptable to various input types,
schemas, geometries, and outputs.

●Authored in FME Form and Published to
FME Flow
Form & Flow: Dynamic Workspaces Concepts
FME Flow Automations:
Run a Dynamic Workspace
●Enables organizations to specify the
workspace that is to be executed at
run-time rather than at “author time”.

●Users can invoke any workspace that
matches a template workspace without
having to stop the FME Flow Automation.

Poll:
Would you find value in and
attend a webinar on building
Dynamic Automations?

FME Form Authoring:
Dynamic Workspaces
●Flexible Data Handling: Adjusts to
different data sources and formats.

●Data/Parameter Driven: Use of
parameters and conditional logic to
control the flow of data.

●Reusable: Easily repurposed for different
tasks with minimal changes.


Form & Flow: Dynamic Workspaces Concepts
FME Flow Automations:
Run a Dynamic Workspace
●Automation: Executes specific
workspace based on predefined
conditions, reducing manual intervention.

●Continuous Integration: Enables
continuous data processing and
event-driven workflows.

●Scalable: Built for large-scale operations
and complex workflows.

2
Use Cases &
Demos

Demo

Destination Schema as Mirror Image of
Source Data
●Maximum flexibility, simple setup
●Accepts any dataset in chosen format
○Ex: Convert File Geodatabase table to CityGML, preserving schema
●Source dataset changeable, translation remains effective
●No workspace changes needed; select source dataset and run

Destination Schema is Derived from an
External Dataset
●Workspace reads data, copies schema to destination writer
●Output mirrors input dataset
●Map source data to new schema dynamically
●Useful for strict or pre-existing output schemas
●Use any format as template with a Resource Reader

Chat Storm:

What are you currently using your
dynamic workspaces for?

3
SchemaScanner
Transformer

SchemaScanner Transformer
●Allows you to easily extract and manipulate the schema of
your datasets, tackling dynamic workspace issues such
as schema standardization and schema drift
●Remove attributes from the schema without having to
expose it

The schema feature is given the special attribute and value:
fme_schema_handling = ‘schema_only’

* FME 2021.2 or newer
required

Why use the SchemaScanner?
●You want to ensure the dynamic writer is
receiving a valid schema
●You don’t know the schema of the incoming
data and want to ensure it meets certain
standards before reaching the dynamic writer
●You want to modify the schema and need to
re-scan it before reaching the dynamic writer




* FME 2021.2 or newer
required

Key Parameters in the SchemaScanner
Output Schema Features Before Data
●A Dynamic Writer must receive the
schema first before the incoming data,
otherwise no data will be written out
●Suggested to set this to Yes, regardless of
your workflow

Key Parameters in the SchemaScanner
Ignore Attributes Containing
●Most schemas (once in FME) contain
format attributes you don’t need in your
final output dataset
●Example: csv_|multi_|fme_ would remove
attributes such as csv_line_number,
csv_type, fme_feature_type,
multi_reader_id, etc.

SchemaScanner Output
●A list attribute is generated that contains the
attribute name and its data type. This can then
be exposed or manipulated to create flexible
schema workflows.

FeatureReader vs SchemaScanner
●The Schema generated by the
FeatureReader is a copy of the dataset
schema
●The Schema generated by the
SchemaScanner is FME’s “best guess”

Slide Title
Fanout data
based on the
“Day” attribute

Goal Block Key
Dynamic Dataset Fanout
Result
Multiple datasets
+ schema has
changed since
data was read
into FME

Group By
Parameter in the
SchemaScanner

Output a CSV file
for each day of
the week, even
after altering the
schema

Demo

4
Advanced
Dynamic
Workflow

●Identify and respond to changes in the schema of incoming data
●Scenario
○If there is a mismatch between the existing schema and the data
submitted by the user, then the user will be alerted of the schema
mismatch and be required to resolve it accordingly
●FME can automatically identify, flag, and address the schema
mismatch
●Eliminates downstream processes from being disrupted
Schema Validation App

FME Flow Workspace Apps
User uploads file
to FME Flow
Workspace App

Invalid Schema
HTML Report
Data upload
confirmation
FME Flow Workspace Apps

Schema Drift Detection

Test Validation
●VariableSetter & VariableRetriever
direct flow of data based on Schema
Validation results
●Tester will pass or fail features based
on the value set for the
“invalid_schema” variable

Schema Report Generation

Integrate Valid Features
●FeatureMerger merges the user
submitted data back in before
writing to the SpatiaLite table
●AttributeRemover cleans up
attributes created from the
VariableSetter/VariableRetriever

Demo

Poll:
Have you used the
SchemaScanner?

5
Conclusion

Summary
●Dynamic workspaces handle changing
inputs, feature types & attributes
●Various dynamic workflows serve
different purposes
●SchemaScanner enhances dynamic
workflow capabilities in FME
●Advanced dynamic workflows aren’t
limited to just reading/writing data

6
Safe
Software

Safe Software is recognized as Customers’
Choice again in the 2024 Gartner Peer
Insights ‘Voice of the Customer’: Data
Integration Tools report.

We are now recognized as Customers’
Choice in North America and Midsize
Enterprise segments.
GARTNER is a registered trademark and service mark, and PEER INSIGHTS is a registered trademark, of Gartner, Inc. and/or its affiliates in
the U.S. and internationally and are used herein with permission. All rights reserved. Gartner Peer Insights content consists of the opinions of
individual end users based on their own experiences, and should not be construed as statements of fact, nor do they represent the views of
Gartner or its affiliates. Gartner does not endorse any vendor, product or service depicted in this content nor makes any warranties, expressed
or implied, with respect to this content, about its accuracy or completeness, including any warranties of merchantability or fitness for a particular
purpose.
Read Full Report

29+
27K+
128
190
20K+
years of solving data
challenges
FME Community
members
countries with
FME customers
organizations worldwide
global partners with
FME services
30+
29K+
128
140+
25K+
years of solving data
challenges
FME Community
members
countries with
FME customers
organizations worldwide
global partners with
FME services
200K+
users worldwide
Safe & FME

7
Resources

Resources
●Dynamic Workflows Article
○Tutorial Series
●SchemaScanner Article

Get our Ebook
Spatial Data for the
Enterprise

fme.ly/gzc


Free-instructor led
training at your
fingertips.
academy.safe.com


FME Academy
Resources
Check out how-to’s &
demos in the knowledge
base
support.safe.com
Knowledge Base Webinars
Upcoming &
on-demand webinars

safe.com/webinars

Check out
our podcasts
on-demand.
featuring special guest
speakers over at EM360

Resources

8
Next Steps

Peak of Data Integration 2025
Seattle, WA | May 6–8, 2025
●Abstracts due Nov 29th, 2024
○All levels FME proficiency welcome
○15 & 25 min options (incl. Q&A)
○Special speaker rate for accepted talks
●Registration opens Sept 17th!

peakofdataintegration.com/Call-For-Presentations

We’d love to help you get
started.
Get in touch with us at
[email protected]
Experience the
FME Accelerator
Contact Us
A world where data is not just a
commodity but a catalyst for
real change.
fme.safe.com/accelerator



Next Steps

Claim Your Community Badge &
Dive into the new Community!
●Get community badges for watching
webinars
●community.safe.com
●Today’s code: HXK4GB

Join the Community today!
Next Steps

9
Q&A

Thank You
Recap of Next Steps

1Join the FME Community
2Contact us
3Experience the FME Accelerator

Please fill out our
webinar survey
Tags