Need to be able to push data from ADF into a RDBMS in the workspace

[TonyWildish-BH]

We have the base+ADF workspace that Benedict created for us at the beginning of the project. This gives us linkage to the ADF shared service, which is how the data team are able to push CSV files into the shared storage.

We need an extension to this capability, so we can push data into a MySQL or AzureSQL database in the workspace as well. It's enough to have MySQL, we can copy the solution for AzureSQL later.

This probably means we need to extend the MySQL template, since these services may be deployed/destroyed multiple times throughout the lifetime of the workspace. The CSV solution can rely on the existence of shared storage in the workspace, which is why it could be created at the same time as the workspace.

Alternatively, maybe a DB connection can be provisioned with the workspace, and the MySQL DB can be plugged into it when they are started up?

So we need investigation to propose a solution, and then an implementation.

Acceptance criteria:

• Solution proposed
• PoC implemented
• Documentation completed
• Deployment to MVP