Direct data export from D365 F&SCM to cloud database

  • Updated on Mar 20, 2026
  • Published on Feb 4, 2026
  • 1 minute(s) read
Prev Next

Usually, export from D365 F&SCM relies on D365 F&SCM logic. Use the usual type of export for complex table structures and mapping.

With the Direct SQL connector, you can export data directly from D365 F&SCM to a cloud database. With direct export, you can simplify the data export process. It is ideal for scenarios where you want to export data from a single D365 F&SCM table to a target table in a cloud database.

Prerequisites

The target cloud database must meet these key requirements:

  • It must support complex transactions.

  • It must allow the creation of temporary tables.

Setting up direct export

  • Documents:

    • Set up an internal document as source document. For example, a document of type D365 F&SCM or Staging.

    • Set up an ODBC document as target document.
      Note: Ensure both the D365 F&SCM source document and the ODBC target document are simple and do not have complex table structures.

  • Connectors:

    • Set up a Direct SQL connector as source connector.

    • Set up a Database connector as target connector. This connector must connect to the cloud database.

  • Message:
    Set up a message with the desired mapping. Make sure the message has these specific settings:

    • The earlier created connectors and documents.

    • On the message header, in the Custom section, set the:

      • Message type: SQL

      • Message handler: BisMessageRunDirectSQL

How it works

When you run the message:

  • Data is selected directly from the D365 F&SCM database.

  • Several SQL statements are generated and executed on the target cloud database.

  • A bulk copy operation transfers the selected data into a temporary table.

  • The temporary table is used to update or insert data into the target tables in the cloud database.

Limitations

  • Mapping restrictions: Most mapping options do not work since the mapping is executed in the target database.

  • Complexity constraints: Only simple source documents and target documents are supported. Probably, complex queries do not function as expected.

  • Cloud-only support: You can only export to a cloud database.

  • Connector dependency: Always use the Direct SQL connector as the source connecter, paired with a Database connector as target connector.

Related articles