is it possible to achieve real time data capture using Alteryx? does Alteryx cache data after storing in memory?
If you have Server, you can schedule your workflow to run hourly to extract data from your database! If not, your data will be “live” whenever you run the workflow as it will execute at that time.
Caching data here doesn’t make sense since you want it to be more “live” - you can cache in Alteryx on a given run, but then it will be the data of that run, not any refreshed data
datetimenow() and datetimestart() in the formula tool might be what you are looking for
Hi,
I am using Azure SQL Database which store transactional database like an OLTP system, I have another schema in same database which store historical transactional data on daily basis. my goal is to achieve near real time reporting using Alteryx and Tableau. How to do it?
How Alteryx can data frequently like in near real time like from OLTP system?
IDK, if this can be done. I have never worked with Tableau.
But if you have Alteryx server you can trigger the workflow via the API. If you can get Tableau to trigger it when you hit refresh then that is as near real time as it gets.
Or as @alexnajm suggests have it run on a schedule, that would definitely be the easiest to implement.
@vibhusharma77 has this been resolved?
