Having plentiful choices can sometimes be overwhelming, hence it is the job of a specialist/advisor to use a select tools from a plethora of tools and tailor-fit them to the analytical of the customer.
Let's explore key data options available in Dynamics 365 for Finance and Operations, Enterprise edition (AX) for usage in analytics:
- AX database (AXDB): This is the main OLTP transactional of your Dynamics 365 Finance and Operations, Enterprise edition in SQL.
- AX data warehouse (AXDW): This is the Entity Store data warehousing, available of the box for Dynamics 365 for Finance and Operations, Enterprise edition in SQL. It supports in-memory processing for large-volume scenarios. It uses aggregated data entities and SQL Non-Clustered Column Store Index (NCCI).
- Read only secondary (ROS): This is a read-only database used by the Application Object Server (AOS) to redirect certain read-only queries off the transactional database.
- Bring Your Own Data Warehouse...