About
About me
My name is Sandro Pereira and I live in Porto – Portugal. I’m the Head of Enterprise Integration 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, Service Bus, Logic Apps and so on), 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”, co-author of the book “Migrating to BizTalk Server 2020” and technical reviewer of several BizTalk books all focused on Integration. I’m also a regular guest blogger at the BizTalk360 blog and Serverless360 blog.
I have been awarded MVP since 2011 for my contributions to the integration community.
My email address is sandro-pereira@live.com.pt, feel free to contact me or leave a comment on a post on this blog.
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 | 2021-2022 |
Microsoft® Most Valuable Professional (MVP) | Microsoft Azure | 2020-2021 |
Microsoft® Most Valuable Professional (MVP) | Microsoft Azure | 2019-2020 |
Microsoft® Most Valuable Professional (MVP) | Microsoft Azure | 2018-2019 |
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 |
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)
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.
BizTalk Crew
Member and co-founder of the BizTalk Crew, which is responsible for organizing BizTalk Innovation Events across all of Europe, along with Nino Crudele (Microsoft Integration MVP from Italy), Saravana Kumar (Microsoft Integration MVP from the UK), Steef-Jan Wiggers (Microsoft Integration MVP from Nederland) and Tord Glad Nordahl (Microsoft Integration MVP from Norway).
Microsoft Community Contributor
The Microsoft Community Contributor badge is given to those who make notable contributions to Microsoft online communities such as TechNet, MSDN and Microsoft Community. The value of these resources is greatly enhanced by participants who voluntarily contribute their time and energy to improve the online community experience for others.
DevScope
Rua Passos Manuel, 223 – 4º Floor
Oporto
4000-385 Oporto Portugal
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.
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
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
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
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.
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..
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
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.
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
Hi Sandro,
In EDI 278 generation,i have initialized the few promoted properties as correlation set in the send port .now i want to write these properties to a file in orchestration
.Could you please give some idea ?
Thanks
Naveen