Semaphore Media and Development

…at the crossroad of creativity and technology…

  • home
  • about
  • blog
  • contact

These are the posts from January 2010

January 12, 2010
Posted by admin

transforming a flattened file to hierarchical canonical schema

I ran into a challenge having to map a flattened file data, from SAP’s RFC call, to a hierarchically structured canonical schema. Source: <YITAB> <RecType /> <CDATA /> </YITAB> Canonical: <Header> <Detail> <DetailSpecialInstruction /> </Detail> <HeaderSpecialInstruction /> </Header> rules: 1. if RecType = 001 then header record; if RecType = 002 then Detail Record 2. [...]

No Comments

Posted Under Uncategorized

January 4, 2010
Posted by admin

Empty result when calling a SAP RFC function via WCF adapter

When calling a RFC function via a two-way WCF send port in BizTalk, you may notice that there are not result returned.  In this case, take a look at the generated RFC schema and verify if there is <ITAB> node in the schema.  If it exists, then you need to pass in an empty <ITAB> [...]

No Comments

Posted Under Uncategorized

  • Recent Blog Posts
    • deploy Visual Studio database project through TFS 2010 build
    • MQSC adapter not available in Biztalk Administration console
    • generating polling statement schema via WCF-Oracle DB adapter
    • Installing 32-bit and 64-bit Oracle 11g R2 ODAC to work with BizTalk 2010 Oracle adapters
    • Restoring master secret when migrating BizTalk installation to a new server