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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Direct write data into...
Small and medium business | Business Central, N...
Answered

Direct write data into Business Central tables use ado

(0) ShareShare
ReportReport
Posted on by Ming Chen 190

Hi there,

Is it possible (Although I know not recommended) for external system to write data directly into BC tables (not though API)?

-Regards,

Ming

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,529 on at
    RE: Direct write data into Business Central tables use ado

    Hi

    Are you on SaaS version or on-prem? 

    I believe for SaaS it is not possible since you do not have direct access to table. I do not know about on-prem

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,307 Super User 2025 Season 2 on at
    RE: Direct write data into Business Central tables use ado

    Hi, as MahGah mentioned, if you are talking about SaaS, you can't do it. Because you don't have direct access to the database.

    In addition to API, you can also use Web Services (Odata/Soap), PowerAutomate to process data.

    For example: https://yzhums.com/20111/

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    S.Kawamura Profile Picture
    S.Kawamura 1,530 on at
    RE: Direct write data into Business Central tables use ado

    Hi,

    As MahGah said, I also believe you are not able to write BC table on SaaS without API.

    Regarding on premise, I think it is possible for external system to read/write BC table directly. BC is based on SQL server, so if external system have a proper permission to read/write BC table of database on SQL server instance.

    Actually, I know such a case in NAV (former product of BC).

    Of course, it's not recommended.

    I hope this helps you.

    S.Kawamura

  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,672 Moderator on at
    RE: Direct write data into Business Central tables use ado

    In short:

    • in BC Saas: Not Possible
    • in BC On Prem: possible but extremely highly NOT recommended!

    Never ever, on prem, write to the database directly, because you will bypass all business logic and possibly make the system completely inconsistent and unstable.

  • Suvarna Profile Picture
    Suvarna on at
    RE: Direct write data into Business Central tables use ado

    Hi Ming Chen,

    Have you worked on this? I want to import sales order from another app (web app) to Business Central directly. I don't want to use excel or manual intervention. It should be auto update data from another app to Business Central.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,529 on at
    RE: Direct write data into Business Central tables use ado

    Hi

    I believe you can use API for that. Or if it is a heavyload involved see the below article

    demiliani.com/.../

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,105 Moderator on at
    RE: Direct write data into Business Central tables use ado

    Just to add to the other answers you got here about importing sales orders into Business Central.

    There is a standard API for this that you should use or customize if it does not fully cover your needs.

    Here is a link to the doc for the standard api:

    docs.microsoft.com/.../dynamics_salesorder

  • Lubenheimer Profile Picture
    Lubenheimer 105 on at
    RE: Direct write data into Business Central tables use ado

    Hi,

    which other app is it? Maybe there is a 3rd party extension for this, or out of the box (shopify).

    Otherwise like all the others said, there are api that are capable of doing this.

    But once again: Never ever write directly into the database! You wont have fun with this!

    Regards,

    Marco

  • Suvarna Profile Picture
    Suvarna on at
    RE: Direct write data into Business Central tables use ado

    Hi Marco,

    Other application is website app where booking are done by another users. I want to import that bookings as a sales order in business central.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,105 Moderator on at
    RE: Direct write data into Business Central tables use ado
    [quote user="Suvarna"]

    Hi Marco,

    Other application is website app where booking are done by another users. I want to import that bookings as a sales order in business central.

    [/quote]

    Then the best practice will be to use a Business Central API to create and process the data in Business Central.

    Or if the web app have an API you can pull date from the Web app from AL code and have it created and processed in Business Central.

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,377

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans