---
title: "Set up an external document for SQL integration"
slug: "bc-set-up-an-external-document-for-sql-integration"
description: "Create external documents from SQL databases by defining tables and fields through various Business Integration Solutions. Follow our step-by-step guide!"
tags: ["BC", "BIS", "Business Central", "Business Integration Solutions", "Task"]
updated: 2026-06-25T09:59:05Z
published: 2026-06-25T09:59:05Z
canonical: "docs.staedean.com/bc-set-up-an-external-document-for-sql-integration"
---

> ## 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 an external document for SQL integration

Use this task to create an external document based on the tables and fields of a SQL database.

## Steps

1. Go to the documents list page. Depending on the solution:
  - For Connectivity Studio: go to **Departments** > **Business Integration Solutions** > **Connectivity Studio** > **Design** > **Documents**.
  - For Notification Management: go to **Departments** > **Business Integration Solutions** > **Notification Management** > **Design** > **Documents**.
  - For Replication Management: go to **Departments** > **Business Integration Solutions** > **Replication Management** > **Publications** > **Design** > **Documents** for publications, or **Subscriptions** > **Design** > **Documents** for subscriptions.
  - For EDI Studio: go to **Departments** > **Business Integration Solutions** > **EDI Studio** > **Design** > **Documents**.
2. Select **New**.
3. On the **General** FastTab:
  - Select type as **External** and provide a document number and description.
  - Select subtype as **SQL Server**. This enables the **SQL Server Connection** FastTab.
4. On the **SQL Server Connection** FastTab, to connect to a SQL database:
  - Either specify **SQL Server Name** and **SQL Database Name**, or
  - Specify **SQL Connection String**.
5. Select the **Design** button to open the setup page.
6. Add tables and fields to define the document structure manually.

> [!NOTE]
> **Note**
> 
> When adding fields, the wizard shows which fields the SQL database marks as mandatory. Select the key fields.

A new external document structure (with subtype **SQL Server**) is created and added to the document list page.

## Related

- [Set up an external document](/bc-set-up-an-external-document.md)