web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Data Entity - staging ...
Finance forum

Data Entity - staging table

(0) ShareShare
ReportReport
Posted on by megha18 522

Hello,

I have created a Data Entity using FMCustomer.I added a record using X++ in data entity.

1)This data is inserted in the target table directly or staging table?Where it adds the record?

I am observed on insertion that staging table doesnt has any data in it.

2)If No, how can I add data in staging table first, so that I can validate there and then insert in target table.

Categories:
Development / Customization / SDK
Data Integration
I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    If you insert data via x++, it will be added directly in the target table.

    Staging table is meant to be used when integrating with external applications using Data management projects.

    You can of course insert into staging table with x++, but then you have to handle invoking the staging to target -logic as well. Usually you would not need to use staging table if you insert data via x++. Do you have such business requirement?

  • megha18 Profile Picture
    megha18 522 on at

    Hi Nikolas,

    Yes , I want to add data in staging table and then validate.Is there any link available that u can share.

  • nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    Unfortunately I don't have any links for such documentation.

    Could you describe your functional requirement a bit more? Where is the data coming from? Should some user have access to the staging table, or how is the validation and import handled?

    Normally each staging table entry is related somehow to a data project in Data management workspace. This means that the staging data can only be accessed via the existing data projects. And if you use the data projects, you don't need x++ code.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans