November 2009 Entries

Using BAM APIs for Tracking

Sometimes, in BizTalk development, a developer needs to develop an out of the box solution for message tracking, etc. Even though the BizTalk Server itself provides an excellent tool such as BAM for Business Analyst (precise to say) and HAT for developer. We encountered the same kind of problem where client wanted us to develop such kind of custom solution to display the message body and message flow. I will be discussing about the details as how to use BAM APIs and message tracking databases used...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

BizTalk EDI Development : EDI Schema not deployed.

You must need to deploy the standard EDI schema against which you need to receive your EDI document. Most of the time in the initial stage of the EDI developments, developer assume that just by adding the edireceive pipeline and configuring the party is suffiecient but this is not the case. I will be detailing about this scenario. If the schema is not deployed you will receive below error messages. ---------------------------... An output...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Writing Custom Pipeline component to modify the source file name.

In BizTalk EDI application I needed to have custom file name of the destination file and I end up writing a custom component. I could have used orchestration to modify the "ReceivedFileName" but somehow it was not working. May be becasue of EDI Encode component but that should not be the case. Any way.. the other thing was I also needed to add the seuence of the file to the FileName. I found that BizTalk databases does not store the sequence of the received file so either I needed to add some tracking...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Developing First BizTalk EDI Project

If you need to start on BizTalk EDI Development, you can refer below articles. If you face any issue please do write to me. BizTalk EDI Development Part 1: http://geekswithblogs.net/V... BizTalk EDI Development Part 2: http://geekswithblogs.net/V... BizTalk EDI Development Part 3: http://geekswithblogs.net/V...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

How to concatenate and return row values in single result field.

Recently I encountered a problem wherein I need to concatenate and return the row values in single field. I was getting the results as below in rows and I needed to return the concatenated values of these row values. Results Load Number Temperature Code Purchase Order Number 141421 F PO1 141421 D PO2 141421 S PO3 In fact I was not having any column like LoadNumber which could have worked as ID and the implementation should have been a bit easy. I am mentioning two different solutions below. On works...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

«November»
SunMonTueWedThuFriSat
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345