Skip to content
  • There are no suggestions because the search field is empty.

How to enable Sellforte to fetch your data from Microsoft Azure SQL

Sellforte can fetch data directly from a customer-managed Microsoft Azure SQL database. This setup is recommended for recurring datasets where customers manage their own relational data models.

All data fetched from Azure SQL must follow the relevant Sellforte data specification.

Overview of the setup

The Azure SQL fetch setup consists of two steps:

  1. The customer prepares a table or view in Azure SQL that matches the Sellforte data specification

  2. The customer grants Sellforte read-only access to the database

Once completed, Sellforte fetches the data automatically on an agreed schedule.

1. Preparing your data in Azure SQL

Customers are responsible for preparing the data in Azure SQL in a format that matches the Sellforte data specification.

This typically means:

  • Creating a table or view

  • Ensuring required fields, data types, and granularity match the specification

  • Including only the data that should be ingested by Sellforte

How the data is modeled or transformed is fully up to the customer.

2. Granting Sellforte access

Sellforte requires read-only access to the Azure SQL database.

Access is typically granted by:

  • Creating a database user for Sellforte

  • Granting SELECT permissions on the required tables or views

Sellforte does not require permissions to insert, update, delete, or modify schemas.

Completing the setup

Once the data is prepared and access has been granted:

  • Share the connection details (host, database name, credentials) securely with Sellforte

  • Sellforte validates access and schedules automated data fetching