Connecting to Azure SQL database from “Execute R Script” module in “Azure Machine Learning Studio”

Question

I have already set up an Azure SQL Database and loaded results into it from my local machine via R (RODBC) successfully. I can do queries in R Studio with no problem.

However, when I use the same code in the Execute R Script module in the ML studio, I get an error that the connection is not open.

The reason Reader or Import Data module is not working for my case is that I am creating an API that provides me with the information to query the database before doing analytics. The database is very big and I do not want to load the whole table and then use project columns, etc.

What do I need to change? I have tried different strings for the driver with no avail.

Any help is really appreciated

Answer 1

1. Use an Import Data module

2. Mark the query string as a web service parameter

3. You can dynamically inject the query.