Excel report refresh Automation

[MamtaL]

Hello Team,
We have created Pivot table report in excel from HANA DB. We have to refresh this pivot table report once in week. When we refresh this report excel get fully occupied till refresh completes. 
So, I would like to know is there any possible solution in Alteryx where we can refresh my excel report with minimum time utilization.

kindly Note, Every refresh should fetch data from SAP HNA DB.

Thanks.

[Yoshiro_Fujimori]

Do you want to refresh your summary table without locking the source data?

If so, I would use BI tools such as Tableau and Power BI rather than Alteryx.

[nagakavyasri]

@MamtaL You can connect to SAP HANA DB through Input Data tool, recreate the same pivot as that of your excel in Alteryx and run (or) schedule the workflow when needed. This way you can directly get refreshed data from SAP HANA DB. 

Note that we are not using excel in this process but recreating the same functionality in Alteryx.