ÿþ <?xml version="1.0" encoding="iso-8859-1"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/NewsLetter.dwt" codeOutsideHTMLIsLocked="true" --> <head> <meta name="keywords" content="ETL,Web Services,xFusion,data migration,Service Oriented Architecture,SAP,integration" /> <meta name="description" content="Software Labs -Integrate Your Data with Amazon Web Services" /> <title>Software Labs-xFusion Jan07 Newsletter</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <style type="text/css" > p.style51{font-family: Arial, sans-serif; font-size:11.8px;color: #34383A } p.style53{font-family: Arial, sans-serif; font-size:11px;color: #0794D8; font-weight:600 } p.style52{font-family: Arial, sans-serif; font-weight: bold; font-size:12px; color: #353539 } </style> </head> <body style="margin-left:0; margin-top:0"> <table width="600" border="1" style="text-align:left; border-color:#CCCCCC" cellpadding="0" cellspacing="0" > <tr> <td style="width:600; height:543" align="left" valign="top"> <table width="600" border="0" style="text-align:left" cellpadding="0" cellspacing="0"> <tr> <td style="height:60" colspan="3" align="left" valign="top"><a href="../../default.aspx"><img src="../NewsLetterHdr.jpg" width="600" height="60" style="border:0" alt=""/></a></td> </tr> <tr> <td style="height:19" colspan="3" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr style="background-color:#CCCCCC"> <td style="width:77%; height:25"><p><strong>News and Information for the Data Integration community</strong></p></td> <td style="width:23%"> <div style="text-align:right"><p><!-- InstanceBeginEditable name="Month" --><strong>January 2007</strong><!-- InstanceEndEditable --></p></div></td> </tr> <tr style="background-color:#CCCCCC"> <td style="height:1; background-color:#999999" colspan="2" ></td> </tr> </table></td> </tr> <tr> <td style="width:439; height:20" align="left" valign="top"><img src="../line438x20.jpg" width="438" height="20" alt="" /></td> <td style="width:3; background-color:#CCCCCC" align="left" valign="top" >&nbsp;</td> <td style="width:158; background-color:#CCCCCC" rowspan="4" align="left" valign="top" > <table width="158" border="0" cellpadding="0" cellspacing="0" style="background-color:#CCCCCC"> <tr> <td style="width:158"> <!-- InstanceBeginEditable name="SideLinks" --> <table width="158" border="0" cellpadding="3" cellspacing="0" style="background-color:#CCCCCC"> <tr> <td style="width:158"> <p><a href="../../Solutions/SAPEnterpriseSuite/SAPAutomation.aspx">SAP related solutions</a><br /> <br /> <a href="../../Solutions/Sage/Automation.aspx">Sage Software related solutions</a><br /> <strong><br /> </strong><a href="../../Services/datamodernization.aspx">Data migration solutions</a></p> <p><font color="#000099">Software Labs showcased in a Microsoft <a href="../../Media/Microsoft Case Study.pdf" target="_blank">casestudy</a></font></p> <p><font color="#000099">Weekly Webinar on xFusion. Register via email to:<br /> <a href="mailto:info@softlabsco.com">info@softlabsco.com</a> </font></p></td> </tr> </table> <!-- InstanceEndEditable --></td> </tr> <tr> <td><p><a href="../nsunsubscribe.aspx">Newsletter Unsubscribe</a></p></td> </tr> <tr> <td style="background-color:#6699CC"><p><font color="#FFFFFF"><b>More Newsletters</b></font></p></td> </tr> <tr> <td><p><a href="../Summer08/NewsLetterSummer08.html">Most Recent</a></p></td> </tr> <tr> <td><!-- InstanceBeginEditable name="PrevNS" --> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><p><a href="../dec06/newsletterdec06.htm">Dec 2006</a></p></td> </tr> <tr> <td><p><a href="../nov06/newsletternov06.htm">Nov 2006</a></p></td> </tr> <tr> <td>&nbsp;</td> </tr> </table> <!-- InstanceEndEditable --></td> </tr> </table></td> </tr> <tr> <td style="height:32" align="left" valign="top"> <!-- InstanceBeginEditable name="InThisIssue" --> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr align="left" valign="top"> <td style="height:25" colspan="2"><p><strong><font color="#336600">Happy New Year ! Wish you a very bright and profitable 2007</font><font color="#006600"> !<br /> <br /> </font><a href="#FA"><b><font size="+1">Integrate Your Data with Amazon Web Services</font></b></a></strong><br /> <br /> Many ETL platforms now offer the flexibility of integrating with Web Services so that business visibility and decision-making can be improved. <strong>Dr. Pradeep Tapadiya</strong> gives you an overview of how to use Amazon Web Services in your applications.</p></td> </tr> <tr align="left" valign="top"> <td style="width:68%; height:192"> <p><strong><a href="#AN">Announcements</a><br /> </strong>Latest happenings in data migration and integration industry and xFusion.<br /> <strong><a href="#DK"><br /> Did you know?</a></strong><br /> <a href="#SU"><strong><br /> From the support desk</strong></a> </p></td> <td style="width:32%" align="left" valign="top"> <div style="text-align:center"><img src="Cash.jpg" alt="" width="230" height="187" /></div></td> </tr> </table> <!-- InstanceEndEditable --></td> <td align="left" valign="top" style="background-color:#CCCCCC">&nbsp;</td> </tr> <tr> <td style="height:20" align="left" valign="top"><a name="FA"></a><img src="../FA438x20.jpg" width="438" height="20" alt="" /></td> <td align="left" valign="top" style="background-color:#CCCCCC">&nbsp;</td> </tr> <tr> <td align="left" valign="top"> <!-- InstanceBeginEditable name="FA" --> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td style="height:65"> <p><b><font size="+1">Integrate Your Data with Amazon Web Services<br /> <br /> </font>Author: Dr. Pradeep Tapadiya </b></p> </td> </tr> </table> <!-- InstanceEndEditable --></td> <td align="left" valign="top" style="background-color:#CCCCCC">&nbsp;</td> </tr> <tr> <td style="height:38" colspan="3" align="left" valign="top"><!-- InstanceBeginEditable name="FA2" --> <table width="594" border="0" cellspacing="0" cellpadding="3"> <tr> <td align="left" valign="top"><p> Most organizations are moving towards a Service Oriented Architecture (SOA) for standards-based application interoperability. Although there were many attempts at SOA in the past (DCOM, CORBA, etc.), the current definition uses Web Services as the means of interaction. <br /> <br /> Major web-based businesses such as Amazon, eBay, Google, etc. are providing Web Services that can be consumed within your applications. Many ETL platforms now offer the flexibility of integrating with Web Services so that business visibility and decision-making can be improved. Here, I show you the steps involved in accessing data from Amazon's E-Commerce Web Services (AWS). Using AWS, for example, you can compare prices of your inventory items against that of Amazon. Enjoy! </p> <p><strong>Step 1: Get your subscription ID from Amazon</strong><br /> Register at http://www.amazon.com/aws (free) and receive your subscription ID. This ID is needed when Web Service calls are made to Amazon.<br /> <br /> <strong>Step 2: Get the technical documentation</strong><br /> <br /> AWS provide powerful search functionality. The technical documentation is handy in order to understand the supported fields to search on. <br /> <br /> <strong>Step 3: Generate proxy code for the Web Service</strong><br /> <br /> The name of the Web service, the parameters it accepts, and the return values are defined using a language called WSDL. The WSDL definition for AWS can be found at http://webservices.amazon.com/AWSECommerceService/AWSECommerceService.wsdl. Using your programming framework, generate the client side proxy code for AWS. <br /> <br /> <strong>Step 4: Define your search criteria</strong><br /> <br /> In your application, define the search criteria. Here are various fields you need to define: </p> <ul> <li><p><em>SearchIndex</em>: The category to search for. For example, Books, Music, Electronics, etc. Note that names are case-sensitive. </p></li> <li><p><em>Power</em>: The field to search upon. The field is based on the specified search index.</p></li> <li><p><em>ResponseGroup</em>: The result of your search may contain hundreds of fields. You must specify</p></li> <li><p>the field-groups that you are interested in. You can also specify generic groups Small, Medium, or Large.</p> </li> <li><p><em>Sort</em>: The field upon which the response must be sorted. For example, for Books, you can sort by salesrank, pricerank, etc.</p> </li> </ul> <p>Here is an example in C#:</p> <table width="80%" border="0" cellspacing="5" style="background-color:#CCCCCC"> <tr> <td><p>ItemSearchRequest irs = new ItemSearchRequest();<br /> irs.SearchIndex = &quot;Books&quot;;<br /> irs.Power = &quot;Title: Data Integration&quot;;<br /> irs.ResponseGroup = new string[] {&quot;Small&quot;};<br /> irs.Sort = &quot;salesrank&quot;;<br /> ItemSearchRequest[] allRequests = new ItemSearchRequest[] { irs };</p></td> </tr> </table> <p><strong>Step 5: Associate your subscription ID<br /> </strong><br /> You now need to associate your subscription ID with your search condition. Here is a code snippet:</p> <table width="80%" border="0" cellspacing="5" style="background-color:#CCCCCC"> <tr> <td>ItemSearch itemSearch = new ItemSearch();<br /> itemSearch.SubscriptionId = &quot;XXXXXXXXXX&quot;;<br /> itemSearch.Request = allRequests;</td> </tr> </table> <p><strong>Step 6: Call the Web Service</strong><br /> <br /> Invoke AWS, passing in the necessary parameters, and get the response back. Here is a code snippet:</p> <table width="80%" border="0" cellspacing="5" style="background-color:#CCCCCC"> <tr> <td>AWSECommerceService aws = new AWSECommerceService();<br /> ItemSearchResponse response = aws.ItemSearch(itemSearch);<br /> Items info = response.Items[0];</td> </tr> </table> <p>You can now iterate through Items collection and get your data. Field ItemAttributes contains sub-fields containing your data. <br /> <br /> Hopefully your ETL provider has already implemented the logic so that you don't need to write the code. However, I hope this gives you an insight on what happens underneath.</p></td> </tr> </table> <!-- InstanceEndEditable --></td> </tr> <tr> <td style="height:1" colspan="3" align="left" valign="top"><a name="AN"></a></td> </tr> <tr> <td style="height:20" colspan="3" align="left" valign="top"><img src="../AN600x20.jpg" width="600" height="20" alt="" /></td> </tr> <tr> <td style="height:38" colspan="3" align="left" valign="top"><!-- InstanceBeginEditable name="AN" --> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td> <p><strong>New Partners</strong><br /> We are happy to announce the addition of Premier Results Inc. www.premierresults.com and Third Wave Business Systems www.twbs.com to our growing list of partners. xFusion will help them to streamline customer migrations, and integrating customer data across business applications.<br /> <strong><br /> New xFusion Developers Network Website</strong><br /> xFusion customers now have an expanding support network to gain technical guidance. Many new resources are being added to this site every week. Also, a new developers forum will complement this service soon. See xFusion Developer Network online here: http://main.xfusiondn.com/<br /> <br /> <strong>New Events</strong><br /> Software Labs will attend SAP Americas Field Kick-Off Meeting &#8217;07 in Las Vegas, January 14-17. If you are a SAP partner we will see you there!</p></td> </tr> </table> <!-- InstanceEndEditable --></td> </tr> <tr> <td style="height:1" colspan="3" align="left" valign="top"><a name="DK"></a></td> </tr> <tr> <td style="height:20" colspan="3" align="left" valign="top"><img src="../DYK600x20.jpg" width="600" height="20" alt="" /></td> </tr> <tr> <td style="height:32" colspan="3" align="left" valign="top"><!-- InstanceBeginEditable name="DYK" --> <table width="100%" border="0" cellpadding="3" cellspacing="0"> <tr> <td style="height:63"><p><b>Did you know that xFusion supports all date-time formats?</b> <br /> Using xFusion Studio we can define various ways to parse date-time formats. Any date-time string format can be converted to date. <a href="http://main.xfusiondn.com/Contributions/DataProcessing/A01020701.aspx">Read more& </a> </p></td> </tr> </table> <!-- InstanceEndEditable --></td> </tr> <tr> <td style="height:1" colspan="3" align="left" valign="top"><a name="SU"></a></td> </tr> <tr> <td style="height:20" colspan="3" align="left" valign="top"><img src="../SUP600x20.jpg" width="600" height="20" alt="" /></td> </tr> <tr> <td style="height:32" colspan="3" align="left" valign="top"> <!-- InstanceBeginEditable name="SUP" --> <table width="100%" border="0" style="text-align:left" cellpadding="2" cellspacing="2"> <tr> <td style="height:536"><p><strong>Support Question:</strong><br /> Hi Support,<br /> <br /> I have column &quot;Item&quot; that is a 12 digit numeric field.<br /> I want to do a statement that says if position 6, 7 &amp; 8 of this 12 digit number <br /> is ABC, then fill another column with a value.<br /> (For example, XXXXXABCXXXX)<br /> If position 6, 7 &amp; 8 of the item # is 800 then fill column named itemClass = fabric.<br /> If these 3 positions hold 900, fill column named itemClass = bags.<br /> If these 3 positions hold 907, fill column named itemClass = blinds.<br /> Can you tell me how I would do this in Fusion?<br /> <br /> <strong>Reply: </strong></p> <p>Hi,<br /> Please use our transform function Switch to achieve this.<br /> The query looks like this. </p> <blockquote> <p>AddColumn (<br /> [[Data]],<br /> Switch<br /> (<br /> Mid([Data.Item], 6, 3) = &quot;800&quot;, &quot;fabric&quot;, <br /> Mid([Data.Item], 6, 3) = &quot;900&quot;, &quot;bags&quot;,<br /> Mid([Data.Item], 6, 3) = &quot;907&quot;, &quot;blinds&quot;<br /> )<br /> as ItemClass<br /> )</p> </blockquote> <p>Hope this helps.</p> <p>Support</p></td> </tr> </table> <br /> <!-- InstanceEndEditable --></td> </tr> <tr> <td style="height:45; background-color:#CCCCCC" colspan="3" align="left" valign="top" > <div style="text-align:center"><p>Software Labs, Inc. 1225 Pleasant Grove Blvd. #100, Roseville CA 95768, USA<br /> <b>ph</b>: 1-916-773-6272 <b>fax</b>: 916-773-6281 <b>web</b>: <a href="http://www.softlabsco.com">http://www.softlabsco.com</a> <b>email</b>: <a href="mailto:info@softlabsco.com">info@softlabsco.com</a><br /> <b>unsubscribe via email</b>: <a href="mailto:unsubscribe@softlabsco.com">unsubscribe@softlabsco.com</a> <b>unsubscribe via web</b>: <a href="http://www.softlabsco.com/newsletter/nsunsubscribe.aspx">click here</a></p></div></td> </tr> </table></td> </tr> </table> </body> <!-- InstanceEnd --></html>