I have built one App so far that used CF&SQL server to search a Database. Now I have a new initiative. I want to build A web app that will allow my to pull up scanned documents.

By using a single tool like PowerShell, you can access your data wherever it is stored. It does not matter if it is in the cloud in an Azure SQL database or in an on-premises MS-SQL server, MySQL or ...