This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 57.00000000000001%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Hi all,
I'm trying to pull data from MS SQL server, do some analysis, create a new table and push it back to the server, daily and automatically. Currently, I used RODBC in R Studio to achieve. I set a running schedule for my R studio to run the code everyday.
I hope to improve the whole process and I want to make the process independent on my physical PC. I searched and I found that Azure could be my solution but I'm not sure where to start.
Appreciate if anyone could help!
Where is the data currently located? That is, where is your SQL Server instance? In the cloud or on premises?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Yueli Ma ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Hi, the database is currently stored in azure cloud
Hi @Yueli Ma ,
You can refer to this blog:
Getting Started with Microsoft SQL Server on Azure
If this does not solve your problem, you can add more information.
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
SQL Agent is the tool run jobs on a schedule on the server:
https://learn.microsoft.com/en-us/sql/ssms/agent/run-jobs?view=sql-server-ver16
hi
You can refer to this options:
https://learn.microsoft.com/en-us/analysis-services/tutorial-tabular-1400/as-lesson-2-get-data?view=asallproducts-allversions
https://learn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions
https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-overview