How to Publish Data entity to BYOD in D365FO

Publishing Data entity has below four major steps. Actually a batch job was written to populate the data entity. 

Major Steps:

1)     Enable Change Tracking on D365FO Database

2)     Configuration to publish data entity

3)     Publishing data entity to BYOD / Choosing the incremental load option for data entity 

4)     Create data entity export project.

Step 1: Enable change tracking on AX database by using below SQL Script

ALTER DATABASE [AxDB] SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 6 DAYS, AUTO_CLEANUP = ON)

Step 2: Configuration to publish your data entity

i)      Go to Data Management

ii)     Click “Configure Entity Export to database”

iii)      Step ii will open below screen

iv)      If the BYOD database is not configured or the above screen is empty, then please click the new button and fill all the details as shown in the below screenshots

        
 Click on “configure” and enter the  connection string details as shown in the below screenshot. For connection string you may connect your AX Admin.

You can test your connection string, by clicking on “Validate” button. Finally click on “Save” button to create your BYOD connection.


Step 3: After creating connection for BYOD database. Now it is the time to publish your data entity.

i)                    Click on the publish button which is at the top of form. In the below screenshot, it is highlighted in yellow. 

 After you click on publish, below screen will appear. And on this screen click on “Publish” button as shown in the screenshot.

If the data entity is published, below screenshot should pop-up.

ii)                    After publishing the data entity.Normally the business requirement would be get incremental data. To configure this, click “ Change Tracking” and choose options like “Enable Primary Table”,“Enable entire entity” or “Enable custom query”. For my requirement I chose “Enable Primary Table”. In this case, say if we have 100 rows for the data entity then these 100 rows will be loaded in BYOD database. And after sometime one more record is added in the data entity, then this new record will be also published. So total records will be 101. Presently I have not tested or checked the feature available with options “Enable entire entity” or “Enable custom query”.

 
After enabling the change tracking below message should pop-up.

STEP 4: Finally we need to create Export project.

i)                    To do so go to  Data Management> Export (see the screenshot).

ii)           Provide Entity Name, Target Data Format, Default refresh type, Select fields ( yet not tested) and click on “Add” button. In the Target Data Format choose the BYOD connection which was created in earlier STEP 2.

After successful creation of Export project below highlighted message should appear. And here on your data entity is fully published and incrementally data will be loaded in the BYOD database.

Thanks,

Uma

Microsoft Dynamics 365 For Finance and Operations Interview questions for freshers

I am sharing the questions that was asked to one of the fresher during  technical interview.

Questions that were asked by first company:-

1)-First of all ,what things we do in D365??(in simple word how to create model and project)
2)-what is OOPS concept and what are its properties?
3)-At the time of EDT extension ,which properties can we edit?
4)-What is static class?
5)-How do we call static class member??
6)-What are the steps to create a form?
7)-Which type of data source used in list page form pattern?
8)-Write the syntax of class?
9)-How many types of Report are there in D365?
10)-Write the steps to create Query based report?
11)-Which classes are used in RDP report?
12)-What are the extends of RDP class and Controller class?
13)-How to write the Attribute in contract class?
14)-Which attributes are used in contract class?
15)-How to create Chain of commands?
16)- Why do we create COC?
17)-Why do we use next keyword in COC?
!8)-what is the difference between D365 and AX12?
19)-What are the steps to create static query?

Questions that were asked by second company:-

1)-What is D365?
2)-What is ERP?
3)-What is LCS?
4)-What is Paging? ( Note:- I think this question should be asked to experienced candidates)
5)-Write a sql command to select the third highest mark among all the student?
6)-What is Table and what is its use?
7)-What is VM Or RDP?
8)-What is EDT?
9)-Is it possible to give the ENUM values as 1,2,3 & 100?
10)What is data loss?
11) How to create disk partition? ( Note:- I think this question should be asked to experienced candidates)
12)Why we create index?  

Hope these questions help freshers in getting job.

Thanks,

Uma