My client currently has an internal application dedicated to budget preparation and real estate invoicing.
The solution was historically developed using SAP BPC Microsoft, with a SQL Server On-Premise database. Over the years, due to the volume of data and the complexity of the calculations, a significant part of the calculation processes and business logic has gradually been moved directly to SQL Server, particularly through stored procedures and SQL-based processes.
As a result, BPC currently handles only part of the overall functionality, while a significant portion of the processing is performed upstream in SQL Server.
The Group is now looking to replace this solution and is considering a target architecture based on Board SaaS.
Before starting the implementation phase, a scoping and estimation phase is currently being carried out in order to identify and compare the different possible architecture and integration approaches.
I am responsible for this scoping phase and would therefore like to validate with you the architecture options recommended by Board.
Question
In this context, what would be the most appropriate and efficient architecture for integrating data and processes from an On-Premise SQL Server environment into Board SaaS?
More specifically, we would like to understand:
- What are the native options for connecting an On-Premise SQL Server environment to Board SaaS?
- Which Board components or mechanisms would you recommend for this type of integration?
- How should existing SQL processes be handled, particularly stored procedures and calculation rules, when these need to remain upstream in SQL Server?
- What are the best practices regarding data volumes, performance, loading frequency and data flow management?
- Is it possible to design an architecture where part of the processing remains in SQL Server while the resulting data is transferred to Board SaaS?
- What network, technical or security prerequisites should be considered on the On-Premise side?
