My client have some PII data in their on-premise SQL DB. They have only O365 SharePoint Online, they don't want to have data inside SP as list and library since their site is cloud. want to use same SQL DB. How their old (Java + SQL)application can be migrated to SPO.
If at all we put a provider hosted app, will we be able to use any of the SharePoint features like Workflows, SP Search, etc.