Empowering Hybrid Integration recording is now online on Channel 9

Empowering Hybrid Integration recording is now online on Channel 9

Well, Empowering Hybrid Integration segment is online since January 30, 2017, but only now I realize that… During the MVP Global Summit, and taking the opportunity of having most of the Integration MVPs gathered at the event, Microsoft Pro Integration team tends to invite the MVPs to create short videos – 8 to 10 minutes videos – about Integration (on-premise or in the cloud). It happened in previous editions of the Summit and it happened in the last edition in which they invite us to talk about Hybrid Integration that includes BizTalk Server, Azure Logic Apps, Azure API Management and Azure Service Bus.

For several reasons, I never had the chance to accept the challenge in the past, but last year I was able to accept the invitation to speak and record at the “famous” Microsoft Building 20, building that is the home of Channel 9 studio …

Preparing myself to record my session about Empowering Hybrid Integration on Channel 9Preparing myself to record my session about Empowering Hybrid Integration on Channel 9

… and make a short talk about Hybrid Integration using Service Bus Queues, BizTalk Server, Dynamic CRM, SQL Server, Logic Apps and File.

Empowering Hybrid Integration: Technical Solution

Has I told in a previous post of my blog, that was my first experience, and I have to confess, I was a little nervous to be recording in a small professional studio, so as expected after seeing the record in its raw state, the end result could have been better, but, fortunately for you guys I was able to edit the video and remove some breaks/delays between switching from my presentation slides to my screen. Nevertheless, for a first experience, it went pretty well and I am happy with the result. The important for me is to face new challenges, different situations, leave my comfort zone and improve to be better next time.

The result is this 8 minutes video on Empowering Hybrid Integration where you can learn how you can create powerful hybrid integration solutions using existing on-premises and cloud based solutions.

Empowering Hybrid Integration recording at Channel 9

Fortunately, I had the company of my good friend Kent Weare in this small “adventure”:

Protecting Azure Logic Apps using Azure API ManagementProtecting Azure Logic Apps using Azure API Management

You can also watch his session about “Protecting Azure Logic Apps using Azure API Management”. In this video, you can learn how to use Azure API Management to protect your Logic Apps.

Protecting Azure Logic Apps using Azure API Management recording at Channel 9

You can watch more sessions regarding Microsoft’s Hybrid Integration Platform on Channel 9 here.

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Feeling Special, feeling proud, feeling honored…

Feeling Special, feeling proud, feeling honored…

Today I’m going to write about a different topic, we can say that is related to technology but not exactly a technical blog post. And no, I’m not feeling special (I’m always feeling special but in different contexts), proud and honored today because it’s my birthday.

January 1st, 2011, will always be a special day for me, it was the day I had the honor of being awarded Microsoft Most Value Professional (MVP) for the first time which was an unexpected good surprise. This is my 7th straight year on the MVP Program and since the first day, it has been a delighted journey and experience. I was the first and for many years the only MVP at my company DevScope but, contrary to what many people might think, is was not for that reason also that I could feel special. I’m feeling special for somehow, directly or indirectly, being able to help to grow the spirit of community collaboration, a little more (because it always existed), internally at the company and sometimes, maybe, by serving as a mentor, a role model or an inspiration to others. But especially by encouraging and helping everyone to start contributing and share their knowledge with the communities, often challenged them to collaborate with me on small projects.

I’m feeling special, proud and honored today to be part of a company who after all these years still keeps their main core identities, with a focus on cutting-edge technology, early adopter in most cases, focus on innovation and helping with the needs of our clients, but without losing the focus on the people, helping them to grow personal and professional. I’m feeling special, proud and honored today because I can say that I work with a team of amazing professionals and special to be able to realize that we already have 3 MVPs at DevScope, one former MVP and one Microsoft Regional Director (there are not many companies worldwide that can boast on these facts).

I’m feeling special, proud and honored today, not also for working with such hard working and talented team, but also, for being able to realize that new talents are being formed.

… but let’s also be fair, I way also feeling special, proud and honored today because it is my birthday and I have an amazing family, an amazing job and the best friends in the world!

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

BizTalk Server Databases: Disaster Recovery, Troubleshooting and Best Practices whitepaper

BizTalk Server Databases: Disaster Recovery, Troubleshooting and Best Practices whitepaper

Finally, BizTalk Server Databases: Disaster Recovery, Troubleshooting and Best Practices whitepaper is published! I think this was my crazy project ever because I started during an MVP Summit, probably in 2013 with a very basic whitepaper of 7 pages about Disaster Recovery and my initial reviewer was Tord Glad Nordahl… for some reason I never finished or published the content and last year again during the MVP Summit I revived this idea and basically annoyed all the MVPs that were next to me that day to review the initial document again… bad idea for me because, probably to get revenge on me, they were the most demanding reviewers that I ever had, always asking for more content making, therefore, the whitepaper more complete. So, what was a 7-pages whitepaper becomes a 34-pages whitepaper.

BizTalk Server Databases: Disaster Recovery, troubleshooting and best practices

What to expect about BizTalk Server Databases: Disaster Recovery, Troubleshooting and Best Practices whitepaper

Microsoft BizTalk Server databases and the health of the databases are very important for a successful BizTalk Server messaging environment. BizTalk Server is an extremely database-intensive platform, persisting data to disk with high frequency, and one of the main reasons for that is because one of the primary design goals of BizTalk Server is to ensure that no messages are lost. Therefore, database performance is paramount to the overall performance of any BizTalk Server solution.

There are many factors that you need to take into consideration towards troubleshooting, maintaining, monitoring or recovering from disasters. This paper will provide you some important aspects to consider when working with BizTalk Server databases and addressing the most common and important aspects:

  • Size of databases and tables: performance degrades on High Size of BizTalk databases
  • Important consideration to avoid large BizTalk Databases
  • Separation of data files and log files (SQL Server disk I/O contention)
  • Important consideration BizTalk SQL Settings
  • Available tools for monitoring and troubleshooting
  • Recovering from disasters situations (Clean up your BizTalk databases)

However, the content is very valuable with regards to even preventing a disaster or limit the probability of it. After reading this paper you should be prepared for any disaster but also to preventing for happening because be able to prevent is better than resolving.

Where I can download it

You can download the whitepaper here:

BizTalk Server Databases: Disaster Recovery, Troubleshooting and Best Practices (1.14 MB)
BizTalk360

I would like to take this opportunity also to say thanks to my amazing reviewers: Steef-Jan Wiggers, Nino Crudele, Kent Weare, Mikael Hakansson and Salvatore Pellitteri for taking the time to review this whitepaper. And other people that were involved in making this “project” came true like Tord Glad Nordahl, Lex Hegt, Saravana Kumar and Sriram Hariharan.

I hope you enjoy reading this paper and any comments or suggestions are welcome.

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

BizTalk MapperExtensions Functoid Wizard for BizTalk Server 2016

BizTalk MapperExtensions Functoid Wizard for BizTalk Server 2016

Being an MVP, and a community leader, one of my roles is to motivate others members to start contributing to the community and at DevScope we have great new technicians that sometimes only need to be pushed and motivated… this time I challenged my coworker Rui Silva to collaborate with me on this small project and the result is here: BizTalk MapperExtensions Functoid Wizard for BizTalk Server 2016.

BizTalk MapperExtensions Functoid Wizard is a Custom Functoid Project Wizard for Visual Studio 2015. It allows you to create a new Functoid project for BizTalk Server 2016 without having to create manually the project, in other words, having to manually create:

  • A new class library project in Visual Studio 2015;
  • Add a reference to the Microsoft.BizTalk.BaseFunctoids assembly;
  • Add New Class and having to code the entire class;

This Wizard will do this process automatically, and used in conjunction with BizTalk Server: Custom BizTalk Functoid item template for Visual Studio 2015 will facilitate and significantly expedite the development process of our projects. The only thing you will need to do is create a new Custom Functoid Project and a wizard will pop-up, fill in the required fields and when you finish the process a new Custom Functoid project is built. Just change the execution method with your own algorithms, build your project and it’s done. You’ll see your new Functoid in BizTalk Server 2015 Mapper once you import it to Visual Studio Toolbox.

BizTalk MapperExtensions Functoid Wizard Installation

To use this project template download the executable files available on “Installation Files” folder and run the setup file.

Once you run the setup file follow these steps:

  • On the “Welcome to the BizTalk MapperExtensions Functoid Template Setup Wizard” screen, click “Next”.

BizTalk MapperExtensions Functoid Wizard: Welcome Screen

  • On the “Select Installation Folder” screen, select the folder where you want to install the Wizard and select the option “Everyone”. Click “Next” to continue.

BizTalk MapperExtensions Functoid Wizard: Installation Folder Screen

  • On the “Confirm Installation” screen, confirm your intent to install by clicking “Next”

BizTalk MapperExtensions Functoid Wizard: Confirm Screen

  • On the “Installation Complete” screen, click close and the installation is complete

BizTalk MapperExtensions Functoid Wizard: Complete Screen

Now you can see a new BizTalk project template option under “BizTalk projects” in your Visual Studio 2015.

BizTalk MapperExtensions Functoid Wizard: Visual Studio Functoid Project

Create New Functoid Project

To create a new functoid using this project template choose the option “BizTalk Server Functoid Project” in Visual Studio 2015 and a Wizard will pop-up. Follow the requirements of this wizard to create the Functoid.

  • In the “Start” screen, click “Next” to continue

BizTalk MapperExtensions Functoid Wizard: Start Screen

  • In the “General Project Properties” screen, fill the Functoid class name, namespace and create or select a new Strong Key (you can use an existing one). Click “Next” to continue.

BizTalk MapperExtensions Functoid Wizard: General Properties Screen

  • In the “Functoid Properties” screen, define the Functoid ID (must be greater than 10000), the functoid name, the tooltip (short description) and description (full description). Click “Next” to continue.

BizTalk MapperExtensions Functoid Wizard: Functoid Properties Screen

  • In the second “Functoid Properties” screen, choose the functoid category and the implementation language (the language in which you want to implement your functoid behavior code): C# or VB.NET. Click “Next” to continue.

BizTalk MapperExtensions Functoid Wizard: Functoid Properties Screen

  • In the “Functoid Parameters and Connection Types” screen, define the functoid function name, function inputs and types and output and types. Click “Next” to continue.

BizTalk MapperExtensions Functoid Wizard: Functoid Parameters Screen

  • On the final screen, click “Finish” to create the Visual Studio project.

BizTalk MapperExtensions Functoid Wizard: Result Screen

Visual Studio will create a new Project based on your implementation language and definitions provided in the Wizard.

BizTalk MapperExtensions Functoid Wizard: Project Sctructure

  • Open the generated class and implement your code

BizTalk MapperExtensions Functoid Wizard: Project Code
Once again, special thanks to Rui Silva who accepted the challenge and collaborated with me in order to finalize this project.

You can download the Source Code or contribute to the project here:

BizTalk.MapperExtensions.Functoid.Wizard
GitHub

You can download the installation files (only executables) here:

BizTalk MapperExtensions Functoid Wizard: BizTalk Server 2016 Installation files (1.1 MB)
Microsoft | TechNet Gallery

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

BizTalk Scheduled Task Adapter is now stable and officially available for BizTalk Server 2016

BizTalk Scheduled Task Adapter is now stable and officially available for BizTalk Server 2016

Almost 20 days since I release the beta version of BizTalk Scheduled Task Adapter and still no issues reported. I also have been testing intensely the adapter so it is fair to say that this version it is stable, so, I officially remove the “beta label” from this version. BizTalk Scheduled Task Adapter is finally officially available (version 6.0) and optimized for BizTalk Server 2016!

The BizTalk Scheduled Task Adapter is an in-process receive adapter that executes a prescribed task on a daily, weekly or monthly schedule. The adapter is configured entirely within BizTalk, all configurations are stored within the SSODB and can be exported and imported via binding files.

The schedule capabilities are similar to those available with the Windows Scheduled Task Service.

BizTalk Scheduled Task Adapter for BizTalk Server 2016

What is new?

New schedule capabilities:

  • You can now schedule for a message to be a trigger in a time period, for example, each hour, minutes or seconds, every day or on certain days (for example all days except weekends).

BizTalk Scheduled Task Adapter new schedule capability

What was improved or fixed?

Several reported issues were from previous BizTalk Scheduled Task Adapter versions were solved, for example:

  • In some scenarios, trigger message sent twice at the same time – Solved
  • Bug: Time change (DST) bug – Solved
  • Bug: BizTalk Scheduled Task Adapter SQL Timeout issue – Solved

You can download this new version of the Scheduled adapter in the adapter CodePlex project page:

Please fill free to try and use the adapter and If you find any problems or bugs please open issue on the adapter Codeplex site: https://biztalkscheduledtask.codeplex.com/workitem/list/basic and help evolve this community adapter You can also suggest new features, I am also open to new ideas.

You can also find the Installation process documented here: BizTalk Scheduled Task Adapter 6.0: Installation process

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Oporto City is ready to receive Oporto Global Integration Bootcamp – March 25, 2017 – Oporto, Portugal

Oporto City is ready to receive Oporto Global Integration Bootcamp – March 25, 2017 – Oporto, Portugal

I am really excited to announce that all the arrangements for first Oporto Global Integration Bootcamp are almost finalized and I can now release 90% of the event agenda. This event will be held at DevScope offices in Oporto on March 25, 2017, between 09:00 – 17:00.

Oporto Global Integrattion Bootcamp: BizTalk Server 2016, Logic Apps, Service Bus, Enterprise Integration Pack, API Management, On-Premise Gateway, Hybrid Integration, Microsoft Flow

What is Global Integration Bootcamp?

Global Integrattion Bootcamp: BizTalk Server 2016, Logic Apps, Service Bus, Enterprise Integration Pack, API Management, On-Premise Gateway, Hybrid Integration, Microsoft Flow

This is a free, event driven by user groups and communities around the world, backed by Microsoft, for anyone who wants to learn more about Microsoft’s integration story. In this full-day boot camp, we will deep-dive into Microsoft’s integration stack with hands-on sessions and labs, delivered to you by the experts and community leaders. In this Boot Camp, we will focus on:

  • BizTalk Server 2016: BizTalk Server 2016, what’s new, and using the new Logic Apps adapter.
  • Logic Apps: Creating Logic Apps using commonly-used connectors.
  • Service Bus: Build reliable and scalable cloud messaging and hybrid integration solution
  • Enterprise Integration Pack: Using the Enterprise Integration Pack (EIP) with Logic Apps
  • API Management: How does API management help you organize your APIs and how does it increase security?
  • On-Premise Gateway: Connecting to on-prem resources using the On-Premise Gateway
  • Hybrid Integration: Hybrid integrations using BizTalk Server and Logic Apps
  • Microsoft Flow: Learn to compose flows with Microsoft Flow

But much more. Porto will be joining locations all over the globe holding this event on the same day. Check out the global website for information about the global organizers and other locations, or follow the Twitter hashtag #integrationbootcamp.

Oporto Global Integration Bootcamp Agenda

09:00 Registration opens and welcome

10:00 BIZTALK 2016 IN A HYBRID WORLD
The integration landscape has definitely evolved to be a hybrid, significant on-premise investment has been accumulated over the years while at the same time cloud computing brought new challenges and new ways of implementing integration. Let’s navigate through the innovations in both worlds and how BizTalk and the cloud currently live together. – Ricardo Torre

11:00 BIZTALK OCTOPUS DEPLOY
How to deploy BizTalk solutions with Octopus – José António Silva & Pedro Sousa, DevScope

11:30 Coffee-break

11:45 UNLEASH THE POWER OF IOT WITH SHAREPOINT 
SharePoint is becoming modern, there are modern sites ready for mobile, a modern framework to develop web parts, but what about embracing modern concepts?

Internet of things will be everywhere in a blink of an eye and probably you are already dealing with it every day without even knowing.

In this session, we will explain how to collect data from sensors, send it to SharePoint and how to display it in a modern dashboard using modern SharePoint sites.

The possibilities are endless, from temperature sensors to access control devices you can have all this data inside your SharePoint Intranet with a modern look and feel. – João Ferreira, BindTuning

12:45 THE SPEAKER NIGHTMARE: Eval Forms & OCR & Logic Apps & Power BI
In this session, I will show and explain a real live demo on how we can easily build a robust solution for process evaluation forms, using an OCR software and easily integrate them with Power BI to present the results in an interactive and beautiful way. But most important: How you can educate your enterprise Developers and IT pros users to easily extend capabilities for power users, who understand their business challenges the best, and allowing them to use their familiar tools like: OCR software to process Evaluation forms and quickly build and deliver Power BI solutions to build Interactive Data dashboards. And at the same time integrate these tools, platforms or systems and a very quick and robust way using integrate feature on Azure, like, Logic Apps, API Apps and Azure Functions. How to start from a simple solution and evolve them enabling new functionalities. – Sandro Pereira, Microsoft Integration MVP

13:15 Lunch and Networking

Register

The agenda is not completely defined, you see that there are some sessions to be announced and can be subject to changes in terms of order of the sessions.

Thanks to sponsorship from DevScope, this event will be free of charge, including the catering, however, capacity will be limited in the venue so don’t delay and reserve your ticket at https://www.eventbrite.com/e/oporto-global-integration-bootcamp-tickets-31508629158. I’m looking forward to welcoming you to the Oporto Global Integration Bootcamp on March 25, 2017!

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

BizTalk Scheduled Task Adapter 6.0: Installation process

BizTalk Scheduled Task Adapter 6.0: Installation process

Introduction

The BizTalk Scheduled Task Adapter is an In-Process receive adapter that executes a prescribed task on a daily, weekly or monthly schedule. The adapter is configured entirely within BizTalk, all configurations are stored within the SSODB and can be exported and imported via binding files.

The schedule capabilities are similar to those available with the Windows Scheduled Task Service.

Four simple tasks are included in this version:

  • XmlStringStreamProvider – generates a BizTalk message from a configured XML string
  • FileStreamProvider – generates a BizTalk message from the contents of a file
  • HttpDownload – generates a BizTalk message from data downloaded from a website
  • SQLStreamProvider – generates a BizTalk message from the contents of a SQL Query (similar to the old SQL adapter)

Custom tasks can be created. Any .NET class that implements the appropriate interface can be scheduled.

Release History

This adapter is available since BizTalk Server 2004.

  • Release 6.0: release on March 1, 2017, by Sandro Pereira, this adapter was tested to work on BizTalk Server 2016. Compiled in .NET Framework 4.6
  • Release 5.0: release on February 18, 2015, by Sandro Pereira, this adapter was tested to work on BizTalk Server 2013 R2. Compiled in .NET Framework 4.5
  • Release 4.0: release on June 12, 2012, by Sandro Pereira, this adapter was tested to work on BizTalk Server 2010. Compiled in .NET Framework 4.0
  • Release 3.0: release on Aug 10, 2010, by Greg Forsythe, this adapter was tested to work on BizTalk Server 2009. Compiled in .NET Framework 2.0
  • Release 2.0: last release on Apr 20, 2008, by Greg Forsythe, this adapter works with BizTalk Server 2006 and BizTalk Server 2006 R2. Compiled in .NET Framework 2.0
  • Release 1.02: last release on Apr 20, 2008, by Greg Forsythe, this adapter works with BizTalk Server 2004, BizTalk Server 2006 and BizTalk Server 2006 R2. Compiled in .NET Framework 1.1

Requirements

The BizTalk Scheduled Task Adapter v6.0 will work with:

  • BizTalk Server 2016
  • .NET Framework 4.6

How to install BizTalk Scheduled Task Adapter

To install the adapter you need to run “ScheduledTaskAdapter.msi”.

  • In the “Welcome” screen, click “Next”.

BizTalk Scheduled Task Adapter Welcome

  • In the “Select Installation Folder” screen, you must set the installation locations were you what to install the adapter and then click “Next”.

BizTalk Scheduled Task Adapter Select Installation Folder

  • In the “Confirm Installation” screen, click “Next”, then it will appear the installation progress

BizTalk Scheduled Task Adapter Confirm Installation

  • Assuming all goes well, the “Installation Complete” screen will appear. Click “Close” to finish the installation process.

BizTalk Scheduled Task Adapter Installation Complete

The setup will install the following assemblies in the selected folder (The default folder is: C:Program Files (x86)BizTalk ScheduledTask Adapter 6.0):

  • BizTalk Scheduled Task Adapter.pdf (Installation manual)
  • Biztalk.Adapter.ScheduledTaskProperties.dll
  • Calendar.Schedules.dll
  • Microsoft.BizTalk.CommonSettings.dll
  • Microsoft.BizTalk.SqmFramework.dll
  • ScheduledTaskAdapter.Admin.dll
  • ScheduledTaskAdapter.dll
  • ScheduledTaskAdapter.TaskComponents.dll
  • stdole.dll

The setup will add the following assemblies to the Global Assembly Cache (GAC)

  • Biztalk.Adapter.ScheduledTaskProperties.dll
  • Calendar.Schedules.dll
  • ScheduledTaskAdapter.dll
  • ScheduledTaskAdapter.Admin.dll
  • ScheduledTaskAdapter.TaskComponents.dll

The setup will add the following registry key:

  • HKEY_CLASSES_ROOTCLSID{7A4BDD2A-3063-4f57-A108-DEA05DEB417E}

Post-Installation

Register the Adapter with BizTalk

As it happens with all adapters that we installed on our BizTalk Servers before we can begin to use it we need to register or configure the adapter. To accomplish that we need to:

  • Open BizTalk Administration Console
  • In the console left tree, expand “BizTalk Server Administration –> BizTalk Group –> Platform Settings” and then “Adapters”
  • Right-click on “Adapters” and add a new adapter by selecting the option “New –> Adapter”

BizTalk Scheduled Task Adapter New Adapter

  • In the “Adapter Properties” window
    • Set the name of the adapter: Name = Schedule
    • In the adapter combo box, select the option: Schedule
    • Set the description of the adapter: “BizTalk Scheduled Task Adapter. The schedule capabilities are similar to those available with the Windows Scheduled Task Service.” (this property is optional but I would suggest to always be filled)

BizTalk Scheduled Task Adapter New Adapter Schedule

  • Note: This configuration requires that you restart the host instance associated with the adapter. At this moment, click “Ok” to continue the configuration process.

BizTalk Scheduled Task Adapter New Adapter restart hosts

  • [Optional] By default, the Receive Handler configured for the BizTalk Scheduled Task Adapter will be the default Host configured in the environment, that normally is “BizTalkServerApplication”. We can change this behavior by:
    • In the BizTalk Server Administration Console, expand “BizTalk Server Administration”, expand “BizTalk Group”, expand “Platform Settings”, and then expand “Adapters”.
    • In the expanded adapter list, right-click the Schedule adapter and then select the option “New –> Receive Handler

BizTalk Scheduled Task Adapter New Receive Handler

  • In the Schedule – Adapter Handle Properties” dialog box, on the General tab, in the Host Name list, select the host with which the adapter handler will be associated. And then click “Ok”

BizTalk Scheduled Task Adapter New Receive Handler

  • Again, at this point, a pop-up will appear notifying that this configuration requires that you restart the host instances associated with the adapter. At this moment, click “Ok” to finish the configuration process.

BizTalk Scheduled Task Adapter New Adapter restart hosts

  • To finish this configuration process, in the BizTalk Server Administration console tree, expand BizTalk Server Administration, expand the BizTalk group, click Platform Settings, and then click Host Instances.
  • In the details pane, select host instance(s) you want to restart, right-click and then click “Restart”.

Using the adapter Context Properties (Optional)

To utilize the Scheduled Task adapter’s context properties within a filter or orchestration the Biztalk.Adapter.ScheduledTaskProperties.dll must be deployed into the BizTalkMgmtDb.

This can be achieved using the Biztalk Deployment Wizard or equivalent tool.

Note: This step is optional; you only need to do this if you want to use Scheduled Task adapter’s context properties within a filter or orchestration.

As previously mentioned, you can deploy Biztalk.Adapter.ScheduledTaskProperties.dll in various ways; I suggest that you do the following steps:

  • Open BizTalk Administration Console
  • In the console left tree, expand “BizTalk Server Administration –> BizTalk Group” and then “Applications”
  • Right-click on “Applications” and add a new application by selecting the option “New –> Application”

BizTalk Scheduled Task Adapter New Application

  • In the “Adapter Properties” window
    • Set the name of the application: BizTalk.Global
    • Set the description of the application: “Application that contains common resources to several applications” (this property is optional but I would suggest to always be filled)

BizTalk Scheduled Task Adapter New Application

  • Expand the application created previous and select the option “Resources”
  • Right-click and add a new BizTalk resource by selecting the option “New –> BizTalk Assemblies…”

BizTalk Scheduled Task Adapter New Application Add Resource

  • In the “Add Resources” window select “Add…” button and from the installation directory select the DLL “Biztalk.Adapter.ScheduledTaskProperties.dll” (You can find this DLL on the adapter installation folder, by default, C:Program Files (x86)BizTalk ScheduledTask Adapter 6.0)
    • And select the options: “Overwrite all”, “Add to the global assembly cache on add resource (gacutil)” and “Add to the global assembly cache on MSI file install (gacutil)”

BizTalk Scheduled Task Adapter New Application Add Resource

  • Select “OK” button
Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Beta version of BizTalk Scheduled Task Adapter is now officially available for BizTalk Server 2016

Beta version of BizTalk Scheduled Task Adapter is now officially available for BizTalk Server 2016

Once again, after many requests and many postponements, due to my unavailability and free time to take these tasks, BizTalk Scheduled Task Adapter is finally official available (version 6.0) and optimized for BizTalk Server 2016!

Schedule-task

This time is not a simple adapter migration, it actually has new schedule capabilities:

  • You can now schedule for a message to be triggered in a time period, for example, each hour, minutes or seconds, every day or on certain days (for example all days except weekends).

And several reported issues were solved, for example:

  • In some scenarios, trigger message sent twice at the same time – Solved
  • Bug: Time change (DST) bug – Solved
  • Bug: BizTalk Scheduled Task Adapter SQL Timeout issue – Solved

You can download this new version of the adapter in BizTalk Scheduled Task Adapter CodePlex project page:

The BizTalk Scheduled Task Adapter is an in-process receive adapter that executes a prescribed task on a daily, weekly or monthly schedule. The adapter is configured entirely within BizTalk, all configurations are stored within the SSODB and can be exported and imported via binding files.
The schedule capabilities are similar to those available with the Windows Scheduled Task Service.

Requirements

The Scheduled Task Adapter v6.0.0 is optimized and designed to be used with BizTalk Server 2016 (Compiled in .NET Framework 4.6).

V6.0.0 Changelog

  • Compiled in Visual Studio 2015 and .NET Framework 4.6.
  • Optimized for BizTalk Server 2016.
  • Support for 32 and 64-bit Host Instances.
  • New features
    • New Schedule capabilities – Time Schedule running every day or on certain days (for example all days except weekends).
  • Bug fixes
    • Bug: In some scenarios, trigger message sent twice at the same time – Solved
    • Bug: Time change (DST) bug – Solved
    • Bug: BizTalk Scheduled Task Adapter SQL Timeout issue – Solved
  • Improvements
    • Some improvements in Monthly schedules form
    • UTC support

Release History

This adapter is available since BizTalk Server 2004.

  • Release 6.0: release on March 4, 2017, by Sandro Pereira, this adapter was tested to work on BizTalk Server 2016. Compiled in .NET Framework 4.6
  • Release 5.0: release on February 18, 2015, by Sandro Pereira, this adapter was tested to work on BizTalk Server 2013 R2. Compiled in .NET Framework 4.5
  • Release 4.0: release on June 12, 2012, by Sandro Pereira, this adapter was tested to work on BizTalk Server 2010. Compiled in .NET Framework 4.0
  • Release 3.0: release on Aug 10, 2010, by Greg Forsythe, this adapter was tested to work on BizTalk Server 2009. Compiled in .NET Framework 2.0
  • Release 2.0: last release on Apr 20, 2008, by Greg Forsythe, this adapter works with BizTalk Server 2006 and BizTalk Server 2006 R2. Compiled in .NET Framework 2.0
  • Release 1.02: last release on Apr 20, 2008, by Greg Forsythe, this adapter works with BizTalk Server 2004, BizTalk Server 2006 and BizTalk Server 2006 R2. Compiled in .NET Framework 1.1
Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Contest: Win a Free Production Bronze License of BizTalk360

Contest: Win a Free Production Bronze License of BizTalk360

Pop quiz. How many times did you hear “BizTalk is dead”?

  1. Never.
  2. Once or twice
  3. Hundred times.
  4. I stopped counting…

If you agreed with the last two statements, this post and tool are definitely for you (because BizTalk is alive and well, even better, it has never been so good!). If you agreed with the first two, well, you’re a new kid on block but you’re still on time to learn this amazing platform.

You might have just realized that BizTalk360 is my main sponsor and once again I need to say to BizTalk360 team, THANK YOU! for the incredible work they have done.

I decided to go one-step further and request for more. What better way to this “blog premiere” than to distribute through the magnificent BizTalk Server community some amazing prizes… So, I decided to convince my sponsor to provide me some licenses of their products and good news… I GOT IT!!

The first contest I have 1 FREE PRODUCTION BRONZE LICENSE OF BIZTALK360 to give away, courtesy of BizTalk360.

BizTalk360-Admin-hero

Contest: “BizTalk360 License”

What do you need to do to participate in this contest?

All you have to do is sign-up for the Free 14 days trial version and activate the license in one or more of your BizTalk Environments (could be dev box, QA or Production)

Closing date: March 31th, 2017.

Terms of participation

What are the rules?

  • Once you have activated your trial license, simply email the trial license code to my email address sandro-pereira@live.com.pt with the subject line: “Contest – BizTalk360 License”.
  • Along with that information, please provide your first and last name and your country.

Award

One contestant will win:

  • 1 FREE PRODUCTION BRONZE LICENSE OF BIZTALK360

The award will be distributed by lottery and the license will be sent to the winner through email by BizTalk360.

Good luck!

PS: If you have never heard about BizTalk360 (possible only if you are a new kid in the BizTalk worldJ) you can glance through the product features here https://www.biztalk360.com/one-platform-biztalk-server/.

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

XXVIII Porto.Data Community Meeting | February 28, 2017 | SharePoint, PowerApps & Microsoft Flow

XXVIII Porto.Data Community Meeting | February 28, 2017 | SharePoint, PowerApps & Microsoft Flow

This post is for the BizTalk Server and other Portuguese Community, will be held on February 28, 2017 between 18:45 – 21:30 the XXVIII Porto.Data Community meeting at the Science and Technology Park of University of Porto (UPTEC) in Oporto.

For me it is a pleasure to return once again to this community, this time with a topic about SharePoint, PowerApps and Microsoft Flow: “SharePoint integration: How can PowerApps and Microsoft Flow give power to your SharePoint users

Abstract

Every organization faces constant pressure to do more with less. While technology is often key to operating more effectively and efficiently, cost and complexity have often prevented organizations from taking maximum advantage of the potential benefits. The growth of SaaS (software as a service) has lowered barriers – no need to deploy servers or to install and configure complex software systems. Just sign up and go.

Microsoft Flow and Microsoft PowerApps will help these people (normally business users) achieve more.

We know not every business problem can be solved with off-the-shelf solutions. But developing custom solutions has traditionally been too costly and time consuming for many of the needs teams and departments face, especially those projects that integrate across multiple data sources or require delivery across multiple devices from desktop to mobile. As a result, too many technology needs end up unsolved or under-optimized. We piece together spreadsheets, email chains, SharePoint or/and manual processes to fill in the gaps.

PowerApps and Microsoft Flow are both aimed squarely at these gaps. They give people who best understand their needs and challenges the power to quickly meet them, without the time, complexity and cost of custom software development.

In this session, we will look at these two-new offering from Microsoft: PowerApps and Flow. What are day? How can I use it? But special we will walk through and create from scratch some live demos showing how to create a new PowerApp that connects to a list stored in SharePoint Online, or how to create a new Microsoft Flow that connects to a list stored in SharePoint Online.

Agenda

18:45 – Welcome reception

18:50 – Community News

19:00 – “Elasticsearch – First Glance” – Vitor Saraiva – Software Architect at Farfetch & Mário Barbosa – Engineering Lead at Farfetch

20:10 – Coffee break

20:30 – ” SharePoint integration: How can PowerApps and Microsoft Flow give power to your SharePoint users” – Sandro Pereira – Azure MVP – DevScope

21:15 – Closure

21:20 – Prize draw

21:30 – Dinner (optional)

This is a free event with very limited vacancies that you will not want to miss, register now!

Join us and come to spend a different carnival night! We are waiting for you.

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.