Back to integrations
Confluent and Microsoft SQL connection
Save yourself the work of writing custom integrations for Confluent and Microsoft SQL and use n8n instead. Build adaptable and scalable Development, workflows that work with your technology stack. All within a building experience you will love.
Ways to connect Confluent and Microsoft SQL
Create a new workflow and add the first step
In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
Create your own Confluent and Microsoft SQL connection
Create custom Confluent + Microsoft SQL automations by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
Supported API Endpoints for Confluent
GET
List authors
Retrieve a list of authors sorted by title.
/v1/authors
PUT
Update book
Updates the book details for a specified author and title.
/v1/books
POST
Create topic
Creates a new Kafka topic in the specified cluster.
:8090/kafka/v3/clusters/7cteo6omRwKaUFXj3BHxdg/topics
GET
Get topic partitions
Retrieve the partitions of the specified topic.
:8090/kafka/v3/clusters/7cteo6omRwKaUFXj3BHxdg/topics/my-cool-topic/partitions
GET
Get topic configs
Retrieve the configuration settings for the specified topic.
:8090/kafka/v3/clusters/7cteo6omRwKaUFXj3BHxdg/topics/my-cool-topic/configs
POST
Reassign topic partitions
Reassign the partitions of the specified topic.
:8090/kafka/v3/clusters/7cteo6omRwKaUFXj3BHxdg/topics/my-cool-topic/partitions/-/reassignment
POST
Set user profile data
Sets the profile data for a user in Slack.
/api/users.profile.set
GET
Get user profile
Retrieves the profile data for a user in Slack.
/api/users.profile.get
POST
Delete user photo
Deletes the photo of a user in Slack.
/api/users.deletePhoto
POST
Set user photo
Sets the photo of a user in Slack.
/api/users.setPhoto
POST
Set user active status
Sets the active status of a user in Slack.
/api/users.setActive
To set up Confluent integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to Confluent to query the data you need using the API endpoint URLs you provide.
See the example hereThese API endpoints were generated using n8n
n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Confluent official documentation to get a full list of all API endpoints and verify the scraped ones!
Microsoft SQL supported actions
Execute Query
Execute an SQL query
Insert
Insert rows in database
Update
Update rows in database
Delete
Delete rows in database
Confluent and Microsoft SQL connection details
Other integrations with Microsoft SQL
FAQs
FAQ
Can Confluent work together with Microsoft SQL in n8n Lab?
Can I use Confluent’s API with n8n Lab?
Can I use Microsoft SQL’s API with n8n Lab?
Is n8n Lab a secure option for connecting Confluent with Microsoft SQL?
How do I start building Confluent + Microsoft SQL automation in n8n Lab?
Need help setting up your Confluent and Microsoft SQL connection?
Discover our latest community's recommendations and join the discussions about Confluent and Microsoft SQL connection.
A widely adopted workflow orchestration workspace trusted by technical teams including
Why use n8n to connect Confluent with Microsoft SQL
Build complex workflows, really fast
