Jaime Olivares
asked on
SAS-like access for a SQL Blob field
Currently I use Azure's Shared Access Signature to access blobs directly, bypassing the web service. This has a great benefit in performance, as the blob doesn't need to travel from the storage to the web service, and then to the client application.
I want to know if there is a similar mechanism in MS-SQL: I would like to provide an accessible and secured URI to the client app, so it can download an specific blob straight from the database. I don't want to provide unlimited access to the DB, like OData, just to a specific record.
Thanks in advance.
I want to know if there is a similar mechanism in MS-SQL: I would like to provide an accessible and secured URI to the client app, so it can download an specific blob straight from the database. I don't want to provide unlimited access to the DB, like OData, just to a specific record.
Thanks in advance.
ASKER
Hi Mike, I am not asking for an Azure solution, but a non-Azure solution. That's the whole point of my question.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My question points to a SQL-Server solution (if exists, that's the question), not to a file server solution. That's why I mention the term Blob instead of file.
I saw that, Jaime, but you are asking for a URI for data retrieval and that implies either a file of some sort or else a software layer to translate the URI into some sort of retrieval mechanism. IMHO a straight file would be easiest, as you could secure that most easily using available tools. Have you thought of using SQL Server's FileStream to keep the blobs in the filesystem and allowing the applications to get them directly from there?
ASKER
Sorry, I still don't have my answer, I would like to know if there is a ready-made product to expose SQL blobs in a similar way as Azure's SAS. After I get it, I may look for other alternatives.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hth
Mike