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

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?
LVL 1
apollo7Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chinmay PatelChief Technology NinjaCommented:
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.
Pratik SomaiyaApplication Development AssociateCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Feridun KadirPrincipal ConsultantCommented:
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.
apollo7Author 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?
apollo7Author Commented:
Thanks for the solution, the string map issue has been resolved.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.