Set up a connector of type Direct SQL.

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 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.


Standard procedure

1. Click Connectivity studio - Integration design.
2. Click the Connectors tab.
3. Click New.
4. In the Connector field, type a value.
 

Note: You are advised to not include, in the connector name, the name of the application to which you connect. Use the Application field to define the applicable application for the connector.

5. In the Project field, enter or select a value.
6. Define the applicable application for the connector. For a Direct SQL connector, for example, select a 'D376 F&SCM' application.
  In the Application field, enter or select a value.
 

Note:

  • You can only select an application that is defined for the applicable project. You can define project applications on the Projects page.
  • You can type any existing application name, whether it is defined as a project application or not. If the typed application is not defined as a project application, it is automatically added to the project applications.

7. In the Connector type field, select 'Direct SQL'.
8. Sub-task: Set properties.
  8.1 Expand the Properties section.
  8.2 Define from which companies the data is selected.
  In the Use of Company field, select an option.
 

Note: If you select 'Source companies', in the Source companies section, define the desired source companies.

9. Sub-task: Select custom handler.
  9.1 Expand the Custom section.
  9.2 For a Direct SQL type connector, the standard handler class is BisConnectorDirectRead.
This handler class exports data directly from D365 F&SCM to a cloud database. The class does not use any D365 F&SCM logic. It uses SQL statements to send data to the target. Always use it in combination with this message handler class of type SQL: BisMessageRunDirectExportToSQL.
You can use a customized handler class. To do so, extend the standard handler class.
  In the Handler field, you can enter or select a custom handler class.
10. Sub-task: Define source companies.
  10.1 If in the Properties section, the Use of company field is set to Source companies, define the source companies for the connector.
In this case, the data is taken from these source companies only.
  Expand the Source companies section.
  10.2 Click New.
  10.3 In the Company accounts ID field, enter or select a value.
11. Close the page.

Provide feedback