September 21, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

September 21, 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.

Microsoft Integration and Azure Stencils Pack for Visio: New major version available (v7.0.0)

Microsoft Integration and Azure Stencils Pack for Visio: New major version available (v7.0.0)

Well, the thing is, you cannot say to me, “…these stencils look fantastic, but are currently unusable or worthless because…” my brain enters in a crazy mode, and I can only free myself when all the work is finished successfully and that these resources are handy :).

Jokes apart, I use these resources for a long time, I create these for myself, but I knew that they were not perfects. The major problem was that fixing that amount of icons was a time-consuming task. However, with the number of people using these stencils increasing and reporting those problems, I decided to resolve them once and for all.

Today I can announce that I close all the open issues reported on the git repository of this package.

What’s new in this version?

These are the list of changes and additions present in this major release:

  • Restructure of Visio Stencils files (.vssx) names: the package is now composed of 26 Visio Stencils files.
    • Some of them were renamed: PowerApps and Flow is now Power Platform; Files is now Files and Message Types Stencils, …
    • Some were merged: Power BI was merged in the new Power Platform Visio Stencil file; Azure Others was merged in the Azure Additional or Support Stencils, Office365 is now Office, Office 365 and Dynamics 365…
    • New Visio Stencils files: MIS Black and Cyan and MIS Azure Black and Gray;
  • New shapes: New shapes were added on the majority of the Visio Stencils files (.vssx). Probably the one that was most affected was Azure Stencils and Office, Office 365 and Dynamics 365;
  • Text annotations and connector points: The issues regarding text annotations (legend appear in the center of the icon instead of bellow) and connector points (lack of proper connect points) are now solved in all the Visio Stencils files (.vssx). This was a massive work!
  • Order of the icons: all the icons appear in alphabetic order inside the Visio Stencil file, with the exception in some cases of the first ones that in some case contains the main shape of the context, like in Microsoft Integration Stencils, the first icon is BizTalk Server Logo.
  • Automation: add 3 PowerShell script to this package for you 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.
    • Automatically install (configure) all the Visio files (*.vssx), so that next time you open Visio, they will be there available;
    • And also the possibility to download the most recent version from GitHub and install it locally;
  • Standardize shape sizes: standardize the shapes sizes in all to be more or less all of the same sizes Visio Stencils files.
  • Fixed some minor stencils layouts;
  • SVG files: new SVG files added.

These changes were a massive job that stole all my free time apart from my work and family time, from the past three weeks! So I hope you appreciate it!

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 Black and Gray
  • MIS Azure Old Versions
  • MIS Azure Stencils
  • MIS Black and Cyan
  • MIS Buildings Stencils
  • MIS Databases and Analytics Stencils
  • MIS Deprecated Stencils
  • MIS Developer Stencils
  • MIS Devices Stencils
  • MIS Files and Message Types Stencils
  • MIS Generic Stencils
  • MIS Infrastructure and Networking Stencils
  • MIS Integration Fun
  • MIS Integration Patterns Stencils
  • MIS IoT Stencils
  • MIS Office, Office 365 and Dynamics 365
  • MIS Power BI Stencils
  • MIS Power Platform Stencils
  • MIS SAP Stencils
  • MIS Security and Governance
  • MIS Servers (Hexagonal) Stencils
  • MIS Users and Roles Stencils
  • Organisational 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 major version available (v7.0.0) appeared first on SANDRO PEREIRA BIZTALK BLOG.

September 7, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

September 7, 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 download a GitHub Repository using PowerShell

How to download a GitHub Repository using PowerShell

I am automating specific tasks related to my Microsoft Integration, Azure, Office 365, and much more Stencils Pack for Visio project: I started in my last blog post with two simple tasks:

  • Standardize all SVG filenames;
  • List all the detected duplicate files;

And now, I am trying to add more functionalities like: 

  • Automatically install (configure) all the Visio files (*.vssx), so that next time you open Visio, they will be there available;
  • And also the possibility to download the most recent version from GitHub and install it locally;

Well, the first task is quite simple, you just need to locate all the *.vssx files and copy to the folder “C:Usersyou_userDocumentsMy Shapes” (that is the default folder for the Visio custom shapes)

#########################################################
#                                                       #
# Install Microsoft Integration & Azure Stencils Pack   #
# Author: Sandro Pereira                                #
#                                                       #
#########################################################

[String]$location = Split-Path -Parent $PSCommandPath
[String]$destination = [environment]::getfolderpath('mydocuments') + "My Shapes"

$files = Get-ChildItem $location -recurse -force -Filter *.vssx
foreach($file in $files)
{
    if($file.PSPath.Contains("Previous Versions") -eq $false)
    {
        Copy-Item -Path $file.PSPath -Destination $destination -force
    }
}

You can download this script here: Install Microsoft Integration & Azure Stencils Pack.

The second part is a little trick. I found many resources while searching on the internet, but none was what I intended to do. Some were quite nice, but we could easily reach the API Rate limit that is 60 requests per hour for unauthenticated requests or 5000 requests per hour if you use Basic Authentication or OAuth. Or it simply didn’t unzip properly.

I want to archive a simple way to download a full GitHub repository and unzip it locally. Simple as going in the browser and select Code > Download ZIP, that’s it!

And to archive that you can use two ways:

  • using the following URL structure:
    • https://github.com/[owner]/[repo-name]/archive/[Branch].zip
    • This is exactly what Code > Download ZIP does.
  • or using the GitHub API using the following URL structure:
    • https://api.github.com/repos/[owner]/[repo-name]/zipball/Branch]

Since I was doing all this work, I also decide to make it available a generic PowerShell function that will allow you to download any GitHub Repository.

######################################################################
#                                                                    #
# Download and Unzip GitHub Repository                               #
# Author: Sandro Pereira                                             #
#                                                                    #
######################################################################

function DownloadGitHubRepository 
{ 
    param( 
       [Parameter(Mandatory=$True)] 
       [string] $Name, 
        
       [Parameter(Mandatory=$True)] 
       [string] $Author, 
        
       [Parameter(Mandatory=$False)] 
       [string] $Branch = "master", 
        
       [Parameter(Mandatory=$False)] 
       [string] $Location = "c:temp" 
    ) 
    
    # Force to create a zip file 
    $ZipFile = "$location$Name.zip" 
    New-Item $ZipFile -ItemType File -Force

    #$RepositoryZipUrl = "https://github.com/sandroasp/Microsoft-Integration-and-Azure-Stencils-Pack-for-Visio/archive/master.zip"
    $RepositoryZipUrl = "https://api.github.com/repos/$Author/$Name/zipball/$Branch"  
    # download the zip 
    Write-Host 'Starting downloading the GitHub Repository'
    Invoke-RestMethod -Uri $RepositoryZipUrl -OutFile $ZipFile
    Write-Host 'Download finished'

    #Extract Zip File
    Write-Host 'Starting unzipping the GitHub Repository locally'
    Expand-Archive -Path $ZipFile -DestinationPath $location -Force
    Write-Host 'Unzip finished'
    
    # remove the zip file
    Remove-Item -Path $ZipFile -Force 
}

Download

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

Standardize SVG Filenames with PowerShellHow to Download a GitHub Repository with PowerShell
GitHub

The post How to download a GitHub Repository using PowerShell appeared first on SANDRO PEREIRA BIZTALK BLOG.

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.