When we replicate data from D365 Online to Azure SQL using Data Export Services we are not getting certain data

apollo7
apollo7 used Ask the Experts™
on
Dynamics 365 CE 9.0 Online, Azure SQL, Data Export Services

We are trying to replicate data from our D365 Online data to Azure SQL using Data Export Services.  We are running into a problem with the following data:

Data Export Problems  
   *PULLING STRINGMAP
   *OPTIONSET TABLE
   *STATE CODE/STATUS CODE

We are not getting this data using DES.  

Any suggestions?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
Hi apollo7,

As these are not standard entities, they will not be included in data dump. In such cases, you can either create(and then maintain) a separate table with necessary values. For example,

Entity Name | Field Type | Label | Label Language Code |Value

This could be a sample table structure, you can tweak it as per your needs and you can populate it by querying your data dump and extract necessary values by querying your existing data.

Regards,
Chinmay.
Application Development Associate
Commented:
The Option Set, Status Code, State Code etc tables are automatically configured whenever you set up a DES. Have you checked the configurations?

Regards,
Pratik
Feridun KadirPrincipal Consultant

Commented:
Yes, Pratik is correct, additional tables for optionset and status/status reason labels are automatically created. You will need to join to those tables to get the text label. This is different from filtered views in Dynamics On-Premises.

The reason for the additional tables is to allow for all enabled languages in the Dynamics instance. With the filtered views the language of the label matched the language of the logged in user. However, with DES, the user could be anyone so the person writing the query has to choose the language for the labels in the query.

Author

Commented:
Thanks for the information.

I have another question: can anyone tell me where to locate the Linked Server connection setups with ACTIVE DIRECTORY = INTEGRATED in DES?

Author

Commented:
Thanks for the solution, the string map issue has been resolved.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial