Import OneDrive files into SQL Server Management Studio 19 and have a Refresh Schedule

Question

Hi there,

I am looking to import OneDrive files into SQL Server Management Studio 19 and set up a hourly/daily refresh schedule. I currently have this SQL Server connected to a Tableau Server. My overall goal is for the SQL server to be on a refresh schedule that is feeding into my Tableau server/workbooks. Currently, I only see the option to import flat files that are either Text or CSV.

Any assistance would be greatly appreciated.

Thanks,

Answer 1

You will likely first need to configure a Linked Server in SQL Server that can connect to the Tableau Server. Then you can refer to objects in it, like they are in another SQL Server.

Tableau server seems to use PostgreSQL to store data. If that's the case, you should be able to follow standard instructions for creating a linked server to PostgreSQL. Here's an example.

https://www.mssqltips.com/sqlservertip/3662/sql-server-and-postgresql-linked-server-configuration-part-2/

Make sure you can run T-SQL queries in SSMS (connected to SQL Server) to get the data.

Then you should create a SQL Server Agent job that runs on a schedule, and executes the commands to copy the data from the Tableau Server to SQL Server.

Answer 2

Hi @Dylan Chaney,

Please check this thread, it said that you can map the One Drive for Business cloud drive on Windows follow the below steps and then you may iuse the file with option to import flat files in SSMS.

And then you could schedule the agent job in SQL Server to refresh the data.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.