Posted   by 

Contoso Data Download

Dynamics Contoso Database data set Link to download. Can someone send the 2 database link for Dynamics AX Contoso dataset for test purposes please.

  1. Contoso Sample Access Database Download
  2. Contoso Data Download Free

Agenda

Introduction

Contoso Sample Access Database Download

Hi mates, today we will load demo data for the Dynamics AX.

Before any company starts using Dynamics AX, the Implementation team gathers requirements and prepares data to be loaded to the system. When Dynamics AX is installed, the data is usually entered manually into Dynamics AX. For example, for the Financial module, it is required to prepare and set up Main accounts and Financial dimensions; for the Inventory management module, it is required to prepare and set up Products list, Warehouses, Pallets, etc.

03 Contoso Potluck Solution.xlsx View Download. View Download: Lesson 9 Sort Data on Multiple Columns in a Table. From this machine you could extract the data by creating a SQL backup or using the Test Data Transfer Tool. The links to customersource and partnersource are mentioned in my blog about the solution demo pages (bottom of the article). Contoso headquarters is a corporate campus on the outskirts of Paris with dozens of buildings for administrative, engineering, and manufacturing facilities. All the Contoso datacenters and its internet presence are housed in the Paris headquarters. The headquarters has 25,000 workers.

(When I have time, I will prepare lessons for each of these modules with the information about what is required to be set up. I think this can be helpful for the Functional consultants.)

Preparing and setting up data for Dynamics AX is not an easy task. What is a plus, Microsoft has prepared the demo data to be used for the educational purposes. It is the best option for beginners to start working and gain experience with Dynamics AX.

In this training lesson, we will import the demo data that is prepared by Microsoft.

Download the Demo data and the Data transfer tool

If you have access to the Partners source or Customer source, you can find demo data here. It is recommended to use Internet Explorer for downloading it. Click the Contoso Demo Data, enable the Microsoft File Transfer Manager, specify a folder, and click OK.

The MicrosoftDynamicsAXR3DemoDatav2.exe file with the demo data is downloaded.

You also need access to the Partner or Customer source to download the Microsoft Dynamics AX 2012 Test Data Transfer Tool. You can download it from Dynamics Lifecycle services tools.

By the way, it’s hard for me to explain why this tool is not listed on the Product release page near the demo data.

The AX2012TestDataTransferTool zip archive is downloaded.

Load demo data to Dynamics AX

  1. The demo data file is an archive. Run the MicrosoftDynamicsAXR3DemoDatav2.exe, specify a folder, and wait until the data is extracted.
  2. Unzip the AX2012TestDataTransferTool archive. Run the AX2012TestDataTransferTool.msi. Install the Microsoft Dynamics AX 2012 Test Data Transfer Tool.
  3. Under Control Panel > Services, stop the AOS instance.
  4. Run the command prompt: Run > cmd (right-click > Run ad administrator).
  5. In the command prompt, change the default directory to the directory with the data transfer tool file:
    cdlocation_of_the_data_transfer_tool
    In my case, it has the following view:
    cd C:Program Files (x86)Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)
  6. In the command prompt, enter the following command to import the demo data:
    dp.exe import location_of_demo_data Name_of_AX_business_database SQL_ServernameInstanceName
    In my case, it has the following view:
    dp.exe import D:DemoDataMicrosoftDynamicsAXR3DemoData MicrosoftDynamicsAX PC-VMYMSSQLSERVER12
    This process usually takes up to 2 hours. It depends on your RAM and SQL server setup. In my case, the SQL server takes all available RAM and uses 15Gb of Virtual RAM.
    By the way, at the end I have 3 Errors. I have checked the Log and saw that the data for the last three tables was not loaded (BATCHHISTORY, RETAILTRANSACTIONSALESTRANS, SOURCEDOCUMENTLINE) because of “the ‘PRIMARY’ filegroup is full”. I think this issue takes place because of insufficient disk space. While my disk C shows 50GB free space in reality it can be null because of the pagefile.sys file or Virtual RAM that do not always update the used disc space.
    These tables are not critical for me. So I leave them empty.
  7. Under Control Panel > Services, start the AOS instance.

You can also find similar walkthrough for the data load process here.

Deploy SSRS reports

Let’s try to run any Dynamics AX report, for example the Balance list.

Go to General ledger > Reports > Transactions > Balance list. The Balance list dialog opens, click OK.

The message “Error while setting server report parameters. Error message: The item ‘/DynamicsAX/LedgerTotalAndBalanceList.Report’ cannot be found. (rsItemNotFound)” is shown.

Contoso onmicrosoft or user contoso

This means that the LedgerTotalAndBalanceList report is not deployed to the SSRS server. Let’s deploy the LedgerTotalAndBalanceList report to the SSRS.

Make sure that the Reporting server is installed on your computer. Go to the Windows Services and find the SQL Server Reporting Services service. If you cannot find one, you need to install it. You can find some useful info about the installation and configuration of SSRS here.

It is also required to install the Reporting Services Extensions component when you install the Dynamics AX.

First of all, we need to validate the Report server configuration in Dynamics AX. This configuration is created automatically when the Reporting Services Extensions component is installed.

  1. Run Dynamics AX as administrator.
  2. Go to System administration > Setup > Business intelligence > Reporting services > Report server. The Report servers form opens.
  3. The form contains the following values:
    • Configuration ID = pc-vmyMSSQLSERVER12
    • Server name = PC-VMY (name of your computer)
    • Report manager URL = https://pc-vmy/Reports_MSSQLSERVER12
    • Web service URL = https://pc-vmy/ReportServer_MSSQLSERVER12
    • Microsoft Dynamics AX report folder = DynamicsAX
    • Application Object Server name = 02@PC-VMY
      Click the Validate settings button. The “DynamicsAX – success” info appears. If an error appears, probably you need to create the Dynamics AX folder on the SSRS. To do this, click the Create report folder button. There are no errors in my case.

Let’s go to the Report manager (https://pc-vmy/Reports_MSSQLSERVER12) and make sure that the DynamicsAX folder exists.

The configuration is ready. Let’s try to deploy the reports.

To deploy reports, you can use the Windows PowerShell. I prefer deploying reports from the Dynamics AX Application object tree (AOT).

  1. In the Dynamics AX window, click Ctrl + D. The Application object tree opens.
  2. Go to the SSRS Reports > Reports
  3. Set the cursor at the first report and press Ctrl + A to select all reports.
  4. Right-click and select Deploy Element.

I get the error: “The deployment was aborted. You do not have privileges to deploy to server: pc-vmy. For deployment, you must have administrative rights to the SQL Server Reporting Services (SSRS) server. Contact your administrator to deploy.”.

It is because I had the Remote Registry service stopped. Go to the windows services and run the Remote Registry service.

Redeploy reports. I have no more errors, reports are deployed successfully and the Balance list report can be successfully run.

Data

Summary

As you can see the process is not complex, but a bit time consuming. Let’s check the results.

  1. Open Microsoft Dynamics AX.
  2. In the right lower corner, click the DAT company name. The Select company form opens.
  3. Select for example the USSI (Contoso Consulting USA) company and click OK.
  4. Go for example to Accountsreceivable > Common > Customers > Allcustomers. The Allcustomer form has customers records already.

We have loaded the demo data. From now on, you can start working with Dynamics AX: reviewing different modules, entering purchase or sales orders, etc. Dynamics AX covers a lot of different business processes. It is a very interesting world where you can learn both business processes and their implementation in Dynamics AX.

I am planning to prepare the DAX trainings for the DAX 2012 Financial, Trade & Logistics, and Production modules with this demo data. Please follow me on Facebook to be aware about the training updates 😉


2)Extract It,at some location let’s assume our path to extract it is C:R3DemoData
3)As It will get extracted it will created asubfolder, under directory which is specified in step#2 i.e. C:R3DemoData DynamicsAXR3DemoData
4)Download Test Data transfer Tool frominformation source; here goes the path for it.
6)Open Dynamics AX and Press Ctrl+D to Open AOT. Rememberif you do not have license file you would not be able to open AOT. It’s must toload license file and sync DB, before you can access AOT.
7)Import an XPO File, named as MetadataXMLGenerator.xpo
This file can be found at theinstallation location of Test Data transfer Tool. Commonly under normalcircumstances it would be available at following path
C:Program Files (x86)MicrosoftDynamics AX 2012 Test Data Transfer Tool (Beta)
8)After you import the XPO, go to Jobs, you willsee a job created, in the AOT. The name of job will be MetadataXMLGenrator. Runthis job and wait until you get an info message like this

Contoso Data Download Free

“Metadata xml file is created andhere is full path to filec:UsersSMCSERAppDataLocalTempMetaData.xml”
Copy the whole message ofinfolog and paste it somewhere in notepad etc. It’s important
10)Copy a file on following path
File from: path mentioned instep#8
File to: Test Data transfer Toolinstallation pathList
Typically as C:Program Files(x86)Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)[Lists]
12)Run the following command
DP.exe IMPORT “PATHOF EXTRATCED DB WHICH IS DISCUSSED IN STEP 2AND 3. USE PATH OF STEP 3; SEE EXAMPLE BELOW” MicrosoftDynamicsAx
DP.exe IMPORT “C:R3DemoData DynamicsAXR3DemoData”MicrosoftDynamicsAx
Note: if you are getting connection error for database, try command as under
dp.exe import C:R3DemoData DynamicsAXR3DemoData MicrosoftDynamicsAX
13)That’s all, it may ask you some option, as Y/Yand n/N. and it will keep on showing you status that how many tables areremaining and how many got error during import, as shown below. At this moment you may have rest or coffee untilit’s done :)