How to nest XML output in a SQL SELECT statement

A customer asked, “How to format [or structure] XML Output to include a sub-group inside the XML”. The customer is using a SELECT statement with FOR XML, and wants to nest an XML element such as the following: Before <BusinessPartner>     <Key>1234</Key>     <Name>Test Company</Name>   </BusinessPartner> After <BusinessPartner>     <Key>1234</Key>     <CompanyDetails>           <Name>Test…

1

Data Explorer and Office 365 – Create a report from an Azure SQL Database source

This post shows how to create an Excel task report from a “Data Explorer” query connected to a Windows Azure SQL Database instance provisioned with Access 2013. In Access 2013, you can create an Access web app. When Access 2013 provisions the web app to Office 365, it creates a complete Windows Azure SQL Database…

0

10 reasons to use Data Explorer from the Community

Before starting this post, I want to thank all of our customers for commenting about how much they love Data Explorer. Keep on giving us your feedback, we are reading your comments, and plan to create more tutorials based on your comments. In fact, please let me know what tutorials you would like in our…

2

Data Explorer: An introduction to table relationships and the Expand operation

This post is an introduction to table relationship concepts as related to the Data Explorer Expand operation. The Expand operation makes combining data together really easy. One of the goals of efficient data management design is to remove duplicate data that is contained in a data source. To achieve that goal, a data management application…

1

Migrate a WCF Data Service to Windows Azure

I just published a step by step guide to publish and consume a Windows Azure WCF Data Service connected to an Azure SQL Database using Azure Access Control Service (ACS) claims-based authentication. The content has several lessons about exposing an Azure SQL Database on Windows Azure as a WCF Data Service. You can download a…

0

How to publish Excel worksheets to Azure SQL Database using SSIS

Introduction In this tutorial you will learn the fundamentals of how to upload an Excel worksheet to Azure SQL Database using SQL Server Integration Services (SSIS). This tutorial assumes prior experience with SSIS and Windows Azure SQL Database. Upon completing this tutorial, you will have a sample database on Windows Azure published from an Excel…

0

AdventureWorks OData sample with Named Resource Streams

As a continuation of my previous blog post, the AdventureWorks QueryFeed OData sample now shows how to implement Named Resource Streams to stream AdventureWorks product images. In addition, I added the ability to select Named Resource Streams (product images) within a business workflow to the QueryFeed activity, and render a stream in a Word document. The AdventureWorks…

1

OData QueryFeed workflow activity (Refresh)

I just updated the OData QueryFeed workflow activity sample. My original entity properties TablePartPublisherDesigner had style names hard-coded in the activity designer. This was okay to demonstrate the concept of an activity publisher. However, I wanted a way for the client hosting the workflow designer to supply style names for any TablePartPublisherDesigner.  After some research,…

0

Introducing the OData QueryFeed workflow activity

As a continuation of my previous blog post, I created an OData QueryFeed workflow activity sample. The sample represents an end to end data movement application utilizing a number of technologies including Using LINQ to project OData entity XML to entity classes. Creating custom workflow activities. Creating custom workflow designers containing OData schema aware expression…

0

Announcing the AdventureWorks OData Feed sample

Overview As a continuation of my previous blog post, we created a live AdventureWorks OData feed at http://services.odata.org/AdventureWorksV3/AdventureWorks.svc. The AdventureWorks OData service exposes resources based on specific SQL views. The SQL views are a limited subset of the AdventureWorks database that results in several consuming scenarios: CompanySales Documents ManufacturingInstructions ProductCatalog TerritorySalesDrilldown WorkOrderRouting We will be…

1