Solved

FME Cloud and Azure SQL Server Database Table Read/Write

8 years ago
February 8, 2018
1 reply
61 views

+4

austinh
Contributor

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?

Best answer by gerhardatsafe

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!

View original

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.