Question

How to upload any file to column in SQL Table as BLOB or NCLOB

  • 14 November 2018
  • 1 reply
  • 8 views

Badge

I have a file GeoJSON. I need upload this file as s BLOB or NCLOB(as just binary file) to column in Azure SQL DB Table. How i can upload this file with FME? Please share you knowledge about it


1 reply

Badge +8

Hi @bkolubenka, you should be able to do a simple translation from "GeoJSON" (Reader) to "Microsoft Azure SQL Database Spatial" (Writer)( NOTE: Spatial format is required as it will store the geometry in GEOM column by default).

Reply