Entity Store in Ax 2012 R3 – Cumulative Update 11

Entity Store in Ax 2012 R3 – Cumulative Update 11

Entity Store in Ax 2012 R3 - Cumulative Update 11

When our partners and clients are looking for expert advice on AX, we are proud to offer some of the best and brightest minds in the game. Below is a mini tutorial written by one of our Enterprise Consultants, Chris Hall.

How to set up the new Entity Store in AX 2012 R3 CU11.

AX 2012 R3 CU11 Entity Store

Setup Guide

Requirements

1 AX 2012 R3

2 CU11 or KB3147499

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;3147499

3 SQL 2014 BI Edition or higher, SQL 2016 BI Edition or higher

4 SA access to SQL

5 SA access in AX

 

Setup

Create Entity Store Database in SQL

1 Open SQL Management Studio and connect to the SQL Instance

2 Right Click on the Database node and select New Database

bh-pic-1a

 

A.

bh-pic-1

B.

 

 

Enable SQL client Protocols

1 Open SQL Server Configuration Manager

2 Expand SQL Native Client 11 (or 12) Configuration

3 Right click on “Client Protocols”

4 Select Properties

5 Push “Names Pipes” & “TCP/IP” to the enabled side bh-pic-2

6 Click apply.

7 Click OK.

 

Setup ODBC connection

1 Open Control Panel

2 Open Administrative tools

3 Open ODBC Data Sources (64-Bit)

4 Pick User or System DNS and click “Add”

5 Pick SQL Server

bh-pic-3

 

6 Click “Finish” (it should say next but doesn’t)

7 Enter a name and description

>>> Recommendation: add the environment tag associated with the environment you are creating this Entity Store for. In this case “_DEMO”

8 Enter the name of the SQL server

>>> We have verified that “.” Will work if you are doing this all on the same server.

bh-pic-4

9 Click Next

bh-pic-5

 

>>> We recommend that you use Windows NT Auth

10 Click Next

bh-pic-6

 

>>> Check the “Change the default database to” checkbox, and select the Entity Store DB you created earlier. Don’t change anything else.

bh-pic-7

11 Click Next

bh-pic-8

>>> Don’t change anything here

12 Click Finish

bh-pic-9

13 Click “Test Data Source” and make sure it completes.

bh-pic-10

AX Configuration

1 Open AX

2 Goto the Data Import Export Framework module

3 Locate the “Entity Store” section

4 Click on “Define Entity Store”

bh-pic-12

5 Enter a Name and Description.

aaa1

 

 

6 Select User or System DNS based on where you created the ODBC connection earlier. Pick the name of the ODBC connection you created.

bh-pic-13

 

>>> The connection string will auto populate.

7 Click Validate

  1. bh-pic-14

Publishing and modification

Please follow the White paper to complete the AX Functional Setup.

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

 

 

 

Share on Google+Tweet about this on TwitterShare on LinkedInShare on FacebookEmail this to someone