Node subcategory: Action in an app
The idea is:
Azure Dedicated SQL Pools do not support the multi-row insert syntax that regular SQL Servers support. Thus, using the existing “Microsoft SQL” node with a Dedicated SQL Pool fails when attempting to insert multiple rows. The idea is to provide an option to use a Dedicated SQL Pool in the existing node or add a specific node for Dedicated SQL Pools to allow multi-row inserts.
My use case:
We currently use Azure Data Factory to transform and store data from our Salesforce instance to the Dedicated SQL Pool in order to provide data for advanced reporting. With the proposed functionality, we would be able to migrate this process to n8n which opens many more possibilities that ADF doesn’t provide.
I think it would be beneficial to add this because:
We’re probably not the only ones using a Dedicated SQL Pool and this would make n8n a bit more interesting for enterprise users.
Any resources to support this?
Are you willing to work on this?
Unfortunately, I have no technical expertise in this field.