Migrate blobs from Oracle DB to Azure Blob

Question

I'm looking for ways to migrate images from Oracle DB to Azure Blob or Datalake. I want to use Azure Data Factory as an ETL tool to transfer the images. I couldn't understand how to retrieve these blobs from Oracle DB using a query. When I use a normal select query for the blobs column, the data comes as some random numbers as the blob is of binary format.

Answer 1

Hello @Dinesh Kumar ,

Thanks for the question and using MS Q&A platform.

As per my understanding, you are trying to migrate/copy blob datatype (Image) data from Oracle DB to Azure Blob but your data is copied as binary format rather than images. Please correct me if I'm wrong.

When you copy data from and to Oracle using Azure Data factory, the following interim data type mappings are used within the service. Which is why you are seeing this behavior.
In ADF the Oracle BLOB data type is treated as Byte[] (Please note this is only supported on Oracle 10g and higher)

Here is the related document: Data type mapping for Oracle

I doubt you can copy the image as-is using Oracle connector in ADF. In case if your images are stored in any storage or on-premise machines, then they can be copied as is using binary dataset in copy activity.

If you have a feature request for this or any additional feedback regarding this requirement, would you please log your feature request in IDEAS forum here: https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c . Product team does monitor this forum and will review the feedbacks logged and evaluate them accordingly.

Please do share the feedback link once it is posted so that other users with similar feedback can up-vote and comment on it to increase the priority of the request.

Hope this info will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators