Micro-Integration for Microsoft SQL Server

The Solace Micro-Integration for Microsoft SQL Server writes data from a Solace event broker into Microsoft SQL Server database tables. The Micro-Integration for Microsoft SQL Server provides you (as an operator) a flexible and efficient way to load Microsoft SQL Server application data from your Solace-backed, event-driven architecture and the event mesh. The Micro-Integration is deployable standalone or in redundancy modes of Active-Standby or Active-Active to allow for high availability and horizontal scaling of your data movement. Each instance of this Micro-Integration supports up to 20 individual, concurrent workflows (queue-to-table pipeline), minimizing the number of Micro-Integration instances deployed and managed.

Spring Framework technologies make it easy to configure the Micro-Integration, perform advanced logging capabilities, and export live metric data to external monitoring solutions.

To get started deploying a Micro-Integration locally or within a container, see:

• Deploying Your Self-Managed Micro-Integration

• Modifying the Container Configuration

For common configuration details, see:

• Configure Your Self-Managed Micro-Integration

• Operate Your Self-Managed Micro-Integration

• Adding a Monitoring System

For configuration settings that are specific to Microsoft SQL Server, see:

• Configuring Connection Details

• Message Batching

• Message Headers

• Dynamic Producer Destinations

• Asynchronous Publishing

• Troubleshooting