Tutorial: Getting Started with Cloud Databases

Introduction

In FME 2020+, we introduced several new connections to cloud databases. A cloud database typically runs on a cloud platform and allows the user access to the database as a service. These cloud databases provide scalability and ensure that the database is highly available. There are several cloud database services out there, and we are continually adding support for these.

Each of the following cloud databases are available to read and write in FME. For specifics on which cloud databases support spatial, please see Overview of Spatial Support on the Cloud Databases:

• Amazon RedShift

• Google Cloud SQL

• Microsoft Azure SQL

• Oracle Autonomous Databases

• Snowflake

Articles

To learn how to use these formats in FME, please see the following articles.

Reading and Writing Amazon Redshift Spatial Databases

Learn how to connect to Amazon RedShift as well as how to read and write data

Connecting to Oracle Autonomous Databases

Learn how to connect to Oracle Autonomous Databases using Wallet credentials in FME 2020.1+

Reading and Writing Oracle Autonomous Databases

Learn how to read and write data to Oracle Autonomous Databases in FME 2020.1+

Using FME & the Snowflake Database Format

Learn how to connect to Snowflake non-spatial databases

Using Snowflake Spatial in FME for Geospatial Data

Learn how to use the new Snowflake Spatial reader and writer in FME 2020.1+

Documentation

Amazon RedShift

Google Cloud SQL Spatial

Google Cloud SQL Non-Spatial

Microsoft Azure SQL Spatial

Microsoft Azure SQL Non-Spatial

Oracle Autonomous Spatial

Oracle Autonomous Non-Spatial

Snowflake Non-Spatial