FME Cloud and Azure SQL Server Database Table Read/Write

Question

I have created a SQL Server in in Microsoft Azure with a database containing a table with of int, float, varchar and datetime data types.

I have a workbench (2017.1) that is using a FeatureReader and the Microsoft Azure SQL Database Non-Spatial to read data from Azure SQL Server and write to a shapefile.

his works great in desktop, however when I publish this to FME Cloud I get the below error.

Module 'MSSQL_AZURE_SPATIAL' is unavailable for use with this FME edition

I know FME Cloud does not run Microsoft Server

Is there a way to read Azure SQL Server database tables in FME Cloud?

gerhardatsafe · Accepted Answer

Hi @austinh,On FME Cloud you can user our JDBC versions of all Microsoft SQL Server related Readers and Writers:https://www.safe.com/integrate/microsoft-azure-sql-database-non-spatial-jdbc/https://www.safe.com/integrate/microsoft-sql-server-spatial-jdbc/https://www.safe.com/integrate/microsoft-sql-server-non-spatial-jdbc/ Let us know if you have any other questions!

Reply

Community Stats

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded