SSDN - Create XML from XSD schema file, based on SQL Server 2012 data

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Paulo Afonso

Subject: Create XML from XSD schema file, based on SQL Server 2012 data
Author: Paulo Afonso
Date: 13 Dec 2013 08:13 AM

Hi all

Our needs for a particular Add-on of our product. We want to communicate to our customer and supplier thru XSD Schema/XML:
a) Based on XSD schema XML file, connect to several columns on several tables and database, and produce a XML file.
b) First we try SSIS solutions but for each XSD we must develop a VB or C# solution, is not the impossible, but we are looking/searching for a tools that design XQuery for we import and execute that for each XSD schematic file, our costumer send to us.
c) We have a web site, design/development/testing with ASP.NET MVC C# on VS 2012, and SQL Server 2012
d) Our views are also using JQuery UI and JQuery tools also.

So we did the download and we like the UI and products, but we can't found an example to do what we wand, because of that we put this topic for any one send clue or path for cut time for my testing.

Paulo Afonso

Yitzhak Khabinsky

Subject: Create XML from XSD schema file, based on SQL Server 2012 data
Author: Yitzhak Khabinsky
Date: 13 Dec 2013 09:51 AM
Originally Posted: 13 Dec 2013 09:44 AM

Hello,

Your question is really about high level design to generate, validate and transmit data feeds in XML format.
Everything could be easily done by using combined power of both MS SQL Server SSIS 2012 and Stylus Studio.
I am doing it on daily basis.

Here it the outline of steps you need:
1. Run one generic SSIS Data flow task with the XML Destination.
It will produce one raw XML file on the file system.
2. For each customer/supplier run SSIS XSLT transformation Task in a loop.
XSLT is designed, developed and tested in Stylus Studio.
This step will produce desired data feeds in the XML format.
3. Run XSD validation SSIS task against the XSD contract.
XSD is designed, developed and tested in Stylus Studio.
4. Run SSIS FTP/SFTP task to transmit the XML data feed to the final destination.

This way you will have a reliable ETL engine/solution without developing a VB or C# based application or components.
All future changes will be done in XSLT and XSD layers which are text files in Stylus Studio.

Ivan Pedruzzi

Subject: Create XML from XSD schema file, based on SQL Server 2012 data
Author: Ivan Pedruzzi
Date: 13 Dec 2013 10:48 AM

Hi Paulo,

One option would be using the DataDirect XQuery engine which allows to query relational data and produce XML.

Have a look at the tutorial here
http://www.stylusstudio.com/videos/ddxqdemo/datadirectxquery.html

The documentation is located under the Stylus Studio folder
c:\Program Files (x86)\Stylus Studio X15 XML Enterprise Suite\Components\DataDirect XQuery\books\ddxquery\ddxqug\ddxqug.pdf

We can setup a conference call, at your convenience to discuss your requirements.

Ivan Pedruzzi
Stylus Studio Team
stylussupport@ivitechnolgoies.com

Paulo Afonso

Subject: Create XML from XSD schema file, based on SQL Server 2012 data
Author: Paulo Afonso
Date: 18 Dec 2013 04:50 AM

Thanks I will procedure as you advice.

Paulo

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.