BizTalk Is All We Do
Microsoft Gold Partner since 1995
Messaging solutions are often complex to implement and frequently fall short of expectations. TwoConnect has developed a messaging solution which leverages the database itself as the messaging engine and allows data to flow directly to and from the database. The solution is based on Microsoft’s SQL Server Service Broker; an enabler to building secure, reliable and scalable applications. Service Broker is part of the database engine, and therefore administration of these applications is part of the routine management of the database. Service Broker provides queuing and reliable messaging for SQL Server, and is used for applications using single SQL Server instance and/or applications that distribute work across multiple instances.
Service Broker's features provide a number of significant benefits to database applications:
:: Enhances application performance and simplifies administration
:: Simplifies application development via message ordering and coordination
:: Workload flexibility is achieved through loose application coupling
:: Related message locking allows more than one instance of an application to process messages from the same queue without explicit synchronization:: Applications scale easily to meet message volume through automatic activation
:: Transferring Data Between BizTalk & SQL :: Microsoft's SQL Server Site :: Microsoft's SQL Server Community :: SQL Server Integration Services Overview:: Jesus Rodriguez Blog