Image and audio files into a database

Is it possible to add image and audio files into database?

1 Like

Some databases will offer you the choice to have a “blob” column to store files so it will depend on which database you are using - but this also makes the database quite a bit larger and it isn’t always the most efficient choice long term. You could also consider storing them in a dedicated storage location like an Azure Blob or an Amazon Storage Bucket and store a link to their location in the database instead of putting the files directly in the database.

Can we upload the file into google drive using Gsuite activity and store that link to database?

I haven’t used the GSuite activities before personally, but a quick look at the documentation shows that the “Upload File” activity will give you the FileID in it’s output - you can store this FileID in a string column in your database and use it in the “Download File” activity later, so you can get the file out of Google Drive when you need it. You just have to make sure nobody deletes things from the Google Drive between storing it and needing it again.

Can you please explain about each step of both Azure blob and Amazon storage Bucket?

They basically work similar in functionality to Google Drive but are more aimed at Enterprise Storage, it’s just a place where you can upload files. But it tends to be cheaper to buy storage in these than to buy database storage.
Amazon calls theirs S3 Storage and each file storage area is called a bucket.
Microsoft calls their service Azure Blob Storage and their file locations are called containers.
UiPath has activity libraries for Azure and for Amazon Web Services you could try out.
If you’re working for a company they may already have an account with one service or the other, otherwise you can sign up for trial accounts and try them out.

After storing file into S3 storage or Azure Blob storage how to get the link? can you please tell me which activities are used for this to store file and get the link after that in uipath?

Again, I haven’t used either of them, but for Azure you want to check out Azure Activities Pack, and the activities you want would be “Upload Blob From File” and “Get Blob”, and for AWS you can investigate the Amazon Web Service Activities Pack with the “Upload Object From File” and “Download Object to File” activities. Both will output a path or an ID from the upload activity that you to pass to the download activity to get the file back again.