|
Home > Archive > BizTalk Server > April 2007 > Biztalk Mapper for Word Document Creation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Biztalk Mapper for Word Document Creation
|
|
| micklang@gmail.com 2007-04-04, 1:17 pm |
| I have a requirement to periodically generate numerous types of
documents; XML, HTML, Flat File, Excel and Word documents based on
data in a database.
I am a relative newbie in Biztalk development. I am wondering if I
should be considering Biztalk for this solution.
It seems obvious that Biztalk would be useful for the generation of
XML and HTML however it's a little less clear how useful it might be
for producing Word or Excel documents.
Has anyone had experience with using the Biztalk mapper to translate a
database schema into documents such as 2007 Word XML or earlier
versions of word such as 2003?
| |
| Jan Eliasen 2007-04-04, 7:19 pm |
| On 4 Apr 2007 03:03:11 -0700, micklang@gmail.com wrote:
>Has anyone had experience with using the Biztalk mapper to translate a
>database schema into documents such as 2007 Word XML or earlier
>versions of word such as 2003?
Using BizTalk can be a good idea, but probably, it isn't.
Creating HTML isn't as simple as you would like it to be. You will
need a custom XSLT script to do it, as you probably wont have an XSD
describing HTML and wont be able to use the normal mapping
functionality.
Creating Office 2003 documents need to be done in code in custom
assembler pipeline components, and creating Office 207 XML will
probably also need a custom XSLT script.
Alltogether, you don't get much help. If your needs do not involve
business processes, persistence of state, etc. then I wouldn't buy
BizTalk for this kind of project.
--
eliasen, representing himself and not the company he works for.
Private blog: http://blog.eliasen.dk
Private email: jan@eliasen.dk
| |
| micklang@gmail.com 2007-04-05, 1:17 am |
| On Apr 5, 6:35 am, Jan Eliasen <elia...@nospam.nospam> wrote:
> On 4 Apr 2007 03:03:11 -0700, mickl...@gmail.com wrote:
>
>
> Using BizTalk can be a good idea, but probably, it isn't.
>
> Creating HTML isn't as simple as you would like it to be. You will
> need a custom XSLT script to do it, as you probably wont have an XSD
> describing HTML and wont be able to use the normal mapping
> functionality.
>
> Creating Office 2003 documents need to be done in code in custom
> assembler pipeline components, and creating Office 207 XML will
> probably also need a custom XSLT script.
>
> Alltogether, you don't get much help. If your needs do not involve
> business processes, persistence of state, etc. then I wouldn't buy
> BizTalk for this kind of project.
>
> --
> eliasen, representing himself and not the company he works for.
>
> Private blog:http://blog.eliasen.dk
>
> Private email: j...@eliasen.dk
I actually came to the same conclusion, however I thought it was worth
checking with people more experienced with biztalk.
However for HTML couldn't you use...
http://www.w3.org/2002/08/xhtml/xhtml1-strict.xsd
....as your schema?
| |
| Jan Eliasen 2007-04-06, 7:16 pm |
| On 4 Apr 2007 21:54:55 -0700, micklang@gmail.com wrote:
>However for HTML couldn't you use...
>
>http://www.w3.org/2002/08/xhtml/xhtml1-strict.xsd
>
>...as your schema?
Probably - haen't tried. But creating the map will be hell in the
mapper - it will require custom xslt.
--
eliasen, representing himself and not the company he works for.
Private blog: http://blog.eliasen.dk
Private email: jan@eliasen.dk
|
|
|
|
|