Hi All,
Need help in getting data from Excel files on the local machine to the SQL server.
I have a few excel files on my local machine (can be in a shared location), want to import those files into SQL server (On-prem). or Destination can tableau extract as well.
The workflow works fine on my local machine, but I want to deploy onto the server and schedule a job to run every day.
This should be a simple task(I think) but not able to find any online guide to get this done.
In the power bi, Azure world we use Data gateway to get local/on-prem data.
Do we have something similar for Alteryx? I read somewhere we need to create .bat file with user credentials in the "Events" section.
Can you please help with the steps to get this working?
Regards,
Arvind
