I am looking for an integration framework for building and managing SOA composite applications consist of exposing web services, calling 3rd party web services, performing business logic and invoking database.
It is similar to Sun Java Composite Application Platform Suite (Java CAPS).
I am not familiar with CAPS but it sounds very similar to Microsoft's Enterprise Library http://msdn.microsoft.com/en-us/library/dd203099.aspx
It sounds like you may be looking for BizTalk from Microsoft.
However, depending on how heavy-duty your needs are, you may find that they are served by the basics of WCF (the Microsoft platform for developing web services and clients for them), plus the features of Windows Workflow Foundation (WF). One can easily use WF to create programs that consume one or more web services. You can also expose a WF workflow as a service itself.
Where the composite application is focused on a process like an ETL, you can do a lot with SQL Server Integration Services, which can consume web services as part of an overall ETL task.
See the WCF Developer Center and the WF Developer Centers on MSDN .