August 31, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

August 31, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

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

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.

Microsoft Announcements and Updates

Community Blog Posts

Videos

Podcasts

How to get started with iPaaS design & development in Azure?

Feedback

Hope this would be helpful. Please feel free to reach out to me with your feedback and questions.

How to Standardize Filenames with PowerShell

How to Standardize Filenames with PowerShell

Per request of community members, I recently, or not that recently, started to add the SVG files on my Microsoft Integration, Azure, Office 365, and much more Stencils Pack for Visio. However, this new feature brought me some new challenges:

  • How to easily manage and organize all these files;
  • How to detect duplicates;

To solve part of the first topic, I decide to manually create a folder called “SVG” for each group of stencils that exist in this package: Azure, Enterprise Integration, IoT, AI and Machine Learning, Databases and Analytics and so on.

And to solve the second part of the first topic and at the same time, the second challenge, I decided to automate the process by building a simple PowerShell script that allows me to:

  • Standardize all SVG filenames available in all subfolders by:
    • Not using spaces. Some software will not recognize file names with spaces, and file names with spaces must be enclosed in quotes when using the command line. Having spaces in URL’s are also not a good experience and should be avoided. For all these reasons I decided to remove all spaces and replace it will ‘-‘ (dash);
    • Names are in Camel case, where the first letter of each section of text is capitalized (of course respecting the line above), e.g., File-Name.svg
    • Having extension in lowercase, e.g., *.svg
  • List all the detected duplicate files.
    • I didn’t want to delete the duplicate files automatically because I want to be able to validate and decide if that indeed they are the same file or with is the most recent version of the representation.

The result was this small master piece:

#########################################################
#                                                       #
# Standardize SVG file names (CamelCase without spaces) #
# Author: Sandro Pereira                                #
#                                                       #
#########################################################

[String]$location = Get-Location

$files = Get-ChildItem $location -recurse -force -Filter *.svg
foreach($file in $files)
{
    $textInfo = (Get-Culture).TextInfo
    $newname = $textInfo.ToTitleCase([String]$file.Name.ToLower()).Replace(" ", "-").Replace(".Svg",".svg")
    Try
    {
        Rename-Item -Path $file.PSPath $newname -ErrorAction 'Stop'
    }
    Catch
    {
        Write-Host $file.PSPath
    }
}

Download

THIS POWERSHELL IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND.

Standardize SVG Filenames with PowerShellStandardize SVG Filenames with PowerShell
GitHub

The post How to Standardize Filenames with PowerShell appeared first on SANDRO PEREIRA BIZTALK BLOG.

August 24, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

August 24, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

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

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.

Microsoft Announcements and Updates

Community Blog Posts

Videos

Podcasts

How to get started with iPaaS design & development in Azure?

Feedback

Hope this would be helpful. Please feel free to reach out to me with your feedback and questions.

A fish out of water: How to Add connector points on Visio Stencils

A fish out of water: How to Add connector points on Visio Stencils

In the last blog post I spoke about how to add, or fix, text annotation bellow the shapes and how you can do it in a reusable way. On this blog post, we will be addressing another top complaint regarding my Microsoft Integration, Azure, BAPI, Office 365 and much more Stencils Pack for Visio package: Connector points.

A connection point is a special point on a shape that you can “glue” connectors and other shapes to. When you glue a connector or shape to a connection point, they stay connected, even if one of the shapes is moved.

Add a connection points on Visio Stencils

Connection points become visible when you try to connect one shape to another. You see a shape’s connection points when you hover near the shape with the Connector Tool or drag the endpoint of any connector or line near a shape that has connection points.

Add a connection points on Visio Stencils

if the shape you want to glue a connector to does not have a connection point where you want it, you can add one.

  • Select the shape.
  • On the Home tab, in the Tools group, click the Connection Point tool Button image.
Add a connection points on Visio Stencils
  • If connection points are not visible, on the View tab, in the Visual Aids group, select the Connection Points checkbox.
  • Press Ctrl and click where you want to add a connection point. The new connection point is automatically selected after you place it.
  • On the Home tab, in the Tools group, click Pointer Tool Select Objects to resume normal editing.
Add a connection points on Visio Stencils

Tips and Tricks – Fix or Add connector points on Visio Stencils (Video)

The post A fish out of water: How to Add connector points on Visio Stencils appeared first on SANDRO PEREIRA BIZTALK BLOG.

A fish out of water: How to fix Text annotations on Visio Stencils

A fish out of water: How to fix Text annotations on Visio Stencils

I don’t consider myself a master of Visio, although I use it a lot to make my solution diagrams or system architectures and have already been considered Visio MVP for a year for my contributions to this product. As you may know, I create several years ago a Microsoft Integration, Azure, BAPI, Office 365 and much more Stencils Pack for Visio that I maintain until today (the last update was 4 days ago). And one of the tops complain is about text annotations: be able as a standard behavior to add text annotation bellow the shapes rather than on top that is the default of most shapes present in this package.

Well, luckly there is, the only problem is that there are so many items to change in this collection that this will take some time to finish, nevertheless I already start to work on this and the first set is already fixed.

This blog and video will show you how to fix this issue and maybe you can join me and contribute on this GitHub project and help me speed up this process of fixing this issue.

Fix Text annotations on Visio Stencils

Click on the shape that you want and type something. if the text is on top of the shape follow this steps:

Fix Text annotations on Visio Stencils
  1. On the Home tab, in the Tools group, click the Text Block tool Text Block button.
  2. Drag and resize the text block and put it in the desired position, normally bellow the shape.
Fix Text annotations on Visio Stencils
  1. On the Home tab, in the Tools group, click the Pointer Tool Pointer button .

After you switch back to the Pointer Tool Pointer button, the text keeps the same position relative to the shape. If you use the Pointer Tool to drag the text, the shape will also move, even if the text is no longer on the shape.

Tip and tricks – Fix Text annotations on Visio Stencils (video)

The post A fish out of water: How to fix Text annotations on Visio Stencils appeared first on SANDRO PEREIRA BIZTALK BLOG.

Microsoft Integration and Azure Stencils Pack for Visio: New version available (v6.4.0)

Microsoft Integration and Azure Stencils Pack for Visio: New version available (v6.4.0)

It came to my attention that there were some Azure icons missing on this package like Azure Synapse Analytics, so I decide to make a refresh on this package and add some missing and new icons available on the Azure Portal.

What’s new in this version?

32 new icons added on the following files:

  • Microsoft Azure (MIS Azure Stencils.vssx): This package contains stencils of Azure Services (original icons) that are available thru the Azure Portal.
  • Microsoft Azure: Others (MIS Azure Others Stencils.vssx): This package contains other less important (or secondary features) and related stencils.
  • MIS: Security and Governance (MIS Security and Governance.vssx): This package contains stencils that will represent Security and Governance.
Microsoft Integration and Azure Stencils Pack for Visio: New version available (v6.4.0)

Continuing the process of improving the user experience regarding text annotations and connector points.

Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack

Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack it’s a Visio package that contains fully resizable Visio shapes (symbols/icons) that will help you to visually represent On-premise, Cloud or Hybrid Integration and Enterprise architectures scenarios (BizTalk Server, API Management, Logic Apps, Service Bus, Event Hub…), solutions diagrams and features or systems that use Microsoft Azure and related cloud and on-premises technologies in Visio 2016/2013:

  • BizTalk Server
  • Microsoft Azure
    • Integration
      • Integration Service Environments (ISE)
      • Logic Apps and Azure App Service in general (API Apps, Web Apps, and Mobile Apps)
      • Azure API Management
      • Messaging: Event Hubs, Event Grid, Service Bus, …
    • Azure IoT and Docker
    • AI, Machine Learning, Stream Analytics, Data Factory, Data Pipelines
    • SQL Server, DocumentDB, CosmosDB, MySQL, …
    • and so on
  • Microsoft Power Platform
    • Microsoft Flow
    • PowerApps
    • Power BI
  • Office365, SharePoint,…
  • DevOps and PowerShell
  • Security and Governance
  • And much more…
  • … and now non-related Microsoft technologies like:
    • SAP Stencils
Microsoft Integration (Azure and much more) Stencils Pack

The Microsoft Integration Stencils Pack is composed of 27 files:

  • Microsoft Integration Stencils
  • MIS Additional or Support Stencils
  • MIS AI and Machine Learning Stencils
  • MIS Apps and Systems Logo Stencils  
  • MIS Azure Additional or Support Stencils
  • MIS Azure Mono Color
  • MIS Azure Old Versions
  • MIS Azure Others Stencils
  • MIS Azure Stencils
  • MIS Buildings Stencils
  • MIS Databases and Analytics Stencils
  • MIS Deprecated Stencils
  • MIS Developer Stencils
  • MIS Devices Stencils
  • MIS Files Stencils
  • MIS Generic Stencils
  • MIS Infrastructure Stencils
  • MIS Integration Fun
  • MIS Integration Patterns Stencils
  • MIS IoT Devices Stencils
  • MIS Office365
  • MIS Power BI Stencils
  • MIS PowerApps and Flows Stencils
  • MIS SAP Stencils
  • MIS Security and Governance
  • MIS Servers (HEX) Stencils
  • MIS Users and Roles Stencils

That you can use and resize without losing quality, in particular, the new shapes.

Download

You can download Microsoft Integration, Azure, BAPI, Office 365 and much more Stencils Pack for Visio from:
Microsoft Integration Azure Stencils Pack VisioMicrosoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack for Visio
GitHub

The post Microsoft Integration and Azure Stencils Pack for Visio: New version available (v6.4.0) appeared first on SANDRO PEREIRA BIZTALK BLOG.

August 17, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

August 17, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

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

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.

Microsoft Announcements and Updates

Community Blog Posts

Videos

Podcasts

How to get started with iPaaS design & development in Azure?

Feedback

Hope this would be helpful. Please feel free to reach out to me with your feedback and questions.

August 10, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

August 10, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

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

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.

Microsoft Announcements and Updates

Community Blog Posts

Videos

Podcasts

How to get started with iPaaS design & development in Azure?

Feedback

Hope this would be helpful. Please feel free to reach out to me with your feedback and questions.

August 10, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

August 10, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

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

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.

Microsoft Announcements and Updates

Community Blog Posts

Videos

Podcasts

How to get started with iPaaS design & development in Azure?

Feedback

Hope this would be helpful. Please feel free to reach out to me with your feedback and questions.

Different SFTP Authentication Support in BizTalk360

Different SFTP Authentication Support in BizTalk360

Introduction

What are all the various authenticating methods in which a user can use to connect to an SFTP server (depending on how the server is set up), How shall I keep track on my SFTP Port’s Location for data pile up, What are all the possible way to monitor the File count and Directory size in SFTP port, How does BizTalk360 gives an extensive SFTP support, wanted to know the answer for these queries and more, let us get into the blog.

In the upcoming version of BizTalk360, BizTak360 extends its support in SFTP by supporting the Multi-Factor Authentication and /n software SFTP Keyboard Interactive Authentication. We BizTalk360 always gives importance to the customer’s feedback/request and keeps business improvement as its vital important thus provide the customer outbox support which will keep the users in ease and more productive.  Some of our customers are using /n software sftp adapter, we got a request on the same for supporting the /n software SFTP

How does BizTalk360 Support SFTP Location

Keeping up the connection of the SFTP server is very much important to ensure that the data are transferred between the SFTP port. There are many possible reasons that the SFTP Server connection may not be reachable like,

  • SFTP server is down
  • Time out in reaching the SFTP Server
  • Incorrect password used
  • Providing the incorrect Server Address
  • SFTP port not reachable etc.

The major role of the BizTalk Administrator is to keep monitoring the Server connection, but it is not possible to keep tracking on the SFTP port’s location and SFTP server connection, thus with BizTalk360, you can monitor the SFTP File count and Directory size of a particular SFTP port by configuring the same to a BizTalk360 Threshold or Health Alarm with the preferred condition.BizTalk360 monitoring service will check for the configured SFTP location and will send an alert whenever the condition gets violated. It is also possible to monitor on a regular cycle to cross-check whether the SFTP location threshold condition is healthy.

SFTP Client Authentication Mode Support in BizTalk360

BizTalk Server provides the BizTalk SFTP adapter to get connected to the SFTP Server, additionally supports the /n Software SFTP adapter which holds different authentication modes. Authentication modes are,

BizTalk SFTP

/n software SFTP (Supports from V10.0)          

BizTalk360 support in 9.1 and lower Version

BizTalk360 support in upcoming Version

Password

Public Key

Multi-Factor

Password

Public Key 

GSSAPIWith Mic

None

Multi-Factor

Keyboard Interactive

 

Password

Public Key

Password

Public Key

Keyboard Interactive

Multi-Factor

In the BizTalk360 configure the SFTP Location in Monitoring > Manage Mapping > -File Location > SFTP, which will help to monitor the health of the Port’s Location. On configuring the SFTP Location, BizTalk360 will automatically pick the Client Authentication Mode data which is configured in the BizTalk Admin console port.

SFTP Client Authentication Mode

Password Authentication

This is the simplest form of authentication using the traditional username/password method. A client logs in to SFTP using Username/Password. No user private/public keys are required. The “username” and “password” can be configured under: SFTP > Configure > Security > Client Authentication Mode

In BizTalk360 you can choose the Password by clicking on the Client Authentication Mode drop-down in the Security Details of BizTalk360 and will be allowing you to provide the username and password,  it is also possible to switch the authentication to “PublicKeyAuthentication”.

Password Authentication

Public key Authentication

Public key authentication is a method where the SFTP client identifies itself to the server by using public/private key pairs. Prior to connection, the user’s public key must first be uploaded and registered on the SFTP server, SFTP > Configure > Security > Client Authentication Mode > Private Key

Public key Authentication

In BizTalk360 you can choose the “Public Key Authentication” by clicking on the Client Authentication Mode drop-down which will allow you to provide the Username, Private Key, and the Private Key password. The password here does not mean the username’s password, instead, you need to provide the password of the Public Key, if you provide the password of the username then the Port location which you have configured will be orphaned which means the location is not reachable using the Provide Public key and its password.

SFTP Configuration

In case SFTP Location / Server is not reachable BizTalk360 will show the state of the port as Orphaned and will let you know the reason for the port being Orphaned by hover on the warning symbol and also in the alert notification via mail.

SFTP Authentication
Public Key

Multi-Factor Authentication

In the Multi-Factor Authentication we need to provide the Username & Password and the Public/Private key and password. Public/Private key and password configuration are like steps described in the latter section, except that it includes the private key’s password.         

 In the BizTalk360 Current version, the Multi-Factor Authentication support will not be available for you but very soon in the upcoming BizTalk360 V10 release, you will be facilitated with this feature. Thus, you could choose the Multifactor Authentication in BizTalk360 in the Client Authentication Mode list under the security details blade by allowing you to provide the Username, Password, Private Key, and the Private Key password.

Multi-Factor Authentication

Keyboard Interactive Authentication

Keyboard-interactive (KBI) authentication is the most recently introduced form of authentication for SSH. It involves the server sending prompts to the client, which the client must respond to correctly authenticated connection. Its purpose is permitting the client to support a variety of authentication mechanisms without knowing anything about them. In edtFTPj/PRO, when the server sends its list of prompts that require responses, the client searches the list of loaded SSHAuthPrompts for each prompt. It then sends the set responses back to the server. If the expected responses are supplied, the authentication succeeds.

If the prompt is for a user’s password, it will typically be something like “Password:”. The SSHPasswordPrompt class is supplied to make it easier to set up a password prompt.

In the upcoming BizTalk360 release, you could able to choose the Keyboard Interactive Authentication in the Client Authentication Mode list under the security details blade by allowing you to provide the Username and password.

Keyboard Interactive Authentication

Extensive SFTP Support in BizTalk360

SSH Tunnel

SSH is a standard for secure remote logins and file transfers over untrusted networks. It also provides a way to secure the data traffic of any given application using port forwarding, basically tunnelling any TCP/IP port over SSH. This means that the application data traffic is directed to flow inside an encrypted SSH connection so that it cannot be eavesdropped or intercepted while it is in transit. SSH tunnelling enables adding network security to legacy applications that do not natively support encryption.

Extensive SFTP support

Considering the importance of SSH Tunnel and its business impact, BizTalk360 supports the proxy SSH tunnel to connect the SFTP or another server by not keeping the username and password as mandatory.

SSH Tunnel

To get connected to the SFTP server with a normal proxy connection in the current BizTalk360 provide the Address, Port, Type, Username, and Password, it will reach the SFTP location using the credentials and check for the connection and its location details of the SFTP port.

Remote path location pattern support

In the BizTalk server while configuring the remote location, the user may provide different types of patterns. As we BizTalk360 comforts the BizTalk user at every point to the core level.

Say for instance: Remote path can be configuring with the following combination, C:/Users/BT360Admin/nS_SFTP_in1

C:/Users/BT360Admin/nS_SFTP_in1/*.*

/C:/Users/BT360Admin/nS_SFTP_in1

/C:/Users/BT360Admin/nS_SFTP_in1/*.*

/C:/Users/BT360Admin/nS_SFTP_in1/

C:/Users/BT360Admin/nS_SFTP_in1

BizTalk360 is capable enough to monitor the File count and Directory size of the Receive Location or Sendport with all those remote path configurations

Remote path location pattern support

Extensive File Mask Support

In the BizTalk Server the file mask is a string that specifies the type of file that the File receive handler will pick up from the receive location. The file name is a string that specifies the name of the file where the File send handler will write the message. The key point to remember in configuring the file mask is that the file mask and file name are not case-sensitive.

To keep up its immense support, we are supporting all the combinations of file masks. BizTalk360 will fetch the File count base on the file mask configured, in spite of its case sensitiveness.

Here are the few samples for File mask,

 CHPAPO*.txt       *.txt          * . *               *outbound322*       PPI*         Tes*.*

  .TXt                      *.tXT          * . XMl          Orderdata.Xml        .XML       TES*.*

Macros support

You can use a predefined set of macros to dynamically create the files in which the File send handler writes messages. Before creating a file on the file system, the File send handler replaces all the macros in the file name with their individual values. You can use several different macros in one file name.

You can use the file name macros while configuring the File send handler in BizTalk Explorer, or by using the BizTalk Explorer object model.

The File send handler does not replace the macros with a value if any of the following are true:

  • The corresponding system property is not set.
  • The macro is misspelled.
  • The value for the macro contains symbols that are not valid in the file name.

In BizTalk360, you can able to monitor the file count and Directory size of the Send ports with macros by keeping the BizTalk File mask configuration configurable.

Conclusion

Hopefully, this blog helps you in understanding the basics of SFTP client authentication, as well as the types of SFTP Client Authentication Mode, its importance, and BizTalk360’s extensive support in handling and monitoring variant authentication Mode. We are happy to announce that the /n software SFTP and Macros support will be available for your service soon in the forthcoming BizTalk360 Version 10.0 release. To explore further give a try on BizTalk360 will take only a minute to place over BizTalk environment

The post Different SFTP Authentication Support in BizTalk360 appeared first on BizTalk360.