FME Version
Introduction
Overview of Spatial Support on the Cloud databases
Relational Databases
Managed Databases
Industry-standard databases are offered as a managed service on AWS, Azure and Google Clouds.
Database | Cloud Platform Support | Spatial Support | FME Support |
---|---|---|---|
Maria DB (10.1.2+) |
|
Spatial Types: Geometry and Geography |
Read, write and query. |
MySQL ( 8.0+) |
|
Spatial Types: Geometry and Geography |
Read, write and query. |
Oracle |
|
Oracle Spatial and Oracle Locator are supported. Spatial Types: Geometry and Geography |
Read, write and query. |
PostgreSQL |
|
All clouds support the PostGIS extension. Spatial Types: Geometry and Geography |
Read, write and query. |
SQL Server |
|
Spatial Types: Geometry and Geography |
Read, write and query. |
Cloud-Native Databases
Cloud-native databases are created by the cloud provider and designed from the ground up to take advantage of the cloud architecture. They are often based on existing database engines but are optimized for the cloud with a focus on performance and availability.
Database | Spatial Support | FME Support |
---|---|---|
AWS Aurora RDS |
Aurora supports both the MySQL and PostgreSQL database engines. Both of these engines have spatial data types enabled (PostGIS and MySQL). Spatial Types: Geometry and Geography |
Read, write and query. |
Azure SQL Database
|
This is based on SQL Server with the same spatial support. Spatial Types: Geometry and Geography |
Read, write and query. |
Google Cloud Spanner |
Cloud Spanner does not natively support geospatial queries. Google’s S2 library can be leveraged which uses spherical geometry and is used by Google itself on Google Maps. |
Read, write and query. |
Data Warehouses
Data warehouses are interactive data analysis tools for large datasets. They enable you to store large volumes of data cheaply and provide an interface where you can run fast complex queries across the data.
Database | Spatial Support | FME Support |
---|---|---|
AWS Athena |
Type of Support: Native |
Query S3 datasets |
AWS Redshift |
Type of Support: Native |
Read, write and query. |
Google Big Query |
Type of Support: Native |
Read, write and query. |
Snowflake |
Type of Support: Native |
Read, write and query. |
NoSQL Databases
NoSQL databases allow huge amounts of unstructured data to be stored and queried.
Database | Spatial Support | FME Support |
---|---|---|
AWS Dynamo DB |
No support. There used to be support for geohashes via an official library, this project has now been archived. |
Read and write. |
Azure Cosmos DB Documentation
|
Type of Support: Native |
Read, write and query. |
Google Cloud Firestore |
Type of Support: No native support, but there is support for geohashing via a 3rd party library. |
- |
Comments
0 comments
Please sign in to leave a comment.