Custom SQL Server node compatible with Microsoft Fabric.
npm install n8n-nodes-microsoft-fabricThis project is a custom n8n node designed to connect with Microsoft Fabric (Data Warehouse & Lakehouse) SQL Endpoints.
It serves as a specialized replacement for the official Microsoft SQL node, addressing compatibility issues by using the tedious-fabric library and supporting Service Principal (Azure AD) authentication natively.
- Native Fabric Support: Uses tedious-fabric to handle authentication tokens correctly.
- Service Principal Auth: Connect using Tenant ID, Client ID, and Client Secret.
- Operations:
- Execute Custom SQL Queries.
- Insert, Update, and Delete rows.
- Secure: Forces encryption and TLS 1.2+ for all connections.
To test this node with your local n8n installation:
Install dependencies:
``sh`
npm install
Start n8n and Watch for changes:
`sh``In the project folder, keep this running to auto-recompile on save:
npm run dev
To connect to Microsoft Fabric, you need to create a Service Principal in Azure:
1. Go to Microsoft Entra ID > App registrations.
2. Create a new App.
3. Note down the Application (client) ID and Directory (tenant) ID.
4. Go to Certificates & secrets and create a new Client secret.
5. Important: Go to your Fabric Workspace, click Manage Access, and add this Service Principal (by name/ID).
Contributions are welcome! To contribute to this project, please fork the repository and submit a pull request with your changes.
If you encounter any issues or have suggestions, please feel free to open an issue on GitHub.