---
title: "Set up Direct SQL connector"
slug: "set-up-direct-sql-connector"
tags: ["Task topic"]
updated: 2026-03-20T07:42:17Z
published: 2026-03-20T17:44:08Z
canonical: "docs.staedean.com/set-up-direct-sql-connector"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.staedean.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Set up Direct SQL connector

Set up a connector of type **Direct SQL**.

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.

### Steps

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

> [!NOTE]
> **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 'D365 F&SCM' application.

In the **Application** field, enter or select a value.

> [!NOTE]
> **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.
  1. Expand the **Properties** section.
  2. Define from which companies the data is selected.

In the Use of **Company** field, select an option.

> [!NOTE]
> **Note**
> 
> If you select '**Source companies**', in the **Source companies** section, define the desired source companies.
9. Sub-task: Select custom handler.
  1. Expand the **Custom** section.
  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.
  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.
  2. Click **New**.
  3. In the **Company accounts ID** field, enter or select a value.
11. Close the page.

## Related

- [Direct data export from D365 F&SCM to cloud database](/direct-data-export-from-d365-fscm-to-cloud-database.md)