About

About me

My name is Sandro Pereira and I live in Oporto – Portugal. I work as an Integration Consultant at DevScope. Since 2002, I have been working on implementing Enterprise Integration scenarios both on-premises and cloud for several clients worldwide, each with different requirements and needs from a technical point of view, size, and criticality, using Microsoft Azure (API Management, API Apps and Logic Apps), Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc.

I’m a regular blogger, international speaker, author of the book “BizTalk Mapping Patterns & Best Practices” and technical reviewer of several BizTalk books all focused on Integration. I’m an active member and moderator of the MSDN BizTalk Server Forums, Code Gallery and TechNet Gallery contributor, a member of BizTalkBrazil community and a member of NetPonto community. Guest blogger at BizTalk360 blog and Norwegian BizTalk User Group blog.

I have been awarded MVP since 2011 for my contributions to the integration community.

My email address: sandro-pereira@live.com.pt, feel free to contact me or leave a comment to a post on this blog.

Sandro Pereira MVP

About This Blog

This blog is a place for me to write and share useful notes about Enterprise Integration (BizTalk Server, BizTalk Services, Azure App Services, API Management, Logic Apps, Service Bus and so on), .Net, tools, links, articles, sample code and experiences that are related to my work, hoping to be interesting for some.

Most Valuable Professional (MVP)

Award Name Area of Expertise Date
Microsoft® Most Valuable Professional (MVP) Microsoft Azure and Visio 1/1/2017 – 1/1/2018
Microsoft® Most Valuable Professional (MVP) Microsoft Azure 1/1/2016 – 1/1/2017
Microsoft® Most Valuable Professional (MVP) Microsoft Integration 1/1/2015 – 1/1/2016
Microsoft® Most Valuable Professional (MVP) Microsoft Integration 1/1/2014 – 1/1/2015
Microsoft® Most Valuable Professional (MVP) Microsoft Integration 1/1/2013 – 1/1/2014
Microsoft® Most Valuable Professional (MVP) BizTalk 1/1/2012 – 1/1/2013
Microsoft® Most Valuable Professional (MVP) BizTalk 1/1/2011 – 1/1/2012
MVP

Microsoft Certifications & MSDN Profile

Microsoft® Certified Technology Specialist (MCTS)

Certification/Version Date
Microsoft Biztalk Server 2010 09/20/2011
Biztalk® Server 2006, Custom Applications 07/26/2007

Other Certifications:

  • Microsoft Partner Network BizTalk Technical Competency Assessment for Application Integration (2015)
  • Microsoft Partner Network Sales and Marketing Competency Assessment for Application Integration (2014)
  • Microsoft Partner Network BizTalk Technical Competency Assessment for Application Integration (2013)
  • Microsoft Partner Network Sales and Marketing Competency Assessment for Application Integration (2012)
  • Microsoft Partner Network Sales and Marketing Competency Assessment for Application Integration (2010)
Sandro Pereira MCTS Logo

Sandro Pereira MCTS Logo

Sandro MSDN forums Sandro MSDN Profile Sandro Code Gallery Sandro Microsoft tech net

BizTalk Mapping Patterns and Best Practices
Most Popular Downloaded Book

BizTalk Mapping Patterns and Best Practices

The BizTalk Mapping Patterns and Best Practices book is a reference guide mainly intended for BizTalk
developers to make their day-to-day lives easier. A 400-page recipe for BizTalk Developers to develop effective, robust, and organized maps. The book offers insights on how maps work, the most common patterns in real time scenarios, and the best practices to carry out transformations. Click here to download your free copy of the eBook.

get the book

BizTalk Crew

Member and co-founder of the BizTalk Crew, that are responsible for organize BizTalk Innovation Events across all Europe, along with Nino Crudele (Microsoft Integration MVP from Italy), Saravana Kumar (Microsoft Integration MVP from UK), Steef-Jan Wiggers (Microsoft Integration MVP from Nederland) and Tord Glad Nordahl (Microsoft Integration MVP from Norway).

Biztalk crew sandro

DevScope

Rua Passos Manuel, 223 – 4º Floor
Oporto
4000-385 Oporto Portugal

Dev scope

  • Gisis

    I have encountered the following situation.Would appreciate your insights.

    Case description:

    1.We are using BTS 2010 (w/Adapter pack 2010) to post IDoc messages into SAP (ECC 6, EHP 5).
    2.My scenario is a plain FTP to SAP.
    3.I used the WCF-SAP Adapter with a strongly typed Schema and a Send operation.
    4.We have created a Target Schema representing a multi IDoc structure in order to handle a 1: n scenario (using the maxOccurs setting originally set to 2147483647 available in Adapter pack 2010)
    5.When a single message with multi-line arrives we need to generate a single IDoc message of each line. (Control record +1 line of payload)
    Currently the result IDoc is not what we expect:

    We get “N” Idocs (according to the amount of kines in the source files) and the payload is replicated to each IDoc.(not spilted to single record per IDoc.

    Attached is the XML as picked up from the Msg. Box by the Adapter just before posting theIDoc to SAP.

  • Shah M.

    Hello Sandro,

    I have an orchestration which under high load is waiting a few minutes between its initialization and its receive shape. The receive shape activates the orchestration by receiving a message from the message box. Do you have any idea as to why BizTalk is delaying the reception of the message ?

    According to you which BizTalk settings need to be monitored / configured to resolve my problem ?

    Thanks you in advance for your reply.

    Kind regards,
    Shah

  • Hi
    it’s available the BizTalk 2013 Developer Immersion Training Kit? Do you know it’s possible download? Thanks in advance

  • Henrik Jensen

    I have a question in relation to encryption protocol support in the latest BT2013R2. I have not been succesfull in getting an official confirmation that SHA256 is supported in BTS2013 pipelines?
    Can you maybe assist?

    Regards.
    H.Jensen.Dane

    • Hi Henrik, never try it but it seems that BizTalk supports SHA256
      I think this type of configuration are not made in pipelines, instead you need to use the Security tab in the Transport Properties of the WCF Adapter and use
      Basic128Sha256: Use Aes256 for message encryption, Sha256 for message digest, and Rsa-oaep-mgf1p for key wrap
      Basic128Sha256Rsa15: Use Aes128 for message encryption, Sha256 for message digest, and Rsa15 for key wrap.
      Or other, there are several SHA256 algorithms
      Check the following url: https://msdn.microsoft.com/en-us/library/jj572855.aspx

  • Pingback: BizTalk built-in monitoring tool – BizTalk Health Monitor (BHM) | Gautam's Integration Blog()

  • Praveen Kumar

    Hi Sandro,

    I have encountered the following situation.Would appreciate your insights.

    Case details:

    File transport does not have read/write privileges for receive location in BizTalk 2010:

    It is happening for Receive & Send Folder locations. I’m unable to enable the send & receive locations.

    1. I’ve gave full access control to the shared folder location
    2. I can open the shared folder location in Internet folder
    3. I’ve tried to give local D drive folder access also. It is having the same issue as below:

    Description:

    The Messaging Engine failed to add a receive location “ReceiveCsvFromSourceSystem_File” with URL “\sportshub.com.sgbiztalkBISFileSharePOLLSalesTransactionFrom_POS*.csv” to the adapter “FILE”. Reason: “File transport does not have read/write privileges for receive location “\sportshub.com.sgbiztalkBISFileSharePOLLSalesTransactionFrom_POS”. “.

    Please help me to fix this ASAP.

    Thanks,
    Praveen Kumar A.R

  • Iurii

    Hi Sandro,

    I need to migrate existing Biztalk 2006R2 environment running on windows 2003×32 to BT2013(guess through BT2010). I saw a guide from MS, however it is not applicable in my case, as I have old hardware and in place upgrade is not applicable.
    In Google I haven’t found any clear guidance on how to migrate all information from existing setup. Maybe you have link to this information?

    • Hi Iurri,
      I never made an upgrade to a BizTalk environment because I found that not useful, instead I prefere to create a new environment and migrate de solutions to this new environment, there are far fewer risks by doing that.

      The problem in upgrade de env is that you also need to upgrade the SQL and the SO:
      BTS 2006R2 supports: Windows Server 2003 with Service Pack 1 (SP1) or Service Pack 2 (SP2), or Windows Server 2003 R2 — SQL Server™ 2005 with Service Pack 2 or SQL Server 2000 with Service Pack 4

      BTS2010 only supports: Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2008 SP2 — SQL Server 2008 R2 SP1/SQL Server 2008 R2/2008 SP1

      So if you want to do that probably you need to upgrade to BTS2009, update SO and SQL, than update to 2010 and upgrade SO and SQL, something like that and is for this reason that I never do this type of task and prefer to advice to create a new env.

      • Iurii

        Thanks for fast reply! Actually I was talking about move settings from old to new environment. However I don’t know on how to move all settings and data from exisitng databases, especially when it is about BT failover cluster. BAM portal settings and so on…Move SSO server..

  • Aj Singh

    Hi Sandro,

    Request you to please share a page/blog, which guides us all for a conversion of a flat file to X12(EDI 837I/P/D) format. I am new to Biztalk, have done research on it, but couldn’t successfully achieve the expected results so far.

    Really looking forward to for your reply, thanks in advance

    Regards,
    Aj

  • Shah MOHAMOD

    Hi Sandro,

    According to you which of the following solutions will perform better:
    1. Mapping in c# code
    2. BizTalk Mapper

    Assumption: the data to be mapped is of fair size

    Thanks for your reply

  • Hi Sandro

    I have a question, is about de message queues, i have a problem when i restart de host instance some messages are resending, but i not need this, how are stop this resend, the message are in queue becouse the WebService have a timeout.

    You have a consultant modalitiy? i’m from Costa Rica

    I apreciate your time to answer me.

  • Rafael Reyes

    Hi Sandro

    I am trying to access Active Directory Web Services from Biztalk. Though I have managed to make some operations to work (Get, Put, Enumerate), the Pull operation is giving me a hard time: it always faults with a “Unknown or expired enumeration context.” error. I have opened a discussion thread on the Biztalk forum (https://social.msdn.microsoft.com/Forums/en-US/0364bca6-8f01-4a08-863f-bf96b6e3a47c/mswsds-pull-message-invalid-enumeration-context-specified-in-the-request?forum=biztalkgeneral ) with no luck. Perhaps you have experience in this kind of integration and could give me some new ideas.

    Thank you

    Rafael