Question

Hi, I have to add an image in a table. Which trasnformers that I have to use to insert image from a raster into a table? Someone can help me ?

  • 16 September 2019
  • 2 replies
  • 2 views

Badge

Hi, I have to add an image in a table. Which trasnformers that I have to use to insert image from a raster into a table? Someone can help me ?


2 replies

Badge +16

Hi @mika

This article can help you: https://knowledge.safe.com/articles/879/how-to-read-the-contents-of-a-file-into-a-database.html

The main transformer is the AttributeFileReader.

 

Badge +3

 

There are ample examples of how to CLOB or BLOB images into databases.

 

 

There are posts on this forum using a attributefilreader.

like https://knowledge.safe.com/articles/879/how-to-read-the-contents-of-a-file-into-a-database.html

 

also note

https://stackoverflow.com/questions/5613898/storing-images-in-sql-server

Reply