Please enable JavaScript.
Coggle requires JavaScript to display documents.
PowerFarmingGroup Technology Data Estate - Coggle Diagram
PowerFarmingGroup Technology Data Estate
Future State
Current State
Dynamics AX 2009 ERP (2 of 3 countries) unsupported since 2021
Dynamics AX is an on-prem setup
SQL Server
BeSpoke reporting Solutions
SQL Instance hosted on-prem / Morrinsville
GAP: No SQL DBA (a developer looking after this space)
Instance supportability, Capacity, performance and availability?
Appropriate configurations setup?
Instances Health - Status?
Does current backup configuration satisfies the requirements?
What kind of data is being stored
Any PII's, PCI etc. data stored for reporting?
Are you getting the most value for money with the implementation you have?
SQL Server features involved
SQL Server Integration Services
DynamicsAx,365 and Legacy F2 Data sources ??
Database Engine
SQL Server Reporting Services
DB Engine
Analysis Services
Reporting Services
Biztalk
Getting there