Synching Api Data Into Arcgis Online Tables Using Fme

Ehance your ETL Skills with FME

What you'll learn

Efficient Data Retrieval: Students will learn how to read Feature layers hosted in ArcGIS Online and fetch API data from external sources through API links.

Data Transformation Mastery: Students will dive into the world of data transformation

Streamlined Integration with FME: Students will explore the capabilities of FME as they are guided through the process of joining both datasets

Operational Dashboard Enhancement: Students will update the Operational Dashboard components based on the new data

Requirements

To enroll in this course, students must possess fundamental skills in FME (Feature Manipulation Engine), ensuring a basic proficiency and foundational understanding of FME functionalities and workflows. Additionally, a prerequisite for participation is familiarity with ArcGIS Online, requiring students to have a basic comprehension of its functionalities, including navigation, working with feature layers, and creating operational dashboards. Although not mandatory, proficiency in ArcGIS Pro is recommended and offers a significant advantage. Students with prior experience in ArcGIS Pro will find it easier to grasp specific concepts and execute tasks within the course.

Description

Embark on a journey to seamlessly integrate API data into ArcGIS Online Tables with our comprehensive course. Discover how to read Feature layers hosted in ArcGIS Online and access API data from external sources through API links. Learn the art of fragmenting and flattening data, extracting only the essential attributes required for your GIS projects.Before joining both datasets, we delve into the crucial step of data transformation. Explore techniques such as cleaning, managing, adding and removing attributes, trimming, and implementing conditional values. Witness the power of FME as we execute these transformations seamlessly.Once the data is primed, we proceed to join both datasets and execute updates on the Feature layer using the robust FME writer. Leverage the capabilities of ArcGIS Pro to publish the updated features, including geometries, in ArcGIS Online. Utilize FME to read this updated feature, map the attributes with external APIs, and efficiently update the feature layer.The course doesn't stop there – learn how to elevate your visualization game by updating Operational Dashboard components based on the new data. Witness your GIS projects come to life as you harness the full potential of data synchronization. Enroll now to master the intricacies of data integration and propel your GIS skills to new heights.

Overview

Section 1: Introduction

Lecture 1 Course Introduction

Lecture 2 Reading | Loading Datasets

Lecture 3 Extracting Attributes of API Data and Transforming Both Datasets

Lecture 4 Merging Two Datasets & Conditional Values

Lecture 5 Managing Data Before Sending it to ArcGIS Online

Lecture 6 Writing Data into the ArcGIS Online Tables

Lecture 7 Preparing the Operational Dashboard based on the API data

Lecture 8 Finalizing the Project

Lecture 9 Conclusion

Lecture 10 A Kind Reminder

Lecture 11 Further GIS Related Courses

Lecture 12 Connect for Further Updates

This course is tailored for GIS professionals, data analysts, and individuals involved in spatial data management who are eager to deepen their expertise in Extract, Transform, Load (ETL) processes. Geared towards those with a foundational understanding of FME and ArcGIS Online, this course is especially relevant for ETL workers seeking to refine their skills in transforming both spatial and nonspatial data. Whether you're a seasoned GIS practitioner aiming to streamline your workflows or a motivated beginner keen on mastering data integration techniques, this comprehensive course provides valuable insights into synchronizing API data into ArcGIS Online Tables using FME.