Replace SQL Server Reporting DB with Paas DB
We currently have a daily extract (GL to subledger drill down) that gets loaded into a SQL Server DB and the business interrogate via an Excel SQL Server add in. We are going to use an Oracle Paas DB instead - any tips in terms of Architecture? Currently each night a flat file is produced (BI Publisher) for the current month that replaces the current months data in the SQL Server DB.
0