Dynamics AX

Entity Store in Ax 2012 R3 – Cumulative Update 11

Subscribe Here!

Back to main Blog
Steve Shebuski, VP of Digital Strategy

Guiding businesses through their digital transformation journey

Our supply chain expert, Chris Hall, has highlighted the process of how to set up a new Entity Store in Microsoft Dynamics AX below:

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

Requirements

  1. AX 2012 R3
  2. CU11 or KB3147499
  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

 

bh-pic-1

 

null

 

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 sidebh-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 Serverbh-pic-3
  6. Click “Finish” (it should say next but doesn’t)
  7. Enter a name and description
    1. >>> 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
    1. >>> We have verified that “.” Will work if you are doing this all on the same server.bh-pic-4
  9. Click Next
    1. >>> We recommend that you use Windows NT Authbh-pic-5
  10. Click Nextbh-pic-6
    1. >>> 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 Nextbh-pic-8
    1. >>> 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” sectionnull
  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
    1. >>> The connection string will auto populate.
  7. Click Validate
bh-pic-14

 

Publishing and Modification

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

If you have questions about Entity Store in Microsoft Dynamics AX 2012 R3, contact us.  

Have Questions? We are here to help.

Stay up to date