How to Insert PDF or Word Document as BLOB data type into a MySQL Database?

Help Studio
1

I have connected to a MySQL database using the ODBC connector and the Connect package activity and am able to use the Execute Non Query activity to insert regular data types like text/string and integer, but I cannot figure out how to insert a pdf or word document as a BLOB data type into the database.

I would also like to be able to extract the BLOB data type back into the form it was originally in (pdf/word doc) eventually as well.

Any help would be greatly appreciated!

2

That’s possible. BLOB storage can store the PDFs and hold the link to them, they will be helpful to get it back.

Below videos shows the process

If you are receiving any error while the operation, do let us know the error

3

this is a bit confusing to me and I’m not sure how to implement this in UiPath. Could you please provide more clarification?