Usually, export from D365 F&SCM relies on D365 F&SCM logic. You can use this type of export for complex table structures and mapping. With the 'Direct data export from D365 F&SCM to cloud database' feature, 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.