XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Feature Requests » ETL and data mapping
Conferences Close Tree View
- Stylus Studio Feature Requests (1192)
-> + XML formatter option request (3)
-> - Could Pipeline input scenario ... (1)
-> + XML Traversal in XSLT Mapper (2)
-> + Email not in HTML as expected (3)
-> + My SS Open [tools]==>.[option... (3)
-> + Fonts in Stylus Studio (2)
-> - Fix the check for concurrent s... (1)
-> + Stylus is showing the error fo... (2)
-> - XML editor (1)
-> + Unable to see filename in sche... (2)
-> + Unable to connect to JVM (2)
-> - Stylus Studio forum questions (1)
-> + User Interface - X16 Enterpris... (2)
-> + Stylus Studio High DPI support (2)
-> + target xsd includes and import... (2)
-> + XML/EDIFACT Schema (3)
-> + Options to control whether BOM... (2)
-> + Snippets and/or Emmet integrat... (2)
-> + internal error accessing metho... (2)
-> + Have lost Stylus Studio licens... (3)
-> + XTDE1425: Cannot find a matchi... (2)
-> - Flatten Schema XSD (1)
-> + NEED TO RUN THE CONVERSIONS ON... (2)
-> + Generate different combination... (3)
-> + Display Full Path to File in T... (3)
-> + Conversion from a custom XML f... (2)
-> + memory management (3)
-> + Stylus Studio Pro x15 unattend... (5)
-> - Allow copying file URL from Pr... (1)
-> - Undocking and resizing preview... (1)
-> - Stylus Studio and DataDirect (1)
-> + Basic Navigation in UI (2)
-> + Support Grid View for XML frag... (3)
-> + Some requests from a power use... (7)
-> - Enable Selecting installation ... (1)
-> + Enumeration drop down in grid ... (3)
-> + Showfull path of node at curre... (2)
-> + SSL Connection failure: javax.... (2)
-> + Can Stylus Studio generate X12... (2)
-> + ACORD 1203 XML Generation (6)
-> + version 10-1 is not supported ... (2)
-> + 5010 files (2)
-> - Support for Microsoft Web Serv... (1)
-> + Feature Request: Support Schem... (2)
-> + Error for missing module stops... (2)
-> + Saxon 9.3 (2)
-> + Enquiry about XSD documentatio... (2)
-> + SS2011 ICD file open error (2)
-> - Cargo IMP message support (1)
-> - help page aware sense-x for cu... (1)
-> - bulk tidy (1)
-> - wish: XML tidy (1)
-> + Project limitations (2)
-> - Feature Request - Better Contr... (1)
-> + Feature Request - Remembering ... (2)
-> - Feature Request - Correct Prev... (1)
-> - Feature request (bugfix?): rem... (1)
-> + Spellcheck when 'Wrap Lines' o... (5)
-> - Feature fix request: "File mod... (1)
-> - Bug: yellow infobox does not d... (1)
-> - Feature request: "Open file" d... (1)
-> - Bug: Indenting multiple lines ... (1)
-> + Feature request: remove limita... (3)
-> - automate the convert EDI To XM... (1)
-> - Feature request: Horisontal sc... (1)
-> - Feature speedup: "find as you ... (1)
-> + Bug (?): Page up/down don't go... (3)
-> - Feature request: "Open file" d... (1)
-> + Search Preview Window (2)
-> - Feature request: Upper/Lower c... (1)
-> - Feature request: Toolbar locki... (1)
-> - Feature request: File Explorer... (1)
-> - Editing Large Text Files and c... (1)
-> - Stylus Studio Support of XIncl... (1)
-> + Implement Web Service Provider... (3)
-> - Modifying Cargo schemas (1)
-> + Manual for Professional Editio... (3)
-> - Improved support for xsd:exten... (1)
-> - Parameter value for processing (1)
-> - Graphical endpoint support (1)
-> + Find in all files function (3)
-> + Missing Close All (2)
-> - ambigous selection (1)
-> - Very Complex Flat File convert... (1)
-> + multiple file select (5)
-> + Tidying XML (4)
-> + open file filter amnesia (2)
-> + Indenting without tabs (2)
-> + Do stylus studio provide any S... (2)
-> - http://www.milyn.org/schema/ed... (1)
-> + Error running on UNIX (12)
-> + Converting a CATDrawing to a B... (5)
-> + Sense:X - Remembering recently... (3)
-> + Parser for XML Schema 1.1 (4)
-> + Request: Additional pane/windo... (2)
-> + Bug for Mark all in find dialo... (4)
-> - XML Schema (XSD) diagram edito... (1)
-> - permanently assign a font to a... (1)
-> + newline=null in EDIFACT conver... (3)
-> + support for SOAP 1.2 binding i... (3)
-> + XML Publisher bug: table colum... (3)
-> + Meansfor printing Tree view, f... (4)
-> + Use of stylus (2)
-> - XSD Generation Engine (1)
-> + Enter font name directly in XM... (2)
-> + XSLT Report design (3)
-> + how to call java script funct... (2)
-> + taking comma out from a node. (2)
-> - Schema documentation for local... (1)
-> + Help on INVOIC D.96A EAN 008 (2)
-> - UI Themes (1)
-> + Does stylus support CARGO IMP ... (2)
-> - display of schema instance per... (1)
-> - Help unistalling (1)
-> + Ability to sort project nodes (2)
-> - XBRL (1)
-> + Handle unc path filenames (4)
-> - Editor tabs too narrow (1)
-> + Where is the Convert to XML Mo... (3)
-> - Do not display upgrade offer t... (1)
-> - merge table cells in the repor... (1)
-> + drawing a pdf doc (4)
-> + Trial Version (5)
-> + Is it possible to convert XML ... (2)
-> - keyboard shortcuts to switch b... (1)
-> + Port to OSX (2)
-> - Target Doc Double Click Set Te... (1)
-> + Xquery Feature - External Data... (2)
-> + .sef support (2)
-> - Bug in Validation (1)
-> - Healthcare Survey: We need you... (1)
-> - Feature to collapse specific e... (1)
-> + How to set custom Tools by com... (2)
-> + Flat file to XML (2)
-> + WYSIWYG feature (3)
-> + EDI Conversion (2)
-> + "XML Report", I'm forced to ch... (10)
-> + Decimal format support in XML ... (2)
-> + command line conversion (4)
-> + Including white spaces in xsl:... (2)
-> - Better WSDL Validation (1)
-> - WSDL editing feature requests (1)
-> + custom xml conversion (10)
-> - XML Schema Awareness Differenc... (1)
-> + can't create "DB to Xml" data ... (2)
-> + probleme representation d'une ... (3)
-> + Question about StylusStudio (2)
-> + New to eXcelon (5)
-> + description fields within adap... (2)
-> + Schema Editing (2)
-> + providing alternative styles f... (2)
-> + French support (2)
-> + bug when opening files (5)
-> + EDIFACT - CARDIT/91/2/UN (2)
-> + Firefox support (2)
-> + Xml diff tool bug/configuratio... (4)
-> + decimal separator (2)
-> - Renaming Queries in the XPath ... (1)
-> - Output & Export (1)
-> + hide output window (3)
-> + Converting Text file to XML (2)
-> - Recursive definitions not pres... (1)
-> + update from Stylus to a Databa... (6)
-> + Allow non XML files to be adde... (2)
-> + EDIFICE D97A (2)
-> + Richer XML debugging (2)
-> - Simultaneous text view option ... (1)
-> + A simple complaint (8)
-> + output window always leaves yo... (2)
-> + xpath debugger (3)
-> + profiler (2)
-> + show mandatory elements in map... (2)
-> + Fine-tuned Expand and Collapse... (6)
-> + Stylus Installer (stylus-studi... (2)
-> + Sub equation numbering (3)
-> + Undo in schema diagram editor ... (3)
-> + 2007 Prof R2 Xalan support (2)
-> + Conversion of one xml file to ... (2)
-> + DTD definition enhancement (2)
-> + Xquery How to (11)
-> + MarkLogic Integration (5)
-> - Request: Persist Grid View col... (1)
-> - auto link all nodes (1)
-> - right click conditional link i... (1)
-> + sequelink 5.4 does not appear ... (4)
-> + Problem saving file after view... (4)
-> + Bug:  xFEFF added afte... (2)
-> + File dialog button for My Docu... (3)
-> + Stylus Studio XML Publisher an... (2)
-> + XML to XML (6)
-> + Enhancements To XML Diff (9)
-> + Refactoring in XSLT 2.0 (2)
-> + Relational DB (4)
-> + Sense:X and enumerations (5)
-> + Creating XSL from HTML and XML... (2)
-> + Treatment of binary data and a... (4)
-> + Stylus Studio XML Publisher im... (2)
-> + Stylus Studio XML Publisher ta... (2)
-> + Stylus Studio XML Publisher ta... (3)
-> + Search and replace in Stylus S... (2)
-> + Additional rule/functions (17)
-> + Error in dateTime editing (2)
-> + javax.net.ssl.SSLKeyException... (2)
-> + XJC Problem (4)
-> + Validation of XHTML with Saxon... (2)
-> + Sense:X - Visual Studio Does i... (3)
-> + Tab Navigation / Order (2)
-> + Showing of ComplexTypes on Dia... (2)
-> + Previewing Documents In Extern... (3)
-> + Is there any copyright for the... (2)
-> + Problems defining my parent an... (2)
-> + custom processor and xslt (2)
-> + how can i declare a variable a... (2)
-> + Looping and grouping in a text... (2)
-> + Please generate a new download... (8)
-> + Installer request (3)
-> + XSLT MAPPER : copy all attribu... (2)
-> + IBM JDK support (3)
-> + Specifying Values For XSL Para... (2)
-> + Add support for OpenXML - Alto... (2)
-> + Associate Schema to Document -... (3)
-> + MySQL via JDBC? (4)
-> + German language support planne... (2)
-> + Bug: Built-In XSL Processor an... (4)
-> + Bug: XSL Editor Drag-n-Drop No... (2)
-> + document types for standard do... (4)
-> + .NET support (4)
-> - Let the user switch of message... (1)
-> - My XPATH Query Editor Suggesti... (1)
-> + XPath Query Editor (2)
-> + Support for trusted SQL connec... (3)
-> + New Version (6)
-> + Updating Stylus Studio (3)
-> + drop-down selection text in XS... (2)
-> + set the default xmlns prefix (2)
-> - Eclipse again (1)
-> + Find window should stay on top (3)
-> + graphical representation for v... (4)
-> + Invalid Characters (5)
-> - jump to source location does n... (1)
-> + Close Project? (2)
-> - Eclipse-Style Tabs for source ... (1)
-> + Semantic Studio: More than Sim... (4)
-> + xml to xml ,apping (2)
-> + XSD Description in Mapper View (4)
-> - XSLT Editor Window - Template ... (1)
-> + Convert directory tree to XML (2)
-> + Convert from xml to csv (or ot... (2)
-> + Find Dialog Typo (2)
-> + Edit : Go To Parent in XML edi... (2)
-> - Processing has been cancelled (1)
-> + xsl:sort bug in xsl:apply-temp... (2)
-> - suppress creation of empty tar... (1)
-> - Why Stylus Studio doesn't supp... (1)
-> + Hyphen (Dash) in XML Comment E... (8)
-> + XML Difference Documents - Can... (3)
-> - Persistent tree view collapse ... (1)
-> + Web Services HTTP Custom Heade... (5)
-> + Option to pretty-print preview... (2)
-> - Quickly paste in an XML from p... (1)
-> + .Net codegeneration from xml p... (3)
-> + SVG WYSIWYG Editor (3)
-> - Better Ability to Rearrange Pr... (1)
-> - Inherit or Copy Associated Sch... (1)
-> - Professional: I Hate Seeing En... (1)
-> - Want to Jump From Project Wind... (1)
-> + mapping restricted data types (2)
-> + background/hidden windows in s... (3)
-> + querying a container in Berkel... (2)
-> - Allow editing of relational DB... (1)
-> + DDL Generation from XSD (4)
-> - Want Command and Context Menu ... (1)
-> + XSL:FO Processor to Support .N... (3)
-> - intend java source (1)
-> + Impove the built-in XSLT proce... (3)
-> + Dynamic CSV to XML (5)
-> + Web services for transfer file... (3)
-> - Automatic display of XML schem... (1)
-> + Deleting Multiple Tags (2)
-> + Urgently required html to xml (2)
-> + XML Compare (2)
-> + XSLT Output to Editor (2)
-> + Toggle On/Off Display of Names... (2)
-> - auto open output file of scena... (1)
-> + auto create variable for liter... (2)
-> + export/import settings/prefere... (4)
-> - http://www.tortoisecvs.org/ (1)
-> - How to create Webservice for t... (1)
-> + 837 Professional (6)
-> + Create C# or Java classes (2)
-> + Font display request (3)
-> - Project Window - Auto Sort on ... (1)
-> - Adding extra attributes (1)
-> + Separate Comment and Uncomment... (2)
-> - Moveable Tabs (1)
-> - Fixing odd data (1)
-> + Find - across all open files (2)
-> + Open File Tabs - reorder (2)
-> + Wrap lines - no thanks (2)
-> + convert files to xml (2)
-> + Go to Definition in Schema edi... (3)
-> + XSLT Unit Testing (3)
-> + Bug in Stylus XQuery Mapper (t... (2)
-> + timing issue with a xslt trans... (2)
-> + Progress Meter for large XML f... (2)
-> + XSLT Transformations (2)
-> + Parse Bug for external dtds (6)
-> + App wiht XML (2)
-> + Problems with keyref (3)
-> + How do i call javascript:onloa... (4)
-> + XSLT Template View (2)
-> + Build non-SOAP XML requests? (29)
-> + UNICODE XML files (5)
-> - ETL and data mapping (14)
-> ->ETL and data mapping
-> ->ETL and data mapping
-> ->ETL and data mapping
-> ->ETL and data mapping
-> ->ETL and data mapping
-> ->ETL and data mapping
-> ->ETL and data mapping
-> ->ETL and data mapping
-> ->ETL and data mapping
-> ->RE: ETL and data mapping
-> ->RE: ETL and data mapping
-> ->RE: ETL and data mapping
-> ->RE: ETL and data mapping
-> + XSLT WYSIWYG Fixes (14)
-> + Xpath Queries (7)
-> + automatic sibling collapse (3)
-> + xslt (2)
-> + regarding xslt (2)
-> + creating placeholders in word ... (2)
-> + Enhancing Schema Diagrams. (5)
-> + Print selected text (4)
-> + xsl conversion (2)
-> + Allow .conv files to exist in ... (2)
-> + Provide support in Stylus API ... (2)
-> + Eclipse Plugin (3)
-> + support for EDIFACT messages p... (3)
-> + How do I download Stylus Studi... (2)
-> + Program will not start (2)
-> + Standard WIZARD for EDIFACT CO... (13)
-> + XInclude Parser (2)
-> + Save search and replace dialog... (2)
-> + Copy text from XSLT Preview Br... (4)
-> + Use Stylus Studio to edit Styl... (3)
-> + Re-order existing scenarios (X... (2)
-> + Preserve line wrap setting (2)
-> - how xslt designer will produce... (1)
-> + XML Schema, XML instance and X... (2)
-> - Wizard for XSLT Mapping needed (1)
-> + Navigation in "Preview in Tree... (8)
-> + XSLT Variable Sense-X Populati... (3)
-> + bug while creating xml from xs... (2)
-> + Does not handle Chinese very w... (4)
-> + Set source path specific to ea... (3)
-> + Plug in a newer version of Xal... (4)
-> + .JPG Filename Initialization i... (4)
-> + Tree Structure through ID hier... (2)
-> + Better support for HTML Table ... (2)
-> + JAXB (3)
-> + Help migrating a Stylevision x... (3)
-> + RDF/OWL Browser/Editor (6)
-> + Single User Licensing (3)
-> + Request Old version 6.2 (5)
-> + Java runtime system (2)
-> + Connecting to Gupta sql databa... (4)
-> + Expand All on Tree (6)
-> + Help on Top (yuch) (3)
-> + output document that describes... (4)
-> + Autoload changed files? (3)
-> + Auto Formatting keeps removing... (3)
-> - XML line wrapping (1)
-> + Dual Display then Single Displ... (3)
-> + SQC (2)
-> + Please let me use the normal O... (4)
-> + NEED HELP (3)
-> + Webservice Proxy Settings (3)
-> + Open Source alternative to Biz... (2)
-> + Create DTD schema from multipl... (2)
-> + problem reading wsdl (3)
-> + problem in getting operation (3)
-> - problem getting operation list... (1)
-> + Copy and Paste in File Open Di... (2)
-> + Perforce support (3)
-> + The prefix 'xmlns' cann't be b... (2)
-> + Dont use System.setProperty in... (2)
-> + Copy from Preview IE (3)
-> - Extending the template selecti... (1)
-> + Add multiple files to a projec... (7)
-> + Support for XUL/XBL/CSS (3)
-> + Copy Xpath Query to Clipboard (2)
-> - Lookup tables (1)
-> + New JSP File (2)
-> - CTRL + B (1)
-> + Source Safe Checkout (2)
-> - layout (1)
-> + autocheck externally changed f... (2)
-> + tree view to text view (4)
-> - Option to show the full file p... (1)
-> + Save Untitled Files? (2)
-> + Move Tabs (2)
-> + Project management (3)
-> + Do automatic fo generation (as... (2)
-> + Grid editing enhancement (2)
-> + Support for XML:DB? (2)
-> + Select All Behavior (2)
-> + XSLT GUI MAPPER - Drag to off ... (2)
-> + XSLT GUI Mapper Drag Right-to-... (3)
-> + Editor Text Mode needs Code Br... (2)
-> + ODBC Interface (6)
-> + Just started with the trial ve... (2)
-> + XSD Package like XSLT Mapper (3)
-> + Code "bracket" in gutter. (2)
-> + small enhancements (2)
-> - Sort XML Schema (1)
-> + Make backup copy on save (2)
-> + Add comments in XML instance a... (2)
-> - Re: XSLT Version 2 (1)
-> + Expand/Collapse Trees (2)
-> + Stylesheet PI (2)
-> + don't open SS help window on t... (2)
-> - disable SenseX in attribute va... (1)
-> + Stylus Studio License Clarific... (2)
-> + Berkeley DB XML 2.0 (2)
-> - Diagram View: minOccurs, maxOc... (1)
-> + Way to make file being edited ... (2)
-> + Validation inconsistencies in ... (2)
-> - Mapping - Able to grab multipl... (1)
-> + is this a feature or a bug? (2)
-> - SQL Server SQLXML XML Bulk Loa... (1)
-> + request for support for Relax ... (4)
-> - to all staff Please help me ho... (1)
-> + V6 - Find popup (2)
-> + command line diff (4)
-> - Version 6 - Properties window ... (1)
-> + Find Next (3)
-> + Latest releases - downloading (3)
-> + VI (vim) keybindings (4)
-> - Re: Updating custom validation... (1)
-> + Updating custom validation eng... (2)
-> + Stylus Version 6 - DISGUSTED U... (2)
-> + Show substitution group tree i... (2)
-> + XQuery And Stylus Studio (2)
-> + Integration with o:XML (2)
-> + 2 Minor Text Editor Requests (2)
-> + Critical mass - functionality ... (3)
-> + WebDAV button (5)
-> + Mapping content based instead ... (2)
-> + Why I use the Studio only for ... (11)
-> - Tab Reorder in Editor Window (1)
-> + XSL WYSIWYG - Table Copy/Paste... (2)
-> + Copy element (4)
-> + XSLT - properties window - col... (3)
-> + Support collapsing and expandi... (2)
-> - XSD - unsorted values xs:int, ... (1)
-> + Ctrl F - Find - make it dockab... (3)
-> + File Open - last used file pat... (6)
-> - New forum for feature requests (1)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2016)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Byron BignellSubject: ETL and data mapping
Author: Byron Bignell
Date: 27 Feb 2006 11:54 AM
Hi,

I've been using Stylus Studio since last year when I upgraded from Tibco's Turbo XML. I've also been using the XML suite from Altova as it was provided to me by a client.

I use Stylus for 90% of my work but I find myself going back to Mapforce in order to do data mapping to and from XML to the various databases I work with. I'd really rather work in Stylus, but right now it doesn't give me the code generation capabilities that Mapforce does, nor the UI support for building transformations and mappings in the same mostly nice way that Mapforce does.

If there was one feature set that I'd love to see in Stylus it's this. A Data~XML/XML~Data mapping tool with code generation that's as good or better than Mapforce. Something with the ability to taylor the initial query that gets generated (no more wild cards as Mapforce does...and for which I find myself editing waaay too much c# code...)

There is is for what it's worth, let me know what you think.

Byron
Postnext
Minollo I.Subject: ETL and data mapping
Author: Minollo I.
Date: 27 Feb 2006 12:08 PM
Byron,
I'm sure you are aware of the Stylus Studio XQuery and XSLT Mapper editors; so, let me ask you a few questions.

- Are you saying that you find Stylus Studio Mappers less helpful than the competitive products in general or only in specific usecases? (Like, for example, storing data *into* a database)

- When you talk about code-generation, you may mean several things from a Stylus Studio point of view: Stylus Studio Mappers generate XSLT/XQuery code for you; and Stylus Studio also generates Java code to be able to execute such XSLT/XQuery scripts from a Java application or from the command line. What do you exactly mean with "code-generation" in this context, and how would you like to see Stylus Studio helping you more/differently than it does today?

Thanks for your feedback,
Minollo
Postnext
Byron BignellSubject: ETL and data mapping
Author: Byron Bignell
Date: 27 Feb 2006 12:15 PM
Hi.

I find Mapforce easier to use for mapping data to and from xml and databases. The tools are comprehensive and I can design the logic and functions of any data trasnformations with relative ease.

In terms of code generation. Once the data mapping design is complete I use Mapforce to generate the c# code that 'is' the mapping project. It rund faster as an application than it does in the development environment and it means that I can compile and distribute/deliver the executable where needed.

Byron
Postnext
Minollo I.Subject: ETL and data mapping
Author: Minollo I.
Date: 27 Feb 2006 12:49 PM
>I find Mapforce easier to use for mapping data to and from xml and
>databases.

Can you tell us why you find it easier to use? I'm not trying to convince you that it's not true; I'm just trying to understand what we should do if we wanted to change our current design/implementation to make Mappers easier for you.

>In terms of code generation. Once the data mapping design is complete
>I use Mapforce to generate the c# code that 'is' the mapping project.
>It rund faster as an application than it does in the development
>environment and it means that I can compile and distribute/deliver
>the executable where needed.

Stylus Studio follows a similar approach, but it always relies on the XSLT/XQuery artifacts that you created during development; deployed code does run faster than when in the development environment, but it still runs the same XSLT and XQuery that you created at development time. Being strong supporters of XML technologies and standards, we believe that relying on XSLT and XQuery processors is the best way to provide flexibility and consistency with the language you manipulate at development time.

Minollo
Postnext
Byron BignellSubject: ETL and data mapping
Author: Byron Bignell
Date: 27 Feb 2006 01:00 PM
Hi.

I find the organization of the tools in mapforce to be very good. I can move very quickly through a project. The mapforce tools are comprehensive and allow me to build custom functions that can in turn be reused project to project.

The idea of mounting the database tables and xml schema in the mapping UI and then being able to drag from one to another and then test the results while making additions and adjustments in terms of math, logical and other operators makes for a very usable tool.

Where it comes to code, I understand the xml standards perspective and all and it works, but most often I'm asked to provide c# or java code to the client, who aren't necessarily so familliar with the idea.

B
Postnext
Minollo I.Subject: ETL and data mapping
Author: Minollo I.
Date: 27 Feb 2006 01:08 PM
>The idea of mounting the database tables and xml schema in the
>mapping UI and then being able to drag from one to another and then
>test the results while making additions and adjustments in terms of
>math, logical and other operators makes for a very usable tool.

I can see that as long as database tables are used as target of transformations; I still have a few problems to understand the difference when dealing with XML Schema/XML as a taget.

>Where it comes to code, I understand the xml standards perspective
>and all and it works, but most often I'm asked to provide c# or java
>code to the client, who aren't necessarily so familliar with the idea.

I can understand that; but it's also true that, as long as the "client" is involved, the implementation details in terms of XML native languages or in terms of Java/C# shouldn't make much difference; usually you expose the result of Mapper-like tools as some kind of "XML Data Service", and the client would tend to worry about what interface that exposes, not much what code it contains. Isn't that the case for you?

Minollo
Postnext
Byron BignellSubject: ETL and data mapping
Author: Byron Bignell
Date: 27 Feb 2006 01:26 PM
Hi,

It's often the case where the database (tables) are the target of the work I do. It usually involves taking data from non-related systems as database information and then bringing them together into a single XML document (schema). The resulting XML data is then mapped to a 'new and improved' database schema. So in the end the database (or rather one or more databases) are the source and then destination of the data and the XML/schema is a transport mechanism.

Code-wise ending up as c# or java has been the rule for me, it just seems to work out that way. More often than naught it ends up that the client wants c# and they get 'testy' if they don't get it.

Byron
Postnext
Minollo I.Subject: ETL and data mapping
Author: Minollo I.
Date: 27 Feb 2006 01:39 PM
Thanks for the additional details.

Using database tables as mapping targets will dramatically improve in Stylus Studio when Updates will be a feature of XQuery and of the underlying DataDirect XQuery engine that is specialized in RDBMS connectivity.

If you are not familiar with DataDirect XQuery, I would recommend that you take a look at http://www.stylusstudio.com/xml_videos.html (under the XQuery section) and at http://www.stylusstudio.com/xml_videos.html

Thanks for your help,
Minollo

Postnext
Byron BignellSubject: ETL and data mapping
Author: Byron Bignell
Date: 27 Feb 2006 02:37 PM
Hi,

Excellent presentations. Learned quite a bit watching them. Yes, DB tables as targets for update/insert from XQuery will be a major improvement to Stylus. I look forward to it.

I guess that until that point I'll have to eep on keeping on with what I'm using now.


Byron
Postnext
Minollo I.Subject: ETL and data mapping
Author: Minollo I.
Date: 27 Feb 2006 02:40 PM
BTW, my second link was wrong, of course; it should have been: http://www.datadirect.com/xquery

Minollo

Postnext
David KarrSubject: RE: ETL and data mapping
Author: David Karr
Date: 01 Mar 2006 11:56 AM
> -----Original Message-----
> From: stylus-studio-feature-requests Listmanager
> [mailto:stylus-studio-feature-requests.listmanager@stylusstudio.com]
> From: "Byron Bignell"
>
> I find Mapforce easier to use for mapping data to and from
> xml and databases. The tools are comprehensive and I can
> design the logic and functions of any data trasnformations
> with relative ease.
>
> In terms of code generation. Once the data mapping design is
> complete I use Mapforce to generate the c# code that 'is' the
> mapping project. It rund faster as an application than it
> does in the development environment and it means that I can
> compile and distribute/deliver the executable where needed.

Are you executing that C# code in multiple threads on a multi-cpu box,
and is it running in a long-running server?

I found problems with thread-safety in the generated Java code from
MapForce (a static DocumentBuilder object). If I were you, I would make
sure your generated C# code doesn't have similar issues. It would be a
completely different implementation, but it's possible the two
implementations had common design principles.
Postnext
Byron BignellSubject: RE: ETL and data mapping
Author: Byron Bignell
Date: 01 Mar 2006 12:14 PM
ya, the genrated c# code requires a fair amount of work after the fact. but since I can't write that much working code that fast I'm okay with editing and making adjustments; in an ideal world I'd rather have it just work 100% the first time...but we don;t live in an ideal world...

B
Postnext
David KarrSubject: RE: ETL and data mapping
Author: David Karr
Date: 01 Mar 2006 04:52 PM
In my testing, comparing a cached Templates object against the generated
code (after making the thread-safety fixes) to implement the same
translation (both XSLT and Java code generated from MapForce), the XSLT
was almost always faster. If you've done similar testing in the C#
world, I'm guessing that means the C# XSLT engine could be more
performant. I hope you didn't just assume the generated C# code would
be faster.

> -----Original Message-----
> From: stylus-studio-feature-requests Listmanager
> [mailto:stylus-studio-feature-requests.listmanager@stylusstudio.com]
> Sent: Wednesday, March 01, 2006 9:18 AM
> Subject: RE: ETL and data mapping
>
>
> From: "Byron Bignell"
>
> ya, the genrated c# code requires a fair amount of work after
> the fact. but since I can't write that much working code that
> fast I'm okay with editing and making adjustments; in an
> ideal world I'd rather have it just work 100% the first
> time...but we don;t live in an ideal world...
>
> B
>
>
> --
> To reply: mailto:stylus-studio-feature-requests.13964@stylusstudio.com
> To start a new topic:
> mailto:stylus-studio-feature-requests@stylusstudio.com
> To login: http://www.stylusstudio.com/SSDN/
> To (un)subscribe:
> mailto:stylus-studio-feature-requests.list-request@stylusstudio.com
>
>

Posttop
Byron BignellSubject: RE: ETL and data mapping
Author: Byron Bignell
Date: 01 Mar 2006 05:29 PM
Oddly enough I wasn't given the choice. I had to use c#, so perhaps this time I got lucky and didn't have to test as much. Best not trust to luck after this and really hunker down and make sure the resulting code is solid.

If I can get the time in the near future I'd like to see about testing the generated java code against the c# for the work I did. No idea if I'll ever get the time... but one can but hope.

B

   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.