Sunday, 16 March 2025

SAP LeanIX Intro

  • LeanIx is an SAP SaaS product that facilitates Enterprise Architecture (EA) in a business using dashboards and diagrams to aid decision-making.   
  • To create the roadmap, align business goals with IT strategy by generating 'As is' and 'To be' architectures.
  • Improve integration, reduce complexity and duplicate systems and make better decisions.

Note: Using LeanIX is an all in or don't bother tool.  LeanIx helps you get a complete view of your applications, business processes, and interactions with IT assets.

3 Products make up LeanIX:

  1. Application Portfolio Management: The base product for recording the application landscape allows for inventory dependencies and identifying redundancies to optimise the application landscape.
  2. Architecture and Roadmap: Using the Application Portfolio, visualise the 'As Is' and 'To Be' architectures and visualise impacts of change.
  3. Tech Risk and Compliance: We check technology standards, and we can fund projects to help with data residency rule breaches.

12 Fact sheets, like the application fact sheet template, are essential. The meta model is the plan that shows how information in the fact sheets is interconnected.  

The "LeanIX Meta Model" at a high level shows the 4 EA architectural views:  

  1. Data Architecture
  2. Application Architecture
  3. Business Architecture
  4. Technical Architecture 

On top of the four architectural pillars sits Strategy & Transformation, covering:

  • GAP & Roadmap, 
  • Principles, 
  • Requirements and Assumptions.

What I Like:

  1. Inventory of Products and dependencies and link to documentation
  2. Nice predefined reports and ability to collaborate with stakeholders
  3. Visualise dependencies, excellent reporting capabilities

Note: 

Note: LeanIX is based on The Open Group Architecture Framework, i.e. TOGAF.  TOGAF's Architecture Development Method (ADM) 



Tuesday, 11 March 2025

SQL Server on Microsoft Fabric

 Release to Public Preview in Nov 2024 and Ignite.


Monday, 3 February 2025

ProjectWise from Bentley - extend with Powershell

ProjectWise from Bentley - Document Management Software

ProjectWise is a Document Management Solution (DMS) from Bentley.  Its key use case is supporting BIM.

Architecture:  It appears to have a pretty old architecture with the ability to "webify" the DMS.  

Integration: There are APIs and Power Connectors, but they are extremely limited and not developer-friendly. You can also extend the capability using PowerShell. Be warned: Bentley does not support this, but the ProjectWise community does help to solve the issue.

There are add-ins for office software (word, excel, pptx) and some CAD products to make the BIM process easier.

This post outlines how I have extended ProjectWise to build out a pre-populated folder structure using PowerShell.  I then wrap the PS code in an HTTP Azure HTTP-triggered function to call.

Connecting to ProjectWise using PowerShell Example 1:

PS> Import-Module pwps_dab
PS> New-PWLogin -BentleyIMS

Federated login for PS

Note: You need to already have Bentley's federation auth set up on the local machine running the "CONNECTION Client."

Machine running PS must use the CONNECTION Client from Bentley and the user will be prompted to login.

Connecting to ProjectWise using PowerShell Example 2:
Login using Federated identity without a popup to select the datasource

PS> Import-Module pwps_dab
PS> New-PWLogin -Datasource 'org-pw.bentley.com:Org Delivery' -BentleyIMS

Connecting to ProjectWise using PowerShell Example 3:
Login with a local account - No Federated account needed.

PS> $Password = ConvertTo-SecureString "passwrdxxx" -AsPlainText -Force
PS> $Cred = New-Object System.Management.Automation.PSCredential ("my_user_logical", $Password)
PS> New-PWLogin -Datasource 'org-pw.bentley.com:Org Delivery' -UserName $Cred.UserName -Password $Cred.Password

Below are two error codes that tell you if your datasource or login credentials are incorrect.

Example 3.  Error code: 32768 - Datasource not found.


Example 3, this item has the wrong credentials Error code: 58064.



To Review: 
https://www.linkedin.com/pulse/understanding-bim-workflow-importance-microstation-yassir-el-yaqouby-ltinf/
https://www.linkedin.com/in/uday-singh-5b18a2155/recent-activity/all/
https://www.linkedin.com/pulse/bim-summary-day-1-introduction-what-building-modelling-uday-singh-d48xc/?trackingId=jVx9vtIRPnylCdD6UVE0ag%3D%3D

AutoDesk Revit

Revit 
https://www.linkedin.com/learning/bim-manager-managing-bim-360
https://www.linkedin.com/learning/search?keywords=Autodesk%20BIM%20360
AutoDesk Construction Cloud

Procore - Project/Construction Management 

https://www.linkedin.com/learning/search?keywords=BIM




Wednesday, 29 January 2025

AI Copilot comparrison

 Lunchtime play ...  Claude.io was the best I used... Deepseek didn't work....

AI Engine Comparison Test:

I recently asked a few AI engines a complex tax query:

Perprexity Pro (paid): While I love the app, the answer was not great 6/10

ChatGPT (free): Excellent factually correct, not to clear in one area 8/10 

DeepSeek: I registered and tried the search, but got the result "The server is busy. Please try again later."  I tried a few times, it is working for common queries but i assume as this logic wouldn't be cached, it can't even have an attempt with the free version 2/10.

Bing/M365 Copilot: Got a fairly similar result to ChatGPT missing an option and not as well laid out 7/10 

Claud.io: Clean result that is factually correct and offered possible items that would affect the calculation 10/10

Tuesday, 21 January 2025

PnP Search - Notes

Overview:  I have had a crazy amount of time figuring out how to use the PnP Search Web parts again.  I do this every few years, as I forget.  This post outlines how to set up filters for the PnP search using my own columns.

Four items to get Filtering working

Tip: Filterable Managed Properties must have a search property of "refinable".  You can't create these in SPO so use the Refinable Managed Properties setup for this purpose.

Monday, 20 January 2025

Microsoft Purview Summary

Purview covers:

  • Information Protection - Discover, Classify & Protect data such as documents and emails. Tagging and AIP labels can be applied manually or automatically.  Lots of built-in pattern classifiers such as credit cards and PII data are Sensitive Information Type (SIT), which uses expressions like RegEx to identify types of information example [A-Z]{2}[0-9]{6}[A-D]{1} for a UK National Insurance Number.  The dictionary allows one to add words to customise discovery and automatic tagging and labelling for each organisation and industry.  Can also build custom SITs based on specific patterns.  Activity Explorer and Content Explorer help understand the data information architecture and usage.  
  • Data Loss Prevention (DLP) - Block unauthorised actions
  • Inside Risk Prevention (IRP) - Identify risky behaviour inside the org
  • Adaptive protection - adjusts policies like DLP policies based on the risk identified using ML/AI.  Applies stricter measures as risks are identified.
Microsoft End-Point/device Protection: Microsoft Purview allows a company to create end-device DLP policies, push them to all client devices, and protect data within the company.

Notes on Data Protection:

  • Uses SharePoint Information Rights Management for SharePoint.
  • Used to ensure your data meets criteria to ensure standards compliance such as HIPPA, BIM, GxP.
  • Retention labels are used to track and manage sensitive data.

Wednesday, 1 January 2025

Prompt Engineering with Microsoft Copilot

Prompting Microsoft Copilot: Prompting is asking the copilot to give you information.

Four parts to cover in your prompt> 1. goal 2. context 3. source 4. expectation

1. Goal - what do I want, e.g., tell copilot what we want

I want tactics for pricing my SaaS products

2. Context - Why do I need it

e.g., this is a new product in the B2C space

3. Sources - optional - ask from specific resources

e.g. provide my company stats and ask to compare to my market (from the LLM)

4. Expectations - Table of info, summary, or even an image(maybe not)

M365 Copilot app.

Apps that M365 Copilot embedded with if you have the M365 licence include: 
1. Word, 2. Excel, 3. PowerPoint, 4. Outlook, and 5. Teams

1. Word

Word Copilot is part of the M365 copilot branding.  Generates scaffolding/first draft.

2. Excel

Use in Excel with your own data - allows easy query using English/natural language.

3. PowerPoint

Draft a presentation using org themes based on prompts. You can also use Copilot to add images you create using Copilot (DALL-e).