---
title: "Set up Database connector"
slug: "set-up-database-connector-flow-data-migration"
tags: ["Flow topic"]
status: "update"
updated: 2026-09-16T13:16:39Z
published: 2026-09-22T13:19:01Z
canonical: "docs.staedean.com/set-up-database-connector-flow-data-migration"
---

> ## 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 Database connector

Set up a connector of type Database. Use this type to directly connect to an external database. This external database can be an on-premises database or a cloud database.

If you want to connect to an external database via ODBC and you run D365 F&SCM:

- In the cloud, use an Azure Relay to connect to the external database.
- On-premises, you can connect to the external database without an Azure Relay.
- On-premises, you can also connect without an Azure Relay and additionally use Direct SQL to export data to the external database.

You can also directly connect to an Azure SQL database.

[Embedded content](https://viewer.diagrams.net/?tags=%7B%7D&lightbox=1&highlight=0000ff&edit=_blank&layers=1&nav=1&title=Set%20up%20Database%20connector%20-%20Data%20migration.drawio&dark=auto#R%3Cmxfile%3E%3Cdiagram%20name%3D%22Page-1%22%20id%3D%220%22%3E7Znfc5s4EMf%2FGs%2FcPeDhh03Tx9hOeg%2FpNHeem%2FYeZVhAjUCckGO7f%2F2tQICAnhNsX5repJ1J0LJaxHc%2FWhYy8Zbp%2FoMgefKRh8Amrh3uJ95q4rrOzJnhL2U5VJb3vlMZYkFD7dQa1vQbaKOtrVsaQtFxlJwzSfOuMeBZBoHs2IgQfNd1izjrXjUnMQwM64CwofUzDWVSWa%2Fmdmv%2FDWic1Fd2bH0mJbWzNhQJCfnOMHk3E28pOJfVUbpfAlPi1bpU827%2F5WyzMAGZfM6EQhIhh5N0nEIe6lvGaaguDha7hEpY5yRQZ3aYYLQlMmU4cvAwoowtOeOinOdFUeQGAdoLKfgDGGfs8l9zphZSxSCMxhkeB7ggQPfFIwhJUf9rfSKlYahWtoh4JjUfDoq3qNb9SNhWr3vd3qAKAnvjBrUkH4CnIMUBXRIjazOdol2bYV%2BbdJCGx0N3BtF4xU3gNgN4oJPw%2FYTERMKOHL6TyGFOhsIZeUCycuWX7mO1CacR47sgQTGmIQS0oBx1XDCyAXbPCyrL8YpBJA2573qnG9nrBIlKriP5MWhgytkKiXj4pQQDfATDRUVQNg9C9f%2FX56T0c0KkUqxQyvOtULv%2FgPfq%2BiRVMGabIi%2Fn%2BUytbYMOfqyOeKRqDpFkQxTJt8MZl8Fk1sPE7WLiuOM5%2BbMA8WnzVRUz1y6zpvEGZdjm%2BOP621agCPYfwMihrGpKmVV9u001VKksL89o9lBFwYspWayUZFi6UoUcWniACt8WIK1tbhEV3RIqtoWRrVpGq41qVTEo8tZepCk0240i0BRUk3%2BcccG3GYKhoR5Xe0ICV9GY2uNeovaMw%2BdqiI%2FTKzPNWPPj2uP5waGB0FGklgKwBhlArX%2B%2FM%2FfNCHaCMpRmp%2FibtdQcQ0WS4uFFOdnY4IH%2F0s%2Boi3PivSwnRukZFhlVe0bXmH5N0WXmGCfuGydn15OGm%2FM4GbQykIWvqrO8SHVv25Cb%2Bvb%2B%2B77y6gKNpdpTWnwIB683wwRhYxU0fWbTQ5t5wyhrPeRCJjzmGWE3rXXR3Wutzx3nuTZ%2BBSkPWmaylbzXw47YZ0jbtXq1U8llpCho0CQNlx%2BDHPbXwzyp%2FkbSx64656runqZ6903gJxP%2B9H0Geyq%2F4MCezvXor%2FpCeLxSW8SuBwdjcA%2BCYnrUxUrbMPVmC9rZyZ9Wi%2BWZPJRTUYay864dck4zWRiR75XB2Oez3ouBb%2FfYqiK2pDVLezZ83ht8J8DnGOi1IJ4DX9PUdsjrtNjPBlDjY0%2FfzZ8gskWuduFRVIA0MRtL7axP7ezy1M7eqH011LoDaleej%2BDZ7feT6ud6%2BbH%2B5hLSx%2FqjS%2F8jC8%2BsXEBKCyhqb%2FUiYE4YuxEse%2Bq8t3%2FEXpj7R%2FfCk%2F5e%2F%2FPsE0%2BInv9F9tr8xKaw8zT9yfbaEdJ%2FdBPwGpDwT0PCeMa98XAqD%2F3H62vg4d3pPLj%2FEx70x4zLvzLisP1zX5Wf9o%2Bm3s0%2F%3C%2Fdiagram%3E%3C%2Fmxfile%3E)

## Related

- [Connect D365 F&SCM on-premises database with external database](/connect-d365-fscm-on-premises-database-with-external-database.md)