We are looking to modernize our Data & Analytics landscape. We have SAP BW & BusinessObjects(BO)/Analysis for Office(AO) now and planning to move lake house based technology for DW and Power BI reporting. How was your experience in terms if 1. Analysis for office(AO) replacement? 2.Overall change Management?
SAP Analysis for Office is not something I would recommend after using it for five years. It is clunky. The Azure storage/ Azure Data Factory/Power BI is perhaps the way to go. You can easily convert your SAP BO SQL to direct query method in PBI.
On what scale would you say has your company experienced an impact from executive orders and decreases in US government spending?
Significant22%
Noticeable/Meaningful38%
Minimal31%
Zero9%
View Results
We have 3 node sql cluster with one node on different location for DR. Also, the availability group setting is synchronous+auto failover on the two nodes that's on the same site, and asynchronous+manual failover on the DR node. Aside from network/latency, what are other reasons why we should/should not use synchronous/auto failover on all our nodes?
SAP Analysis for Office is not something I would recommend after using it for five years. It is clunky. The Azure storage/ Azure Data Factory/Power BI is perhaps the way to go. You can easily convert your SAP BO SQL to direct query method in PBI.