SQL Analysis Services BizTalk Adapter

Enterprise BizTalk Adapters for SQL Analysis Services

Powerful BizTalk Adapters that allow you to easily connect BizTalk Server with live SQL Analysis Services data through standard orchestrations. Use the SQL Analysis Services Adapters to connect with Analysis Services through direct or MDX queries. Perfect for data synchronization, local back-ups, workflow automation, and more!

  • Similar to the BizTalk Adapter for SQL Server but for SQL Analysis Services report data
  • Supports meta-data discovery and schema generation for SQL Analysis Services entities.
  • Supports direct and MDX query capabilities

  download beta

CData BizTalk Adapter for SQL Analysis Services

Connect BizTalk Workflows With SQL Analysis Services Data

The CData BizTalk Adapter for SQL Analysis Services allows you to poll SQL Analysis Services data using SQL queries and stored procedures. The Adapter lets you create an XML view of your SQL Analysis Services entities and allows you to act on these entities like standard XML messages.

1-2-3 Easy Steps to BizTalk Integration

It is easy to process SQL Analysis Services entities in a BizTalk Orchestration.

  1. Configure a Receive Location.
  2. Generate the Schema for a chosen SQL Analysis Services entity.
  3. Design the BizTalk Workflow using standard BizTalk techniques.

To update, insert, or delete SQL Analysis Services entities simply configure a Send Port and bind it to receive updategrams.