Multiple Data Sources

[hamza1075]

I am trying to connect to 2 different SharePoint lists (live data) then 2 different Excel sheets and then 1 more live connection with EDH. 

My question is, I want to create an extract for all these sources in Alteryx. How do I go about it?

[Qiu]

@hamza1075 
If I may ask, what is the significant meaning for one extraction?

I image it would be difficult even possible/

[hamza1075]

I am trying to have LIVE data coming for my Tableau dashboard. I cannot connect all of them together in Tableau so I figured, Alteryx might be able to do it

[Qiu]

@hamza1075 
In our case, we use Alteryx to get and process all the necessary data, and Alteryx Server runs the workflow on a shedule basis.
So the Tableau gets the scheduled updated data.

[hamza1075]

correct. How would I get this done? 

[mceleavey]

Hi @hamza1075 ,

An input tool each for the Excel sheets, the Sharepoint Input tool to connect to the lists (you will need the path to be to the parent folder of the lists, and you will need your security key depending on the Sharepoint version) and an API connection using the Download tool to connect to EDH.

This will allow you to bring all the data simultaneously into Alteryx.

M.

[hamza1075]

I am very new to Alteryx, is there an online guide/video that could help me get these steps done? Thanks again for replying