Introduction

In the previous exercises you have learned how to translate and transform data using FME. Now let's put that knowledge to use! As we covered in the Lecture section, data integration is a key requirement for modern organizations. In this exercise you will develop a workspace that solves a data integration problem in a city government scenario.

You will:

• inspect your data
• combine your datasets
• query your data to answer a question or solve a problem
• answer lab questions about the process of integrating data

This exercise will provide an example of integrating three datasets into a central database. After that you can follow similar steps to choose one additional dataset to answer another question. If you have trouble carrying out the steps you can refer to the Additional Procedures section, FME Workbench Help (also available online in our Documentation) or the community Knowledge Center.

Please continue to refer to the Lab Questions throughout, as some of the questions refer to the scenario.

Exercise Goals

• Integrate data into a single database using multiple feature types on a single writer
• Use transformers to create the desired schema in the destination database.
• Merge data using an Overlayer transformer
• Use ChartGenerator to make analyze integrated data
• Select another dataset and add it to your workspace to answer a question.

Inspect Data

To start off, inspect the data you have been given. There is a wide variety of topics and formats available. Following the instructions from Exercise 3, open some of these files in the FME Data Inspector to see what attributes they have.

For the walkthrough we will be using the following datasets:

• Bike Paths
• Neighborhoods
• Public Art

More data is available from the City of Vancouver Open Data catalogue.