I need to import data from SQL Server into Google Data Studio.
The SQL Server Management Studio is in an hosted environment which needs to be accessed through Remote Desktop.
I have access to the SQL Server Management Studio using Windows authentication in a Remote Desktop instance. I've only got read only access to the database.
So far I have tried to create snippets of SQL and manually extracted data into a Google sheet which is then used by Google Data Studio as a data source
The current approach is has limitations as I am not able to automate data extraction.
Wondering if there is facility to automate the extraction within the read only constraints of DB Access. I can get the admin's to install a third party extraction tool. But that tool or another tool needs to import data into the Google spredsheet for consumption by Data Studio. Happy to move away from the Google sheet middleware if there is a better approach