fareedexcel
Member
Hello,
I'm working in an entity where the IT security is top notch and we don't use any cloud based application in the entity. We do have an ERP and I used to download the data from the ERP and do the analysis.
Is there any way I can export the Oracle ERP HR Employee Master data on a real time basis in an excel sheet. We are using Excel 2019. Basically whenever there are new updates or changes in the ERP, it should get reflected in the Excel template so that the template will have a real time data.
As I plan to create real time dashboards or connect the data with Power BI. What would be the sustainable solutions ? Looking forward for your guidance.
I'm working in an entity where the IT security is top notch and we don't use any cloud based application in the entity. We do have an ERP and I used to download the data from the ERP and do the analysis.
Is there any way I can export the Oracle ERP HR Employee Master data on a real time basis in an excel sheet. We are using Excel 2019. Basically whenever there are new updates or changes in the ERP, it should get reflected in the Excel template so that the template will have a real time data.
As I plan to create real time dashboards or connect the data with Power BI. What would be the sustainable solutions ? Looking forward for your guidance.