Skip to main content
Solved

FME Cloud and Azure SQL Server Database Table Read/Write

  • February 8, 2018
  • 1 reply
  • 5 views
austinh
Contributor
Forum|alt.badge.img+4

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
Did this help you find an answer to your question?

1 reply

G
Forum|alt.badge.img

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


Helpful Members This Week

Community Stats

31,344
Posts
118,868
Replies
38,934
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.