Working with CSV files made simple with Websphere MBT and DFDL

Working with CSV files and mapping them from/to any of the WebSphere Message Broker domains is a lot easier with the support for DFDL files in version 8.0

Using DFDL files you can easily create message flows to parse and serialize CSV messages to and from any of the WebSphere Message Broker domains.

http://publib.boulder.ibm.com/infocenter/wmbhelp/v8r0m0/index.jsp?topic=%2Fcom.ibm.dfdl.editor.messagebroker.doc%2Fdf20071_.html

For example I'd a project where I needed to capture order information from several third party marketplaces.

Each marketplace offered different methods for accessing the most recent order information for our account. For example

Web Services Interface
FTP 
Email

In addition each marketplace used a different format sometimes XML based and sometimes CSV based to describe orders placed.

Using the DFDL its a lot easier to create a mapping  between these various marketplace formats and in turn creates a standard output XML format that is suitable for our in house ERP system.


Comments

Post a Comment

Popular posts from this blog

Basic Send Message to MQ with Java and IBM MQ JMS

Basic Receive Message to MQ with Java and IBM MQ JMS

Creating a simple Alert / Success Message with ASP.NET/VB using Bootstrap