Entity Store for Dynamics AX 2012 R3

Entity store is a feature that will enable an Administrator or a Power user to create a data store dedicated for Reporting and Analytics. We call this database “Entity store” and it’s a database optimized for Reporting purposes.

As an existing customer of AX, you can create an Entity Store in Azure or within your data center using a SQL Server 2016 or SQL Server 2014. Entity store can be (and should be) hosted on a separate database server than the one that hosts the transactional database. Therefore, you do not need to upgrade the transactional database to the latest versions of SQL server in order to deploy Entity store.

Entity store enables a user to choose “Entities” (that are built on top of AX tables) to be moved into the Entity store. Entity store enables scheduling incremental refresh jobs with the use of AX batch framework. This makes it possible to feed data from AX database to the entity store on a small batch basis in the background

http://download.microsoft.com/download/2/4/2/242608B8-7F6A-4A59-8AAF-545EBE5166BA/Entity store Microsoft Dynamics AX 2012 R3.pdf


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s