Wednesday, May 27, 2026

ECM Features Comparison: SharePoint Online vs OpenText

 ECM Features Comparison: SharePoint Online vs OpenText


ECM Features Comparison: SharePoint Online vs OpenText

ECM Capability

SharePoint Online

OpenText Content Suite

Document Management

Native document libraries

Advanced document repository

Version Control

Major/Minor versioning

Advanced versioning and revision management

Check-In / Check-Out

Available

Available

Metadata Management

Managed Metadata Service, Content Types

Enterprise metadata classification

Taxonomy Management

Term Store

Business taxonomy and classification engine

Records Management

Microsoft Purview Records Management

Industry-leading Records Management

Document Retention

Retention Labels and Policies

Retention Schedules and Policies

Legal Hold

Microsoft Purview eDiscovery

Legal Hold Management

Content Lifecycle Management

Automated lifecycle policies

Advanced lifecycle management

Document Security

Entra ID, Sensitivity Labels

Granular ACL-based security

Role-Based Access Control (RBAC)

SharePoint Groups & Entra Roles

Advanced Security Permissions

Workflow Automation

Power Automate

OpenText AppWorks / BPM

Business Process Management (BPM)

⚠️ Basic to Moderate

Advanced BPM Engine

Document Approval Workflows

Power Automate

Native Workflow Engine

Collaboration Features

Teams Integration

⚠️ Limited compared to SPO

Co-authoring

Real-time co-authoring

⚠️ Limited depending on integration

Microsoft Office Integration

Native Integration

Integration available

Outlook Integration

Native

Available

Search Functionality

Microsoft Search

Enterprise Search

AI-Based Search

Microsoft Copilot

OpenText Aviator AI

OCR (Optical Character Recognition)

⚠️ Via Syntex/3rd Party

Native OCR Support

Document Capture

⚠️ Limited

Advanced Capture Center

Scanning Integration

⚠️ Third-party

Native Capture Solutions

Content Classification

Syntex AI

Advanced Classification Engine

Enterprise Content Archiving

⚠️ Basic

Strong Archiving Capabilities

Email Archiving

⚠️ Purview-based

Native Email Archiving

Knowledge Management

Viva Topics, SharePoint

Knowledge Center

Compliance Management

Purview Compliance Center

Extensive Compliance Framework

Audit Logs

Unified Audit Logs

Detailed Audit Trails

eDiscovery

Microsoft Purview eDiscovery

OpenText eDiscovery

Electronic Signatures

⚠️ Adobe Sign/DocuSign Integration

Native + Third-party Integration

Case Management

⚠️ Limited

Strong Case Management

Contract Management

⚠️ Third-party solutions

Native Contract Management

Regulatory Submission Support

⚠️ Custom Solution

Strong Life Sciences Support

GxP Compliance

⚠️ Requires configuration

Designed for regulated industries

21 CFR Part 11 Compliance

⚠️ Achievable through controls

Native compliance support

SAP Integration

APIs/Connectors

Deep SAP Integration

ERP Integration

Via APIs/Power Platform

Native Connectors

Cloud Deployment

SaaS Only

Cloud, Hybrid, On-Prem

Hybrid Deployment

Not supported

Supported

On-Premises Deployment

Not available

Available

Disaster Recovery

Microsoft Managed

Configurable

Multi-Region Support

Global Microsoft Datacenters

Available

Mobile Access

SharePoint Mobile App

OpenText Mobile

Low-Code Development

Power Apps

⚠️ Limited

API Support

Microsoft Graph API

REST/SOA APIs

Integration Ecosystem

Extensive Microsoft Ecosystem

Enterprise Application Ecosystem

 

Strength Areas

Area

Winner

Collaboration

SharePoint Online

Team Sites & Intranet

SharePoint Online

Microsoft 365 Integration

SharePoint Online

Co-authoring

SharePoint Online

Power Platform Integration

SharePoint Online

Records Management

OpenText

Regulatory Compliance

OpenText

GxP / FDA Compliance

OpenText

Archiving

OpenText

Case Management

OpenText

BPM / Workflow

OpenText

Document Capture & OCR

OpenText

SAP Integration

OpenText

Enterprise Content Governance

OpenText

 

Real-World Usage in Pharma

SharePoint Online

Used for:

Team Collaboration
Intranet Portals
Knowledge Management
Project Sites
Document Sharing
Microsoft Teams Integration
Employee Self-Service Portals

OpenText

Used for:

Regulatory Document Management
Clinical Trial Documentation
Quality Management Systems (QMS)
GxP Controlled Documents
Records Management
Contract Lifecycle Management
Enterprise Archiving

 

Typical Pharma Architecture

Users
   |
Microsoft Teams
   |
SharePoint Online
   |
Power Platform
   |
OpenText Content Suite
   |
SAP / Veeva Vault / Clinical Systems
   |
Archive & Records Repository

Common Pattern in Pharma Companies

SharePoint Online → Collaboration, Intranet, Team Sites, Knowledge Sharing.
OpenText → Controlled Content, Regulatory Documents, Quality Records, Compliance Archives.
Veeva Vault → Clinical, Regulatory, Quality, and RIM content specific to Life Sciences.

This is the architecture commonly seen in organizations such as Novartis, Pfizer, Roche, Eli Lilly and Company, and Parexel.

 



Tuesday, May 26, 2026

Basics of Microsoft Entra ID

 

Microsoft Entra ID


Microsoft Entra ID is Microsoft's cloud-based Identity and Access Management (IAM)

platform that provides authentication, authorization, access control, and security for

Microsoft 365, Azure, and thousands of third-party applications.

Think of Entra ID as the security gatekeeper of Microsoft 365.

 

What is Identity and Access Management (IAM)?

IAM answers two questions:

1. Who are you?

(Authentication)

Example:

Username: ramesh@company.com
Password: ********

Entra ID verifies the identity.

 

2. What can you access?

(Authorization)

Example:

Ramesh
── SharePoint Access
── Teams Access
── Outlook Access
└── HR Portal Access

Entra ID determines permissions.

 

Why Microsoft Entra ID is Important

Without Entra ID:

SharePoint → Separate Login
Teams → Separate Login
Exchange → Separate Login
Power BI → Separate Login

With Entra ID:

Single Sign-On (SSO)

One Login
   
SharePoint
Teams
Exchange
OneDrive
Power BI

 

Core Components of Entra ID

1. Users

Represents employees, contractors, vendors, and service accounts.

Example

ramesh@company.com
john@company.com
vendor@partner.com

PowerShell

Get-MgUser

 

2. Groups

Used to manage permissions efficiently.

Example

HR Team
Finance Team
SharePoint Admins
Project Team

Instead of assigning permissions to 100 users, assign one group.

PowerShell

Get-MgGroup

 

3. Applications

Applications registered in Entra ID.

Examples

  • Microsoft Teams
  • SharePoint Online
  • Salesforce
  • ServiceNow

 

4. Devices

Managed corporate devices.

Examples

Windows Laptop
Android Phone
iPhone
MacBook

Benefits

  • Device Compliance
  • Conditional Access
  • Security Enforcement

 

Authentication Methods

 

Password Authentication

Traditional login.

Username + Password

Challenge

Weak passwords.

 

Multi-Factor Authentication (MFA)

Requires additional verification.

Example

Password
    +
Mobile Approval

Benefits

Even if password is stolen, access is blocked.

 

Passwordless Authentication

Methods:

  • Microsoft Authenticator
  • FIDO2 Security Keys
  • Windows Hello

Example

Fingerprint
Face Recognition
PIN

 

Single Sign-On (SSO)

What is SSO?

One login provides access to multiple applications.

Example

Login Once
     
SharePoint
Teams
Exchange
OneDrive
Power BI

Benefits

Better User Experience

Fewer Password Resets

Improved Productivity

 

Conditional Access

One of the most important Entra ID security features.

Purpose

Control access based on conditions.

Example Policy

If User Outside India
         
Require MFA

Example Policy

If Device Non-Compliant
         
Block Access

Example Policy

If High Risk Login
         
Block Login

 

Real-Time Conditional Access Scenarios

Scenario 1

Employee login from office.

Location: Hyderabad
Device: Managed Laptop

Result:
Allow Access

 

Scenario 2

Employee login from unknown country.

Location: Russia

Result:
Require MFA

 

Scenario 3

Unknown device login.

Personal Device

Result:
Limited Access

 

Role-Based Access Control (RBAC)

Assign permissions based on roles.

 

Common Roles

Global Administrator

Highest privilege.

Can manage:

  • Users
  • Groups
  • Licenses
  • Security

 

SharePoint Administrator

Manages:

  • Sites
  • Storage
  • Sharing

 

Exchange Administrator

Manages:

  • Mailboxes
  • Mail Flow
  • Email Security

 

Teams Administrator

Manages:

  • Teams
  • Channels
  • Policies

 

User Administrator

Manages:

  • User Accounts
  • Password Resets

 

Identity Protection

Protects against compromised identities.

 

Risk Detection

Detects:

Impossible Travel
Anonymous IP
Malicious IP
Leaked Credentials

Example

10:00 AM India Login
10:15 AM USA Login

Impossible travel detected.

 

Self-Service Password Reset (SSPR)

Users reset passwords without IT support.

Process

Forgot Password
     
Verify Mobile
     
Reset Password

Benefits

Reduced helpdesk tickets.

 

External Users (B2B Collaboration)

Invite external users.

Example

vendor@gmail.com
consultant@partner.com

Usage

  • SharePoint Collaboration
  • Teams Collaboration

 

B2C (Customer Identity)

Customer-facing applications.

Example

E-commerce website login.

Google Login
Facebook Login
Microsoft Login

 

Dynamic Groups

Automatic group membership.

Example Rule

Department = HR

All HR users automatically join HR group.

 

Privileged Identity Management (PIM)

Provides Just-In-Time (JIT) administrative access.

Traditional

Global Admin = Permanent

PIM

User Requests Access
       
Approval
       
Temporary Access

Benefits

Reduces security risk.

 

Microsoft 365 Integration

Entra ID is the backbone of:

  • SharePoint Online
  • Exchange Online
  • Microsoft Teams
  • OneDrive for Business
  • Microsoft Intune
  • Power BI

 

Real-Time SharePoint Online Scenario

Requirement

Only QA team should access GxP documents.

Solution

Create Group:

QA_GxP_Users

Assign group permission:

QA_GxP_Users
      
SharePoint Library

When employee joins QA:

Add User to Group

Access granted automatically.

 

Daily Administrative Tasks

User Management

Get-MgUser
New-MgUser
Update-MgUser
Remove-MgUser

 

Group Management

Get-MgGroup
New-MgGroup
Remove-MgGroup

 

License Management

Get-MgSubscribedSku
Set-MgUserLicense

 

Security Monitoring

Get-MgAuditLogSignIn

 

Conditional Access

Get-MgIdentityConditionalAccessPolicy

 

Advantages of Entra ID

Security

MFA

Conditional Access

Identity Protection

 

Productivity

Single Sign-On

Self-Service Password Reset

 

Governance

RBAC

PIM

Audit Logs

 

Integration

Microsoft 365

Azure

Salesforce

ServiceNow

Thousands of SaaS applications.

 

Limitations and Challenges

Licensing Complexity

Advanced features require:

  • Entra ID P1
  • Entra ID P2

 

Conditional Access Complexity

Poorly designed policies can lock out users.

 

Guest User Governance

External users require regular review.

 

Large Enterprise Challenges

Managing:

100,000+
Users
Thousands of Groups
Thousands of Applications

requires strong governance.

 


Monday, May 25, 2026

Microsoft 365 Workloads – Daily Used PowerShell Commands

 Microsoft 365 Workloads – Daily Used PowerShell Commands

As an M365 Administrator, SharePoint Administrator, or Collaboration Engineer, these are the most frequently used PowerShell commands across major Microsoft 365 workloads.

 

1. Microsoft Entra ID (Azure AD)

Module:

Microsoft.Graph

Connect

Connect-MgGraph -Scopes "User.Read.All","Group.Read.All"

Get Users

Get-MgUser

Get Specific User

Get-MgUser -UserId user@contoso.com

Create User

New-MgUser

Disable User

Update-MgUser -UserId user@contoso.com -AccountEnabled:$false

Get Groups

Get-MgGroup

Add User to Group

New-MgGroupMember

Remove User from Group

Remove-MgGroupMemberByRef

Get Licenses

Get-MgSubscribedSku

Assign License

Set-MgUserLicense

 

2. SharePoint Online

SharePoint Online

Module:

Microsoft.Online.SharePoint.PowerShell
PnP.PowerShell

Connect

Connect-SPOService -Url https://tenant-admin.sharepoint.com

Get Tenant Settings

Get-SPOTenant

Get All Sites

Get-SPOSite -Limit All

Create Site

New-SPOSite

Remove Site

Remove-SPOSite

Restore Site

Restore-SPODeletedSite

Get Site Admins

Get-SPOUser

Set Site Collection Admin

Set-SPOUser

Lock Site

Set-SPOSite -LockState ReadOnly

External Sharing

Set-SPOSite -SharingCapability Disabled

 

PnP PowerShell

Connect

Connect-PnPOnline -Url https://tenant.sharepoint.com -Interactive

Get Libraries

Get-PnPList

Create Library

New-PnPList

Upload File

Add-PnPFile

Download File

Get-PnPFile

Create Column

Add-PnPField

Create Content Type

Add-PnPContentType

 

3. Exchange Online

Exchange Online

Module:

ExchangeOnlineManagement

Connect

Connect-ExchangeOnline

Get Mailboxes

Get-Mailbox

Get Mailbox Statistics

Get-MailboxStatistics

Create Shared Mailbox

New-Mailbox -Shared

Get Shared Mailboxes

Get-Mailbox -RecipientTypeDetails SharedMailbox

Add Mailbox Permission

Add-MailboxPermission

Remove Mailbox Permission

Remove-MailboxPermission

Create Distribution Group

New-DistributionGroup

Get Distribution Groups

Get-DistributionGroup

Add Group Member

Add-DistributionGroupMember

Mail Trace

Get-MessageTrace

Mail Flow Rules

Get-TransportRule

 

4. Microsoft Teams

Microsoft Teams

Module:

MicrosoftTeams

Connect

Connect-MicrosoftTeams

Get Teams

Get-Team

Create Team

New-Team

Add User

Add-TeamUser

Remove User

Remove-TeamUser

Get Team Members

Get-TeamUser

Get Channels

Get-TeamChannel

Create Channel

New-TeamChannel

Get Teams Policies

Get-CsTeamsMeetingPolicy

 

5. OneDrive for Business

OneDrive for Business

Uses SPO commands because OneDrive is built on SharePoint.

Get OneDrive Sites

Get-SPOSite -IncludePersonalSite $true

Get Specific OneDrive

Get-SPOSite -Identity https://tenant-my.sharepoint.com/personal/user

Set Storage Quota

Set-SPOSite

Restore OneDrive

Restore-SPODeletedSite

 

6. Microsoft Purview (Compliance Center)

Microsoft Purview

Module:

ExchangeOnlineManagement
IPPSSession

Connect

Connect-IPPSSession

Get Retention Policies

Get-RetentionCompliancePolicy

Get Retention Labels

Get-ComplianceTag

Get DLP Policies

Get-DlpCompliancePolicy

Get DLP Rules

Get-DlpComplianceRule

Content Search

Get-ComplianceSearch

Start Search

Start-ComplianceSearch

Audit Log Search

Search-UnifiedAuditLog

 

7. Microsoft Intune

Microsoft Intune

Module:

Microsoft.Graph

Connect

Connect-MgGraph

Managed Devices

Get-MgDeviceManagementManagedDevice

Compliance Policies

Get-MgDeviceManagementDeviceCompliancePolicy

Configuration Profiles

Get-MgDeviceManagementDeviceConfiguration

Remote Wipe

Invoke-MgDeviceManagementManagedDeviceWipe

 

8. Power Platform

Power Apps

Module:

Microsoft.PowerApps.Administration.PowerShell

Connect

Add-PowerAppsAccount

Get Apps

Get-AdminPowerApp

Get Environments

Get-AdminPowerAppEnvironment

Get Connectors

Get-AdminPowerAppConnector

 

9. Power Automate

Get Flows

Get-AdminFlow

Get Flow Details

Get-Flow

Disable Flow

Disable-AdminFlow

 

10. Microsoft 365 Groups

Get Groups

Get-UnifiedGroup

Create Group

New-UnifiedGroup

Add Member

Add-UnifiedGroupLinks

Remove Member

Remove-UnifiedGroupLinks

 

11. Licensing

View Licenses

Get-MgSubscribedSku

View User Licenses

Get-MgUserLicenseDetail

Assign License

Set-MgUserLicense

Remove License

Set-MgUserLicense

 

12. Security & Defender

Microsoft Defender for Office 365

Connect

Connect-ExchangeOnline

Safe Attachments

Get-SafeAttachmentPolicy

Safe Links

Get-SafeLinksPolicy

Anti-Spam Policies

Get-HostedContentFilterPolicy

Quarantine Messages

Get-QuarantineMessage

 

Daily Commands Used Most by M365 Administrators

Workload

Daily Commands

Entra ID

Get-MgUser, Get-MgGroup, Set-MgUserLicense

SharePoint Online

Get-SPOSite, Get-SPOUser, Set-SPOSite

Exchange Online

Get-Mailbox, Get-MessageTrace, Add-MailboxPermission

Teams

Get-Team, Add-TeamUser, Get-TeamChannel

OneDrive

Get-SPOSite -IncludePersonalSite

Purview

Search-UnifiedAuditLog, Get-DlpCompliancePolicy

Intune

Get-MgDeviceManagementManagedDevice

Power Apps

Get-AdminPowerApp

Power Automate

Get-AdminFlow

Licensing

Get-MgSubscribedSku

Security

Get-QuarantineMessage