Why did we build Advanced Tracking Manager in BizTalk360?

Why did we build Advanced Tracking Manager in BizTalk360?

Advanced Tracking Manager BizTalk360

This blog is a part of the series of blog articles we are publishing on the topic “Why we built XYZ feature in BizTalk360”. Read the main article here.

Why do we need this feature?

Message Body and Message Context (properties) tracking is one of the key characteristics of BizTalk Server. A typical flow in BizTalk Server will involve a message that is received from the source system via the receive port, then transmitted to an orchestration (not always) for some business process, and then finally transmitted to the destination systems via the  send ports. During this journey, the original message might have gone through various processing and transformations. It’s important to keep track of all the state changes by logging the message content and context at each change point. BizTalk Server provides this functionality out of the box through a very rich tracking mechanism at various points of the journey.

You can track the message body, properties and events at various points as shown below.

Receive Port & Send Port (One way)

  • Message Bodies  – before and after port processing
  • Message Context  – before and after port processing

Receive Port & Send Port (Two way)

  • Message Bodies (Request) – before and after port processing
  • Message Context (Request) – before and after port processing
  • Message Bodies (Response) – before and after port processing
  • Message Context (Response) – before and after port processing

Orchestration

  • Message Bodies – before and after orchestration processing
  • Message Properties – incoming and outgoing messages
  • Track Events – Orchestration start and end
  • Track Events – Message send and receive
  • Track Events – Shape start and end

Pipeline

  • Message Bodies – before and after pipeline processing
  • Track Event – Port start and end
  • Track Event – Message send and receive

Business Rule Policy

  • Fast Activity – track instance data
  • Condition Evaluation – true/false results of condition
  • Rule Firing – actions started as result of policy
  • Agenda updates

Schemas

  • Promoted Properties

As you can see, BizTalk Server provides a very rich tracking framework and mechanism to track pretty much anything that goes through the system. It also gives the end customer full control of what data/property/event needs to be tracked at precise points in the message flow.

What are the current challenges?

Even though BizTalk Server comes with a strong framework for Tracking, the management capabilities of tracking settings is not ideal in the standard BizTalk Admin Console.

Central Management: In the BizTalk Admin Console, there is no option for you to visualize the tracking configuration of all the entities (like receive port, pipeline, orchestration etc.) from a single place. If you wanted to view or change a tracking setting, you need to manually visit each entity  and make required changes.

Bulk Actions: You cannot perform bulk actions like changing the tracking settings of all the entities with a single click.

Undesired Tracking Configuration: Often times when the BizTalk applications are migrated from development or QA environments to production, the tracking settings are also copied unwittingly (during export/import binding files). In the development and QA environment you typically have more tracking, but in production you’ll have only required minimum tracking due to performance reasons.

How BizTalk360 solves this problem?

BizTalk360 addresses all the above challenges with the “Advanced Tracking Manager” functionality.

biztalk360-tracking-manager

As you can see from the above screenshot, BizTalk360 provides a single unified view of the tracking configuration in a single place with easy to understand colour coding. You can easily make bulk changes with almost single click. You can visit the Advanced Tracking Manager at any time and see the level of tracking you have for the environment.

We have noticed interesting customer scenarios where they typically turn off all tracking for performance reasons and the moment they need to identify some problem, they enable required tracking via Advanced Tracking  Manager and turn it off once the diagnosis is done.

In another customer scenario, as part of the deployment process check list, they check the tracking settings in the environment after each BizTalk Application deployment. This reduces the risk of having unwanted tracking settings in their production environment.

If you are interested, there is a more detailed article on all the capabilities of Advanced Tracking Manager.

Get started with a Free Trial today!

If you are struggling with all the above mentioned challenges, why not give BizTalk360 a try. It takes about 10 minutes to install on your BizTalk environments and you can witness and check the security and productivity on your own BizTalk Environments. Get started with the free 30 days trial.

try biztalk360 for free

Author: Saravana Kumar

Saravana Kumar is the Founder and CTO of BizTalk360, an enterprise software that acts as an all-in-one solution for better administration, operation, support and monitoring of Microsoft BizTalk Server environments. View all posts by Saravana Kumar

Why did we build Centralized Advanced Event Viewer for BizTalk Administration?

Why did we build Centralized Advanced Event Viewer for BizTalk Administration?

Advanced Event Viewer BizTalk360

This blog is a part of the series of blog articles we are publishing on the topic “Why we built XYZ feature in BizTalk360”. Read the main article here.

Why do we need this feature?

When it comes to troubleshooting operational problems in BizTalk Server, the first place the BizTalk administrator or support person will look is the standard BizTalk Admin Console. Once if they can’t find anything obvious in the Admin Console, their next point of search will be the Event Viewer in the physical BizTalk Server machines and sometimes in the SQL Server machines.

Here are few challenges with this approach —

Correlating events across multiple BizTalk/SQL Servers: A typical BizTalk Enterprise production environment will have at least 2 BizTalk servers and 2 SQL servers to make the environment highly available. If there is a problem, you need to look into the Windows Event Viewer of each server and try to correlate and nail down the problem. This is time consuming.

Security Challenge – Administrator Access to BizTalk/SQL Servers: If you want to have access to Event Viewers in Windows Servers, then you need to have pretty much Administrator rights on the server(s). This is something that the organization needs to avoid.

Too much noise in the Event Viewer: Generally, every single problem or logging that happens in Windows Servers goes into the Event Viewer. Even though Event Viewer has the concept of Categories, it will still be noisy and the Administrator needs to have enough knowledge to understand what they are looking for in the Event Viewer. This could be a potential time loss exercise.

What is the current limitation in BizTalk Server?

BizTalk Server out of the box does not have any special tooling to address this challenge. It simply relies on Administrators to use the standard Windows Event Viewer MMC snap in. This will result in all the three challenges highlighted in the previous section. What this means is that people have gotten adapted to certain ways of solving the problems and Microsoft BizTalk Server lacks the proper tooling to address the challenge.

How does BizTalk360 solves this problem?

BizTalk360 comes with a key feature called “Centralized Advanced Event Viewer”.  It periodically collects the events that are related to BizTalk (out of the box we collect certain Event Log Categories, Administrators can also add additional categories) from all the BizTalk and SQL servers in the environment and store them in a central database. The collected data is then searched and then made viewable in the BizTalk360 web based user interface.

biztalk360-advanced-event-viewer

This approach seamlessly solves all the problems we highlighted previously. The BizTalk Administrators or support people need not physically access the servers via RDP (remote desktop) connection. They can easily correlate events in a single place and construct complex filters like for example: events related to Enterprise SSO across all the BizTalk Servers for a time range.

What is the business value?

Address Security Concerns: Businesses do not want too many people logging on/off into their production servers with highest privileges during business hours. This can be rectified using BizTalk360 Advanced Event Viewer.

Reduce time to diagnose issue: It’s much faster to look into the reason for errors in one place rather than looking at many places and try to correlate events. This dramatically reduces the time it takes to solve the problem. In a typical BizTalk Server troubleshooting exercise, this is how the operations/support person loses a ton of time.

Get started with a Free Trial today!

If you are struggling with all the above mentioned challenges, why not give BizTalk360 a try. It takes about 10 minutes to install on your BizTalk environments and you can witness and check the security and productivity on your own BizTalk Environments. Get started with the free 30 days trial.

try biztalk360 for free

Author: Saravana Kumar

Saravana Kumar is the Founder and CTO of BizTalk360, an enterprise software that acts as an all-in-one solution for better administration, operation, support and monitoring of Microsoft BizTalk Server environments. View all posts by Saravana Kumar

Integration Down Under… is UP & RUNNING!

Integration Down Under… is UP & RUNNING!

For years now Integration Monday has been faithfully giving us webinars almost every week. There have been some outstanding sessions from international leaders in the integration space including MVPs, members of the Microsoft product team, and other community members. For the Asia Pacific community, however, it has always been a challenge to participate in the live sessions due to the unfriendly time zone.  (I certainly know what a struggle it was to present my own session last October at 4:30am!)  Even from the listener’s perspective, it is usually nicer to be able to join a live webinar and ask questions rather than to consume the recordings afterwards.

Thanks to the initiative of veteran MVP Bill Chesnut (aka “BizTalk Bill”) and the sponsorship of his employer SixPivot, we now have a brand new webinar series starting up in a friendlier time slot for our APAC community! Integration Down Under is launching its inaugural webinar session on Thursday, 8th February at 7:00pm AEST. You can register for this free event here.

This initial session will introduce the leaders and allow each of us to present as very short talk on a chosen topic:

There are already more than twenty registrations even though the link has been live for only a few days. I hope that this is a good sign of the interest within the community!

Feeling really fortunate to be part of this initiative, and looking forward to delivering my intro to Event Grid talk! It will be a slightly scaled down version of what I presented at the Sydney Tech Summit back in November. Hope to see you there!

Why did we build the Secure SQL Queries capability in BizTalk360?

Why did we build the Secure SQL Queries capability in BizTalk360?

Secure SQL Queries BizTalk360

This blog is a part of the series of blog articles we are publishing on the topic “Why we built XYZ feature in BizTalk360”. Read the main article here.

Why do we need this feature?

In a BizTalk Server support scenario, one of the common things that happen is people accessing the BizTalk System and some custom databases regularly using tools like SQL Management Studio to run some reporting queries. Some of the system databases will include BizTalk Message Box (BizTalkMsgBoxDb), BizTalk Management (BizTalkMgmtDb), BizTalk Tracking  (BizTalkDTADb), Business Activity Monitoring – BAM (BizTalkPrimaryImport).  BizTalk Administrator and support people access these databases for a variety of requirements such as to check tables like spool or host tables in Message Box, Message In-out table in tracking database, looking for some values in BAM database tables, cross reference data, check for large messages etc.

What are the current challenges?

Performance Impact: Some of the BizTalk databases can grow extremely bigger. It’s not uncommon to have over 1 million records in certain tables (ex: MessageInOut table in Tracking Database). Executing some queries like just a plain “SELECT * ..” on those tables without any query optimization or locks can have serious performance impact during business hours.

Productivity Improvement: BizTalk Support Team will typically have a bunch of standard SQL queries they run on a regular basis to get some reporting on BizTalk databases. Each individual team members will have their own set of SQL queries and they manage it in their local machines.  This basically results in two things, useful reporting queries are not shared between team members and maintaining the queries in SQL files and accessing different files for different environment is not productive.

No consolidated tooling: If BizTalk Administrator or support person needs to run some reporting queries, they need to use an external tool like SQL management studio.

What is the current limitation in standard BizTalk Admin Console?

The standard BizTalk Admin Console does not come with any capabilities related to accessing SQL data. This leaves the support people to rely on external SQL tools like SQL Server Management Studio (SSMS). Tools like SSMS are designed for DBA’s and Developers and it’s not particularly friendly when it comes to pure support and management – a level of technical expertise is required to use SSMS.

How BizTalk360 solves the problem?

We understood the practical challenges of not having an integrated SQL data access tool along with BizTalk Administration and the challenges it exposes (as explained above). This resulted in building “Secure SQL Queries” platform in BizTalk360.

The principles are quite simple — a DBA or someone who understands SQL well writes optimized SQL queries and store them with friendly names in BizTalk360. Ex: “Depth of Message Box Spool Table”. Then, assign who will have permissions to run the queries. May be not all the queries are required for every support person. BizTalk360 can then work like a reporting tool for these custom SQL queries and display them in the web interface directly.

secure-sql-queries-biztalk360

This approach eliminates people from directly running non-optimized queries in production environments and it also simplifies having access to SQL data within a single web console instead of switching tools.

One of the biggest advantage is that useful SQL reporting queries in your BizTalk environment can be centrally stored and shared between team members.

NOTE: The platform is very generic; you can store and execute SQL queries across any databases and not necessarily just BizTalk Server databases as long as the service account has right privileges to access the data.

What is the business value?

The business benefits are very obvious. Providing a secure web based platform for accessing SQL sever data (which is critical to the day-to-day operations of any BizTalk Server solution) increases the productivity of support/BizTalk Admin people and makes it extremely secure. In general, you can keep your database administrators (DBA’s) happy in the organisation.

Get started with a Free Trial today!

Download and try BizTalk360 on your own environments free for 30 days. Installation will not take more than 5-10 minutes.

BizTalk360 30 Days Free Trial

Author: Saravana Kumar

Saravana Kumar is the Founder and CTO of BizTalk360, an enterprise software that acts as an all-in-one solution for better administration, operation, support and monitoring of Microsoft BizTalk Server environments. View all posts by Saravana Kumar

Microsoft Integration Weekly Update: Jan 29, 2018

Microsoft Integration Weekly Update: Jan 29, 2018

Do you feel difficult to keep up to date on all the frequent updates and announcements in the Microsoft Integration platform?

Integration weekly update can be your solution. It’s a weekly update on the topics related to Integration – enterprise integration, robust & scalable messaging capabilities and Citizen Integration capabilities empowered by Microsoft platform to deliver value to the business.

If you want to receive these updates weekly, then don’t forget to Subscribe!

Feedback

Hope this would be helpful. Please feel free to provide any feedback on this Integration weekly series.

Advertisements

Why did we build Team Knowledgebase feature in BizTalk360?

Why did we build Team Knowledgebase feature in BizTalk360?

Team Knowledgebase BizTalk360

This blog is a part of the series of blog articles we are publishing on the topic “Why we built XYZ feature in BizTalk360”. Read the main article here.

Why do we need this feature?

Microsoft BizTalk Server being a middleware platform sitting right in the middle of the organisation connecting all the systems together, it’s inevitable there will be some regular operational challenges. When you are talking to multiple systems, it’s hard to control every end systems. Some of the common problem you encounter will be a partner sending the message that contains some unknown characters, having the format of the date in wrong format etc.

In BizTalk Admin console, when such problems occur and depending on how the exceptions are handled most of the time, it will result in some form of suspended service instances with some error code. Typically a BizTalk support person will start analysing it within the BizTalk Admin console or via the Event Viewers in BizTalk Servers and find a relevant solution.

Over a period, the BizTalk support team will know the answers for pretty much all the known issues and they will be able to solve the problem quickly. However, what happens if someone leaves the team or you bring someone new to the team. It will take equal amount of time for that new person to pick up all the known issues.

Few organisations maintain some kind of internal wiki or SharePoint documents to cover all the known issues, however they are not always updated and in sync, multiple documents, and no one actively look into those documents for solution. They always tend to start from scratch and end up spending time diagnosing the problem.

To address this particular challenge we have built “Team Knowledgebase” capability within BizTalk360.

What is the current limitation in BizTalk Server Admin Console?

BizTalk Server Admin console doesn’t come with any such capability to address this real world challenge. BizTalk Admin Console is designed more for hard-core technical BizTalk people and it expects a level of BizTalk knowledge, it only displays the technical error descriptions whenever there are suspended instance.  There is no option for team collaboration and ability to store solutions to the problem.

How does BizTalk360 solve this problem?

We identified this feature could be a huge time saver when it comes to BizTalk Solutions support and also it helps to bring non-BizTalk people into supporting BizTalk solutions easily.

BizTalk360 provides a platform to store team knowledge base articles for known issues. Example: If an instance gets suspended with some error code “0x34564” for a particular application, the support person can easily write a short knowledge base article saying this particular error happens due to “Known issue with our partner Contoso, their internal systems are not capable of sending date time in the format our system is expecting”, the support person can also set the rules saying this is applicable for Application XYZ, the instance status should be “Suspended-Non resumable”, the Environment should be “Production”, the error description text should contain “Contoso”.

biztalk360-team-knowledgebase

Once the knowledge base article is created with set of rules, BizTalk360 will keep watching for any errors that happens in the system and if it matches an existing knowledge base condition, it will show a small book icon next to the error. This helps the support person to quickly realize it’s a known issue and also see the solution to the issue.

The team knowledge base capability is available for Suspended Instances, Event Viewer, ESB Errors, Throttling Conditions in BizTalk360.

What is the business value?

As you can see the business value of the team knowledgebase feature is huge, it drastically reduces the time taken to troubleshoot the problem, especially for the repeated ones. The feature also helps to mitigate the risk of good people leaving the organisation with the knowledge and also helps to on-board new people into the team and bring them up-to speed pretty quickly.

Get started with a Free Trial today!

Download and try BizTalk360 on your own environments free for 30 days. Installation will not take more than 5-10 minutes.

try biztalk360 for free

Author: Saravana Kumar

Saravana Kumar is the Founder and CTO of BizTalk360, an enterprise software that acts as an all-in-one solution for better administration, operation, support and monitoring of Microsoft BizTalk Server environments. View all posts by Saravana Kumar

Why did we build Graphical Message Flow viewer in BizTalk360?

Why did we build Graphical Message Flow viewer in BizTalk360?

Graphical Message Flow Viewer BizTalk360

This blog is a part of the series of blog articles we are publishing on the topic “Why we built XYZ feature in BizTalk360”. Read the main article here.

Why do we need this feature?

To be able to do his job, a BizTalk administrator needs to know what kind of processes flow through the BizTalk environment. This insight can be used for a number of purposes, like:

  • analysis and/or debugging of issues
  • learning/training purposes
  • documentation purposes

One of the features which can be used to better understand the processes in BizTalk is the Tracking queries which can be accessed through the BizTalk Administration Console. These queries provide insight on which messages and orchestrations have been processed by BizTalk. From the Tracking queries, it is also possible to have some insight on the message flow.

What are the current challenges?

The major problem with the message flow which can be shown in BizTalk Admin console is that it is very textual and doesn’t allow you to show the entire flow. This makes understanding the processes in BizTalk a time-consuming task.

Another disadvantage is that when somebody accesses the tracking queries in the BizTalk Admin console, confidential information might be revealed to unauthorized people.

How BizTalk360 solves this problem?

BizTalk360 offers a lot of features to provide insight in BizTalk processes. One of these features is the Graphical Message Flow viewer.
As with the Tracking queries in the BizTalk Admin console, the Graphical Message Flow viewer depends on tracking data. So, to start using the Graphical Message Flow viewer, you start with creating a Tracking query in BizTalk360.

Graphical Flow Tracking BizTalk360

As you can see from the Build Query Expression part of the screen, you can create the same kind of queries as in the BizTalk Administration console. You can also save your tracking queries for later use. These queries are stored in the BizTalk360 database, so you always have them at hand. Whereas with the BizTalk Admin console, your queries are stored to the file system which can make it harder to retrieve them, especially when you have multiple BizTalk servers.

Details of the tracked service instances can be viewed by simply clicking the eye icon in the most right column of the grid.

The first column of the results grid shows the name of the service as a hyperlink. By clicking the hyperlink, the Graphical Message Flow for the service instance will be shown.

Graphical Flow Tracking in BizTalk360

The Graphical Message Flow viewer shows the service instance as a shape and depending on the type of artifact, then it will appear under the Receive Port, Orchestration or Send Port label. The blue dot in the shape reflects the receive side of a message at the artifact, while the green dots reflect that the message has been sent out of the artifact. In the above screenshot, one message has been received and multiple messages have been sent out, depicting a debatching scenario.

Besides the graphical shape of the service instance, also all kind of properties of the service instance is shown. You can even directly navigate to the BizTalk artifact in its BizTalk application, by simply clicking the provided hyperlink.

Also, the related service instances can be viewed, depicting the complete message flow. This can be done by clicking the subsequent green dots.

Graphical Flow Tracking scenario BizTalk360

Depending on the amount of tracking turned on for the artifacts and whether the user is authorized in BizTalk360, message context and content information can be viewed in the pane at the right of the screen.

The Graphical Message Flow viewer is a very useful feature and it is likely that BizTalk administrators will use it on a near day to day basis.

Get started with a Free Trial today!

Download and try BizTalk360 on your own environments free for 30 days. Installation will not take more than 5-10 minutes.

try biztalk360 for free

Author: Lex Hegt

Lex Hegt works in the IT sector for more than 25 years, mainly in roles as developer and administrator. He works with BizTalk since BizTalk Server 2004. Currently he is a Technical Lead at BizTalk360. View all posts by Lex Hegt

Why did we build Search and Action on BizTalk Artifacts?

Why did we build Search and Action on BizTalk Artifacts?

Search and Action Artifacts BizTalk360

This blog is a part of the series of blog articles we are publishing on the topic “Why we built XYZ feature in BizTalk360”. Read the main article here.

Why do we need this feature?

In their day to day operations, BizTalk administrators will regularly need to check the status of different BizTalk artifacts. There might be multiple reasons to do so, amongst which are:

  • Artifacts being in the wrong state (a Receive Location being Disabled, instead of Enabled)
  • The configuration of an artifact needs to be checked for analysis of an issue
  • The state of artifacts needs to be persisted, because of an upcoming deployment

To access the actual state and configuration of BizTalk artifacts, BizTalk administrators need to use a Remote Desktop connection to access the BizTalk server and start the BizTalk Server Administrator Console. The BizTalk Administrator console is not very helpful in finding the needed artifact(s) as the console has no or only limited search functionality.

What are the current challenges?

Besides the fact that BizTalk administrators will not always have access to RDP, because they might not be at their own desk, the Administration console is not very helpful, when certain artifact(s) need to be found. For example, the Admin console has:

  • no or limited search feature (depending on the BizTalk Server version)
  • no state persisting feature

No or limited search feature

In versions older than BizTalk Server 2016, there are just browse features per artifact type, which can make it quite time-consuming to find the artifact(s) you are looking for.

With BizTalk Server 2016, Microsoft introduced a Search feature. However, that feature is limited to search only for the name of any artifact. So for example, it is not possible to search for the URI or the transport type of an artifact.

No state persisting feature

Besides taking screenshots, there is no feature to store the status of the artifacts. Taking screenshots will help a bit, but it is not very practical. Reason for that is because not all artifacts (of the same type) for which you want to persist the state might fit on the same screen. Therefore, you’ll have to make multiple screen shots and store them in for example a Word document, which decreases the usability.

How BizTalk360 solves this problem?

To address all the mentioned problems, BizTalk360 has the Search Artifacts feature. The Search Artifacts feature allows you to search for BizTalk artifacts in one single screen. Depending on the kind of artifact, you can search and filter for different properties of that kind of artifact. For example, for Receive Locations and Send ports, you can search and filter for:

  • Name of the artifact
  • The URI of the artifact
  • Application where the artifact resides
  • The status of the artifact (Enabled/Disabled or Started/Stopped/Unenlisted)
  • Host name which processes the artifact
  • Transport Type of the artifact

When you have searched for certain artifacts, BizTalk360 shows the results in a grid. Depending on the kind of artifact, this result grid will show the most important data for that kind of artifact.

BizTalk360 Search Artifacts

You can also, directly, action on a single artifact or on multiple artifacts. In case of Receive Locations for example, you can immediately Enable or Disable one or multiple Receive Locations from the grid. BizTalk360 shows a handy drop down box to select artifacts, depending on their state.

BizTalk360 Search Artifacts - Perform Actions

Further, you can access the properties of a certain artifact by clicking the eye icon which appears in the last column of the grid.

BizTalk360 Search Artifacts - Properties

Another handy feature is the ability to export the entire result grid to Excel. This feature is especially handy in case you are preparing the deployment of BizTalk application(s) and you want to persist the current state of the artifacts, as the state might be changed by the deployment package(s).

BizTalk360 Search Artifacts - Save to ExcelAll in all, the Search feature in BizTalk360 not only saves time in the day to day operations of a BizTalk administrator, but it will also make him or her look better, when a business user arrives at his or her desk with a quick question on the state of a particular artifact!

Get started with a Free Trial today!

Download and try BizTalk360 on your own environments free for 30 days. Installation will not take more than 5-10 minutes.

try biztalk360 for free

Author: Lex Hegt

Lex Hegt works in the IT sector for more than 25 years, mainly in roles as developer and administrator. He works with BizTalk since BizTalk Server 2004. Currently he is a Technical Lead at BizTalk360. View all posts by Lex Hegt

How can PowerApps and Microsoft Flow allow your Power Users to quickly build Enterprise Mobile Apps video and slides are available at Integration Monday

How can PowerApps and Microsoft Flow allow your Power Users to quickly build Enterprise Mobile Apps video and slides are available at Integration Monday

One of my main goals last year in Portugal was to introduce PowerApps and Microsoft Flow in several Portuguese communities: SharePoint, CRM, .NET and Integration communities. Finally, I was also invited to presented that session on Integration Monday community – I think it was the perfect scenario to deliver one last time that session – don’t get me wrong I will still be talking about these topics in the future but with different demos and context – and you can watch the video recording of the previous session here: How can PowerApps and Microsoft Flow allow your Power Users to quickly build Enterprise Mobile Apps.

That was the eighth session that I deliver for that community:

About my session

Session Name: How can PowerApps and Microsoft Flow allow your Power Users to quickly build Enterprise Mobile Apps

PowerApps and Microsoft Flow Session

Session Overview: Every organization faces constant pressure to do more with less. While technology is often the 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 they? How can I use it? But special we will walk through and create from scratch some live demos showing how to create Enterprise Mobile Application that easily connects with all your enterprise platforms like Office365, SharePoint Online, Dynamic CRM, on-premise SQL, Social Networks and much more and also how they can automate some common tasks using the new Microsoft Flow.

You can watch the video recording of this session here: How can PowerApps and Microsoft Flow allow your Power Users to quickly build Enterprise Mobile Apps.

About Integration Monday

Integration Monday is full of great sessions that you can watch and I will also take this opportunity to invite you all to join us next Monday.

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. View all posts by Sandro Pereira

Why did we build Auditing & Governance for BizTalk Server Administration?

Why did we build Auditing & Governance for BizTalk Server Administration?

This blog is a part of the series of blog articles we are publishing on the topic “Why we built XYZ feature in BizTalk360”. Read the main article here.

Why do we need this feature?

In the previous article “Why did we built User Access Policy to Manage BizTalk Server Security?”, we looked at the importance of securing the BizTalk Server environments, what are the limitations of existing security mechanisms in BizTalk Server and how BizTalk360 User Access Policy mechanism helps to address the gaps. The other important aspect that’s more closely related to security is the governance & auditing.

In a nutshell, Governance and Auditing simply means recording all the activities performed by a BizTalk Administrator or Operations person in your BizTalk Server environments. Auditing is such a crucial part for any enterprise software. Let’s take some example scenarios and see how the impact of such activities can cause huge business disruption.

Let’s imagine you have an integration scenario picking up purchase orders from a FTP location, processing it via a BizTalk Orchestration and finally sending it to the SAP system. In this simplest scenario, a BizTalk Administrator can potentially do the following 5 activities intentionally or accidentally —

  • Disabling the BizTalk FTP Receive Location
  • Unenlisting the BizTalk Orchestration
  • Stopping the BizTalk SAP Send Port
  • Stopping the Host Instances that run receive location, send port and orchestration
  • Terminate a BizTalk Service Instance that’s processing the purchase order

Any one of the above activity would have resulted in a business impact of not processing that purchase order.

When such incidents happen, you must have the system in place to look at the audit logs and see who actually performed such activity and take necessary steps. In critical industries like Healthcare and Financial institutions, Auditing and Governance are mandatory and governed by industry bodies like SOX and HIPAA.

What is the current limitation in BizTalk Server?

The standard BizTalk Server Admin console doesn’t come with any in-built auditing capabilities for user activities. Once someone has access to BizTalk Admin Console (i.e pretty much your entire BizTalk support team), they are free to perform any activities without a trace.

As mentioned in the previous section, pretty much every single activity the BizTalk Server administrator or support person performs in a controlled environment like Production will have significant consequences.

It’s a very common scenario in large teams for no one taking the blame when things go wrong. Question like “Do you know who stopped that host instance?” are common. The difficult part is you probably don’t know how long that particular host instance was in stopped state, since you don’t have the audit trace.

How does BizTalk360 solve this problem?

Once we built the web based BizTalk Server Admin console, the first top most priority we addressed in the product is sorting out the Security and Audit capabilities for administrative activities.  As you can see from the below picture, all the actions performed by the BizTalk Administrators are logged/audited.

BizTalk360 Governance Auditing

The actions could be something related to BizTalk Applications like starting/stopping Receive Locations, Send Port, Orchestration, it could be related BizTalk Host Instance like starting/stopping host instances, Service Instance activities like terminating, resuming, suspending, ESB management activities like resubmitting messages, and so on.

For every new feature we add to BizTalk360, we make sure auditing capabilities are also taken care of. The organisations can keep the audit data for however long they want based on their corporate policy; you can easily configure the data retention period in BizTalk360.

In order for us to build a system that’s capable of auditing user activities, we need to make sure BizTalk Administrators can use BizTalk360 instead of the standard BizTalk Admin console, that means covering each and every feature that’s available in BizTalk Admin Console needs a counter part in BizTalk360. Apart from deployment and configuration changes (ex: changing the password of FTP receive location), BizTalk Administrators can perform every activity in BizTalk360 that can be performed in the standard BizTalk Admin Console.

Can we audit user activities if it’s performed via BizTalk Admin Console?

This is one of the common questions we receive when we talk about Governance and Auditing. Unfortunately we cannot capture activities that’s performed outside BizTalk360. The idea is you restrict access to standard BizTalk Admin Console to very few people (super users) and force majority of the people to use BizTalk360 for controlled environments.

Get started with a Free Trial today!

Download and try BizTalk360 on your own environments free for 30 days. Installation will not take more than 5-10 minutes.

BizTalk360 30 Days Free Trial

Author: Saravana Kumar

Saravana Kumar is the Founder and CTO of BizTalk360, an enterprise software that acts as an all-in-one solution for better administration, operation, support and monitoring of Microsoft BizTalk Server environments. View all posts by Saravana Kumar