SAP ASE 16.0 on Azure NetApp Files for SAP Workloads on SLES15

by Contributed | Feb 4, 2023 | Technology

This article is contributed. See the original author and article here.

SAP ASE 16.0 on Azure NetApp Files for SAP Workloads on SLES15

Introduction

This document will show how you can install SAP NetWeaver 7.5 based on ASE 16.0 and SLES15 SP2 in Azure using Azure NetApp Files (ANF) as storage platform for data and log areas.

SAP Installation Documentation:

Installation Guide for Linux (sap.com)

SAP ASE Home – SAP ASE – Community Wiki

1554717 – SYB: Planning information for SAP on ASE – SAP ONE Support Launchpad

1928533 – SAP Applications on Microsoft Azure: Supported Products and Azure VM types

2015553 – SAP on Microsoft Azure: Support prerequisites

1492000 – General Support Statement for Virtual Environments – SAP ONE Support Launchpad

Note: Screenshots, input into dialogs, or operating system commands are based on the most recent versions of SWPM, SAP ASE 16.0, and SLES 15 SP2 as of January 2023. All these dialogs and/or commands can change with successor versions. 

Download the ASE Software from the SAP Service marketplace

Download the Patch SP04 (or newer) from the SAP Service Marketplace

Download the DB Client

Download the NetWeaver 7.5 Stack – Export

The Kernel

And as last the SWPM

The IGS

The IGS Helper

And last but not least …the SAP Host Agent

Create an Azure VM in your Azure Subscription

In this case we created an E16-8ds_v4 with 128GB of RAM and deployed SLES12SP5 on it.

Volume design on ANF

Create the volume structure on ANF. The size of each volume is depending on a proper capacity and performance sizing-

Mount the volumes and create the directories.

vi /etc/idmapd.conf
 # Example
 [General]
 Domain = defaultv4iddomain.com
 [Mapping]
 Nobody-User = nobody
 Nobody-Group = nobody

update the system

zypper up 

Install the RPM’s regarding the installation manual

zypper in motif libXtst-devel libXp-devel libX11-devel libSM-devel libICE-devel

zypper in glibc-32bit

zypper in sapconf

check that sapconf is running and that it is enabled.

systemctl status sapconf
sapconf.service – sapconf Loaded: loaded (/usr/lib/systemd/system/sapconf.service; enabled; vendor preset: enable> Active: active (exited) since Fri 12:54:21 UTC; 5min ago

create the group ID for your SAP systems (should be the same for all SAP systems)

groupadd sapsys -g 79

ASE Volume design for non XXL installations

As usual create one shared volume for the Application Server part , a Sybase volume for the database specific directories, data and log volume and the backup volume ideally on a different storage endpoint.

This diagram virtualizes the volume structure for ASE

Create the directory structure on the OS and on the NetApp volumes.

Create the SAP App server structure

mount -o rsize=262144,wsize=262144,sec=sys,vers=4.1  anf02:/ralfA11shared  /mnt
mkdir -p /mnt/sapmnt /mnt/usr_sap
mkdir -p /usr/sap/A11 /sapmnt
umount /mnt

Create the Sybase “shared” structure

mount -t nfs -o rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 10.0.1.5:/ralfA11sybase /mnt
mkdir -p /sybase/A11 /sybase/A11/sybsystem /sybase/A11/sybtemp /sybase/A11/sapdiag /sybase/A11/sybsecurity /sybase/A11/saptemp
mkdir -p /mnt/sybsystem /mnt/sybtemp /mnt/sapdiag /mnt/sybsecurity /mnt/saptemp
umount /mnt

Create the data structure

mount -t nfs -o rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 10.0.1.5:/ralfA11data /mnt
mkdir -p /sybase/A11/sapdata_1
mkdir -p /mnt/sapdata_1
umount /mnt

Create the log structure

mount -t nfs -o rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 10.0.1.5:/ralfA11log /mnt
mkdir /sybase/A11/saplog_1
mkdir /mnt/saplog_1
umount /mnt

Create the backup structure

mount -t nfs -o rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 10.0.1.5:/ralfA11backup /mnt
mkdir -p /sybase/A11/backup/data /sybase/A11/backup/log
mkdir -p /mnt/data /mnt/log
umount /mnt

Create the fstab

vi /etc/fstab
…
..
anf02:/ralfASEsoftware  /Software    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
#
anf02:/ralfA11shared/sapmnt  /sapmnt   nfs rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
anf02:/ralfA11shared/usr_sap  /usr/sap/A11    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
#
anf02:/ralfA11sybase/sybsystem  /sybase/A11/sybsystem    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
anf02:/ralfA11sybase/sybtemp  /sybase/A11/sybtemp    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
anf02:/ralfA11sybase/sapdiag  /sybase/A11/sapdiag    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
anf02:/ralfA11sybase/sybsecurity  /sybase/A11/sybsecurity  nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
anf02:/ralfA11sybase/saptemp  /sybase/A11/saptemp    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
anf02:/ralfA11data/sapdata_1  /sybase/A11/sapdata_1 nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
anf02:/ralfA11log/saplog_1  /sybase/A11/saplog_1    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0

Prepare the SAP installation

Download the required packages from the SAP Software Download Center. Store the files in /Software

/Software # ll
-rw-r–r– 1 root root 3692226709 Sep 21 11:03 51050829_3.ZIP
-rw-r–r– 1 root root 2373751114 Sep 21 11:00 51055060_1.ZIP
-rw-r–r– 1 root root   11462898 Sep 21 11:07 ASEBC16004P_1-20012478.SAR
-rw-r–r– 1 root root 2825640866 Sep 21 11:01 ASEBS16004P_1-10013281.SAR
-rw-r–r– 1 root root    4483040 Aug 25 09:21 SAPCAR.EXE
-rw-r–r– 1 root root    4742096 Sep 15 12:58 SAPCAR_win.EXE
-rw-r–r– 1 root root   25524734 Sep 21 11:12 SAPEXEDB_801-80002684.SAR
-rw-r–r– 1 root root  370681480 Sep 21 11:14 SAPEXE_801-80002674.SAR
-rw-r–r– 1 root root   79045422 Sep 21 13:13 SAPHOSTAGENT53_53-80004822.SAR
-rw-r–r– 1 root root  550097396 Sep 21 11:16 SWPM10SP32_6-20009701.SAR
-rw-r–r– 1 root root  104064440 Sep 21 11:57 igsexe_13-80003187.sar
-rw-r–r– 1 root root   62964377 Sep 21 11:57 igshelper_17-10010245.sar

/Software # mkdir Kernel_753

/Software # mv SAPEXE_801-80002674.SAR SAPEXEDB_801-80002684.SAR SAPHOSTAGENT53_53-80004822.SAR igsexe_13-80003187.sar igshelper_17-10010245.sar Kernel_753

Maintain the hosts file

vi /etc/hosts
127.0.0.1       localhost
10.0.0.10   ralfvm02.local ralfvm02
10.0.1.4    anf01
10.0.1.5    anf02

Extend the hostname

vi /etc/hostname
ralfvm02.local

Copy the SAPCAR to /usr/bin which allows you an easier usage.

cp SAPCAR.EXE /usr/bin/SAPCAR

chmod 775 /usr/bin/SAPCAR

set the root password on the VM (required for the SAP installation)

sudo su – 
passwd
Changing password for user root.
New password: *********
Retype new password: *******
passwd: all authentication tokens updated successfully.

df -h

df -h
Filesystem                        Size  Used Avail Use% Mounted on
/dev/sda4                          29G  2.9G   26G  10% /
/dev/sda3                        1014M  108M  907M  11% /boot
/dev/sda2                         512M  3.1M  509M   1% /boot/efi
10.0.1.5:/ralfASEsoftware         500G   17G  484G   4% /mnt
anf02:/ralfASEsoftware            500G   17G  484G   4% /Software
anf02:/ralfA11shared/sapmnt       500G     0  500G   0% /sapmnt
anf02:/ralfA11shared/usr_sap      500G     0  500G   0% /usr/sap/A11
anf02:/ralfA11sybase/sybsystem    500G     0  500G   0% /sybase/A11/sybsystem
anf02:/ralfA11sybase/sybtemp      500G     0  500G   0% /sybase/A11/sybtemp
anf02:/ralfA11sybase/sapdiag      500G     0  500G   0% /sybase/A11/sapdiag
anf02:/ralfA11sybase/sybsecurity  500G     0  500G   0% /sybase/A11/sybsecurity
anf02:/ralfA11sybase/saptemp      500G     0  500G   0% /sybase/A11/saptemp
anf02:/ralfA11data/sapdata_1     1000G     0 1000G   0% /sybase/A11/sapdata_1
anf02:/ralfA11log/saplog_1        500G     0  500G   0% /sybase/A11/saplog_1

extract the DB files

/Software # mkdir -p ASE/patch ASE/DB
/Software # mv ASEBS16004P_1-10013281.SAR ASE/patch
/Software # mv 51055060_1.ZIP ASE/DB

extract the SWPM

/Software # mkdir SWPM
/Software # mv SWPM10SP32_6-20009701.SAR SWPM
/Software # cd SWPM
/Software/SWPM # SAPCAR -xf SWPM10SP32_6-20009701.SAR

check that sapconf is running

systemctl status sapconf
sapconf.service – sapconf
Loaded: loaded (/usr/lib/systemd/system/sapconf.service; enabled; vendor preset: enabled)
Active: active (exited) since Fri 2021-05-14 11:37 UTC; 3min 1s ago
Process: 3827 ExecStart=/usr/sbin/sapconf start (code=exited, status=0/SUCCESS)
Main PID: 3827 (code=exited, status=0/SUCCESS)
    Tasks: 0 (limit: 512)
      CPU: 0
CGroup: /system.slice/sapconf.service

Disable the Firewall

systemctl stop firewalld
systemctl disable firewalld

Set the installation directory rights to 777 to prevent access issues from the installer

/ # chmod -R 777 /Software

Start the SAP Installation

Start the SWPM

ralfvm02:/Software/SWPM # ./sapinst

start your Browser and select the mentioned URL from the sapinst

https://10.0.0.10:4237/sapinst/docs/index.html

Select Advanced

Sign in to the service as root

Select NetWeaver 7.52 and ASE

Next

We select a standard system

Next

Select custom Installation

Specify the SID

Set the domain

Set the default password

Specify the (sapsys) group

specify the ASE account

specify the kernel components directory

All packages must have been identified

Specify the sapadm user details

Specify the ASE source package …

51055060_1.ZIP

Then the Export location

The right location is not easy to find….

In SAP Software Downloads, navigate to Installation & Upgrade > By Category > SAP Netweaver and Complementary Products > NW AS ABAP INNOVATION PACKAGE > NW AS ABAP 7.52 > Installation > 51051806_1 and 51051806_2

zypper in unrar

ls -l
-rw-r–r– 1 root root 4000000000 Sep 28 12:59 51051806_part1.exe
-rw-r–r– 1 root root 1064422459 Sep 28 12:56 51051806_part2.rar

/Software/exp # unrar x 51051806_part1.exe
51051806_part1.exe: Embedded RAR
51051806/DATA_UNITS/EXP1/DATA/REPOSRC-1.001  (454063104 B)…

Specify the path of the directory 51051806 in the menu

Specify the DB sizes in the next screen.

Here you e.g. can enable encryption.

Disklayout

ASE System parameter

Here the option to change the database passwords

I selected the two OS user for backup purposes in the user store.

System memory

With 8 import jobs I do not overload the system….

I keep the default here

I keep the default here

The PAS parameter

The default ports

For this PoC the default work process count is good enough

No SLD integration for me here…

The default secure store key is good enough for me

Start the installation after checking the parameter again.

Finished

Verify the DB access

Try to connect to the DB as syb

su – syba11
/sybase/A11% isql -Usapsa -SA11 -X
Password:
1>
2> select @@version
3> go
—————————————————————————
Adaptive Server Enterprise/16.0 SP04 PL01/EBF 29704 SMP/P/x86_64/SLES 
12.4/ase160sp04pl01x/3473/64-bit/FBO/Tue Jul 20 07:58:11 2021                               
(1 row affected)

Backup

There is some very good documentation available

How to get backup of Sybase ASE 16.0 | SAP Community

DATABASE BACKUP IN SYBASE | SAP Community

Backup strategy for Sybase ASE | SAP Community

Guided steps to Setup Disaster Recovery (DR) Site for SAP ASE (Sybase) Database running with SAP Business Suite Applications | SAP Blogs

2570084 – How to start Backup Server manually – SAP ASE – SAP ONE Support Launchpad

2307016 – How to manually configure and start ASE Cockpit for an existing ASE server – SAP ASE – SAP ONE Support Launchpad

2199714 – Error 4208 DUMP Transaction to a dump device is not allowed while the trunc log on chkpt option is enabled – SAP ASE – SAP ONE Support Launchpad

2199714 – Error 4208 DUMP Transaction to a dump device is not allowed while the trunc log on chkpt option is enabled – SAP ASE – SAP ONE Support Launchpad

1887068 – SYB: Using external backup and restore with SAP ASE – SAP ONE Support Launchpad

1585981 SYB: Ensuring Recoverability for Sybase ASE
1588316 SYB: Configure automatic database and log backups
1611715 SYB: How to restore a Sybase ASE database server (Windows)
1618817 SYB: How to restore a Sybase ASE database server (UNIX)
1887068 SYB: Using external backup and restore with SAP Sybase ASE

Define the backup location for data and log:

Change the access rights to the backup directory

chown -R syba11:sapsys /sybase/A11/backup

First need to login with ”sybsid”

su – syba11
isql -Usapsa -SA11 -X
Password: *******
use master
go  ( SID Transaction Log Database Backup configuration )

sp_config_dump @config_name=’A11LOG’,
@stripe_dir = ‘/sybase/A11/backup/log’ ,
@compression = ‘101’ ,
@verify = ‘header’
go

The change is completed. The option is dynamic and ASE need not be rebooted for
the change to take effect.
(return status = 0)
1>

Wait for the restart until the data-path is configured

( SID Database Backup configuration )

sp_config_dump @config_name=’A11DB’,
@stripe_dir = ‘/sybase/A11/backup/data’,
@compression = ‘101’ ,
@verify = ‘header’
go
The change is completed. The option is dynamic and ASE need not be rebooted for
the change to take effect.
(return status = 0)

Now restart the DB

su – a11adm
a11adm 13> stopsap db
a11adm 14> startsap db

verify that the DB is running (as syba11)

showserver
F S UID         PID   PPID  C PRI  NI ADDR SZ WCHAN  STIME TTY          TIME CMD
0 S syba11    83111  83109  0  80   0 –  7873 x64_sy 13:47 ?        00:00:00 /sybase/A11/ASE-16_0/bin/backupserver -e/sybase/A11/ASE-16_0/install/A11_BS.log -N25 -C20 -I/sybase/A11/interfaces -M/sybase/A11/ASE-16_0/bin/sybmultbuf -SA11_BS -f/sybase/A11/ASE-16_0/A11_BS.cfg
0 S syba11    83018  83016 39  80   0 – 2395958 –    13:47 ?        00:00:36 /sybase/A11/ASE-16_0/bin/dataserver -d/sybase/A11/sybsystem/master.dat -e/sybase/A11/ASE-16_0/install/A11.log -c/sybase/A11/ASE-16_0/A11.cfg -M/sybase/A11/ASE-16_0 -N/sybase/A11/ASE-16_0/sysam/A11.properties -i/sybase/A11 -sA11

Try to create a DB backup :

dump database master using config = A11DB
go 

dump database model using config = A11DB
go 

dump database saptempdb using config = A11DB
go 

dump database saptools using config = A11DB
go 

dump database A11 using config = A11DB
go

Trans log backup :

dump transaction A11 using config = A11LOG
go

Creating DB SnapShots

ASE Snapshot Backup Before taking a storage Snapshot copy, the database is put into a consistent state by quiescing the user database and master database. The following steps show how to perform database backup by using a storage Snapshot copy.

Using the aseuserstore Utility With Other SAP ASE Utilities – SAP Help Portal

quiesce database – SAP Help Portal

Install the Azure CLI on Linux | Microsoft Docs (SLES)

Download the azacsnap tool

https://aka.ms/azacsnapinstaller

Get started with Azure Application Consistent Snapshot tool for Azure NetApp Files | Microsoft Learn

Prepare the SIDadm user to be able to use isql

cd
pwd
/home/a11adm
vi .sapenv_ralfvm02.csh
setenv LC_ALL en_US.UTF-8    #(at the end of the file)
# end SAP R/3 Environment
exit  

su – a11adm
env |grep UTF
LANG=C.UTF-8
LC_ALL=en_US.UTF-8

Configure the ASE User Secure Store for SIDadm

We create a user store key with the name SNAP…

aseuserstore set SNAP ralfvm02:4901@A11 sapsa 

Check the DB connect with this key

isql -k SNAP -X
select @@version
go 
—————————————————————————
 Adaptive Server Enterprise/16.0 SP04 PL01/EBF 29704 SMP/P/x86_64/SLES 12.4/ase160sp04pl01x/3473/64-bit/FBO/Tue Jul 20 07:58:11 2021
(1 row affected)

The manual quiesce process:

quiesce database A11_for_SNAP hold A11, sybmgmtdb, saptools, master, sybsecurity for external dump
go

select is_quiesced(4)
go
 ———–
           1
(1 row affected)

You should create SnapShots for the data AND Sybase volume!!!

In the “data” volume is “only” the A11 database, the “sybase” volume is the location of the master- and the security database. Both are important for the recovery.

Now create the snapshot in the portal, azacsnap or Azure CLI

Un-quiesce the DB

quiesce database A11_for_SNAP release
go

select is_quiesced(4)
go
 ———–
           0
(1 row affected)

Device Overview

1> sp_helpdevice
2> go
 device_name          physical_name                                    description                                                                                    status cntrltype vdevno vpn_low vpn_high
————— —— ——— —— ——- ——–
 A11_data_001         /sybase/A11/sapdata_1/A11_data_001.dat           file system device, special, dsync off, directio on, physical disk, 40960.00 MB, Free: 0.00 MB      2         0      6       0 20971519
 A11_log_001          /sybase/A11/saplog_1/A11_log_001.dat             file system device, special, dsync off, directio on, physical disk, 10240.00 MB, Free: 0.00 MB      2         0      7       0  5242879
 master               /sybase/A11/sybsystem/master.dat                 file system device, special, dsync on, directio off, physical disk, 450.00 MB, Free: 78.00 MB       2         0      0       0   230399
 saptempdb_data_001   /sybase/A11/saptemp/saptempdb_data_001.dat       file system device, special, dsync off, directio on, physical disk, 8192.00 MB, Free: 0.00 MB       2         0     13       0  4194303
 saptools_data_001    /sybase/A11/sapdiag/saptools_data_001.dat        file system device, special, dsync off, directio on, physical disk, 2048.00 MB, Free: 0.00 MB       2         0      8       0  1048575
 saptools_log_001     /sybase/A11/sapdiag/saptools_log_001.dat         file system device, special, dsync off, directio on, physical disk, 2048.00 MB, Free: 0.00 MB       2         0      9       0  1048575
 sybmgmtdev           /sybase/A11/sybsystem/sybmgmtdb_data_001.dat     file system device, special, dsync off, directio on, physical disk, 150.00 MB, Free: 2.00 MB        2         0      4       0    76799
 sybmgmtlogdev        /sybase/A11/sybsystem/sybmgmtdb_log_001.dat      file system device, special, dsync off, directio on, physical disk, 50.00 MB, Free: 2.00 MB         2         0      5       0    25599
 sybsecurity_data_001 /sybase/A11/sybsecurity/sybsecurity_data_001.dat file system device, special, dsync off, directio on, physical disk, 1024.00 MB, Free: 0.00 MB       2         0     10       0   524287
 sybsecurity_data_002 /sybase/A11/sybsecurity/sybsecurity_data_002.dat file system device, special, dsync off, directio on, physical disk, 1024.00 MB, Free: 0.00 MB       2         0     11       0   524287
 sybsecurity_log_001  /sybase/A11/sybsecurity/sybsecurity_log_001.dat  file system device, special, dsync off, directio on, physical disk, 512.00 MB, Free: 0.00 MB        2         0     12       0   262143
 sysprocsdev          /sybase/A11/sybsystem/sysprocs.dat               file system device, special, dsync off, directio on, physical disk, 300.00 MB, Free: 0.00 MB        2         0      1       0   153599
 systemdbdev          /sybase/A11/sybsystem/sybsysdb.dat               file system device, special, dsync off, directio on, physical disk, 50.00 MB, Free: 2.00 MB         2         0      2       0    25599
tempdbdev            /sybase/A11/sybtemp/tempdbdev.dat                file system device, special, dsync off, directio off, physical disk, 3072.00 MB, Free: 0.00 MB      2         0      3       0  1572863
(return status = 0)

Configure azacsnap

Install the Azure Application Consistent Snapshot tool for Azure NetApp Files | Microsoft Learn

Azacsnap is supporting only HANA, DB2 and Oracle at the moment. It is, however, possible to take a snapshot from the data volume and use the new feature in the version 7 with pre and post automation.

Create the service principal for your subscription and install azacsnap – in the Azure Portal

Store the output in a file I used /tmp/auth.json

az ad sp create-for-rbac –name “AzAcSnap” –role Contributor –scopes /subscriptions/{subscription-id} –sdk-auth

You will get an output which looks similar to this:

{
  “clientId”: “0815**4711-4**-a91f-d937*********1”,
  “clientSecret”: “d~_8Q~****Zk*****Y_********”,
  “subscriptionId”: “47110815-***-****-***-**********”,
  “tenantId”: “K47110815-****-4ecc-bda0-**********”,
  “activeDirectoryEndpointUrl”: “https://login.microsoftonline.com”,
  “resourceManagerEndpointUrl”: “https://management.azure.com/”,
  “activeDirectoryGraphResourceId”: “https://graph.windows.net/”,
  “sqlManagementEndpointUrl”: “https://management.core.windows.net:8443/”,
  “galleryEndpointUrl”: “https://gallery.azure.com/”,
  “managementEndpointUrl”: “https://management.core.windows.net/”
}

Create an auth.conf file and copy the content into this file

vi /tmp/auth.json

ls -la /tmp
-rw-r–r– 1 root   root    25148727 Aug  2 11:02 azacsnap_6_installer.run
-rw-r–r– 1 root   root         629 Nov  7 14:32 auth.json

Install azacsnap

./azacsnap_7_installer.run -I

Configure azacsnap

azacsnap -c configure –configuration=new
Building new config file
Add comment to config file (blank entry to exit adding comments): ASE Test
Add comment to config file (blank entry to exit adding comments):
Enter the database type to add, ‘hana’, ‘oracle’, or ‘exit’ (for no database): oracle
=== Add Oracle Database details ===
Oracle Database SID (e.g. CDB1): A11
Database Server’s Address (hostname or IP address): 10.0.0.10
Oracle connect string (e.g. /@AZACSNAP):
=== Azure NetApp Files Storage details ===
Are you using Azure NetApp Files for the database? (y/n) [n]: y
— DATA Volumes have the Application put into a consistent state before they are snapshot —
Add Azure NetApp Files resource to DATA Volume section of Database configuration? (y/n) [n]: n
— OTHER Volumes are snapshot immediately without preparing any application for snapshot —
Add Azure NetApp Files resource to OTHER Volume section of Database configuration? (y/n) [n]: y
Full Azure NetApp Files Storage Volume Resource ID (e.g. /subscriptions/…/resourceGroups/…/providers/Microsoft.NetApp/netAppAccounts/…/capacityPools/Premium/volumes/…): /subscriptions/08154711-4***-**********/resourceGroups/*****/providers/Microsoft.NetApp/netAppAccounts/********/capacityPools/anfpool/volumes/A11data
Service Principal Authentication filename or Azure Key Vault Resource ID (e.g. auth-file.json or https://…): auth.json
Add Azure NetApp Files resource to OTHER Volume section of Database configuration? (y/n) [n]: y
Full Azure NetApp Files Storage Volume Resource ID (e.g. /subscriptions/…/resourceGroups/…/providers/Microsoft.NetApp/netAppAccounts/…/capacityPools/Premium/volumes/…): /subscriptions/08154711-4***-**********/resourceGroups/*****/providers/Microsoft.NetApp/netAppAccounts/********/capacityPools/anfpool/volumes/A11sybase
Service Principal Authentication filename or Azure Key Vault Resource ID (e.g. auth-file.json or https://…): auth.json
Add Azure NetApp Files resource to OTHER Volume section of Database configuration? (y/n) [n]: n
=== Azure Managed Disk details ===
Are you using Azure Managed Disks for the database? (y/n) [n]: n
=== Azure Large Instance (Bare Metal) Storage details ===
Are you using Azure Large Instance (Bare Metal) for the database? (y/n) [n]: n
Enter the database type to add, ‘hana’, ‘oracle’, or ‘exit’ (for no database): exit
Editing configuration complete, writing output to ‘azacsnap.json’.

Test the storage connection, at this point we “only” can test the storage connection. The ASE backup-mode will be scheduled as “runbefore” and “runafter”.

azacsnap -c test –test=storage
BEGIN : Test process started for ‘storage’
BEGIN : Storage test snapshots on ‘data’ volumes
BEGIN : Test Snapshots for Storage Volume Type ‘data’
PASSED: Storage test completed successfully for all ‘data’ Volumes
END   : Storage tests complete
END   : Test process complete for ‘storage’

Create the .bashrc for the azacsnap user (compare the environment from the SIDadm user)

vi .bashrc
…
export LANG=C.UTF-8
export LC_ALL=en_US.UTF-8
export PATH=$PATH:/sybase/A11/OCS-16_0/bin:/usr/sap/A11/SYS/exe/uc/linuxx86_64:/usr/sap/A11/SYS/exe/run:/home/a11adm:/sybase/A11/ASE-16_0/jobscheduler/bin:/sybase/A11/ASE-16_0/bin:/sybase/A11/ASE-16_0/install:/sybase/A11/WLA/bin::/sybase/A11/OCS-16_0/bin:
export RSEC_SSFS_DATAPATH=/usr/sap/A11/SYS/global/security/rsecssfs/data
export RSEC_SSFS_KEYPATH=/usr/sap/A11/SYS/global/security/rsecssfs/key
export LD_LIBRARY_PATH=/usr/sap/A11/SYS/exe/run:/usr/sap/A11/SYS/exe/uc/linuxx86_64:/usr/sap/A11/SYS/global/syb/linuxx86_64/sybodbc:/sybase/A11/ASE-16_0/lib:/sybase/A11/OCS-16_0/lib:/sybase/A11/OCS-16_0/lib3p64:/sybase/A11/OCS-16_0/lib3p:
export SYBASE_OCS=OCS-16_0
export SYBASE=/sybase/A11
export SYBASE_ASE=ASE-16_0
export SYBASE_JRE_RTDS=/sybase/A11/shared/SAPJRE-8_1_075_64BIT
export SYBASE_WS=WS-16_0

We create a user store key with the name SNAP…

aseuserstore set SNAP ralfvm02:4901@A11 sapsa 

Create the two Quice and Unquice scripts. (no Microsoft support) this is only an example.

vi aseQuiesce.sh
#!/bin/bash
SID=”$1″
KEY=”$2″
SAVEPOINT=”SNAPSHOT_BACKUP”
if [[ “$SID” == “” || “$KEY” == “” ]]; then
  echo “Usage: `basename $0`  ”  exit 1
fi
sqlFile=$(mktemp)
cat > $sqlFile << EOF
quiesce database $SAVEPOINT hold $SID, sybmgmtdb, saptools, master, sybsecurity for external dump
go
select is_quiesced(4)
go
EOF
rc=`isql -k $KEY -X -i $sqlFile -b | head -1 | tr -d “[:blank:]”`
rm $sqlFile
if [ $rc = 1 ]; then
  echo “Database $SID succesfully quiesced.”  exit 0
else
  echo “Error quiescing database $SID.”  exit 1
fi

vi aseUnquiesce.sh
#!/bin/bash
SID=”$1″
KEY=”$2″
SAVEPOINT=”SNAPSHOT_BACKUP”
if [[ “$SID” == “” || “$KEY” == “” ]]; then
  echo “Usage: `basename $0`  ”  exit 1
fi
sqlFile=$(mktemp)
cat > $sqlFile << EOF
quiesce database $SAVEPOINT release
go
select is_quiesced(4)
go
EOF
rc=`isql -k $KEY -X -i $sqlFile -b | head -1 | tr -d “[:blank:]”`
rm $sqlFile
if [ $rc = 0 ]; then
  echo “Database $SID successfully unquiesced.”  exit 0
else
  echo “Error unquiescing database $SID.”  exit 1
fi

Test the scripts and the logon with user azacsnap

Logon via isql

su – azacsnap
cd bin
isql -k SNAP -X
1> exit  

Test the Quice and Unquics script

su – azacsnap
cd bin 

aseQuiece.sh A11 SNAP
Database A11 succesfully quiesced. exit 0

aseUnquiesce.sh A11 SNAP
Database A11 successfully unquiesced. exit 0

Now create an application consistent snapshot using azacsnap

su – azacsnap

cd bin

aseQuiece.sh A11 SNAP
Database A11 succesfully quiesced. exit 0

azacsnap -c backup –volume other –prefix ASE_hourly –retention 3

aseUnquiesce.sh A11 SNAP
Database A11 successfully unquiesced. exit 0

Check the portal is the snapshot exists

List the taken SnapShots

azacsnap -c details
List snapshot details called with snapshotFilter ”
#, Volume, SnapshotName
#1, ralfA11data, ASE_hourly__2022-11-08T144805-3701065Z
#2, ralfA11data, Test03
#1, ralfA11sybase, ASE_hourly__2022-11-08T144805-3701065Z

Fully automat the snapshot creation

azacsnap -c backup –volume other –prefix ASE_hourly –runbefore ‘/home/azacsnap/bin/aseQuiece.sh’ –runafter ‘/home/azacsnap/bin/aseUnquiesce.sh’ –retention 3

azacsnap -c details
List snapshot details called with snapshotFilter ”
#, Volume, SnapshotName
#1, ralfA11data, ASE_hourly__2022-11-12T070552-5533842Z
#2, ralfA11data, ASE_hourly__2022-11-08T144805-3701065Z
#3, ralfA11data, Test03
#1, ralfA11sybase, ASE_hourly__2022-11-12T070552-5533842Z
#2, ralfA11sybase, ASE_hourly__2022-11-08T144805-3701065Z

Restore using azacsnap

Shutdown SAP and ASE (if possible – if not simply “kill” the DB. We are restoring anyway.

stopsap all

kill all Sybase processes

killall -u syba11

Umount the data directory (we keep the Sybase exe volume) we assume only the data volume must be restored)

umount /sybase/A11/sapdata_1 

At the moment azacsnap does not support “Revert Volume” for ANF. If you would like to keep the volume names you have the option to “revert a volume using the Azure Portal.

See:

su – azacsnap
cd bin
azacsnap -c restore –dbsid A11 –restore revertvolume –configfile azacsnap.json –snapshotfilter ASE_hourly__2022-11-08T144805-3701065Z
…
Azure NetApp Files volumes not supported for revertvolume, will not revert volume. 

With ANF you do have the option to clone a volume. This is probably the better option anyway. How to clone a volume for a recovery is demonstrated here:

AzAcSnap is designed to restore a collection of dataVolumes and otherVolumes.  AzAcSnap makes sure all the dataVolumes share the same snapshot to be restored and the otherVolumes the latest snapshot to be restored.  In a deployment with multiple data volumes (e.g., SAP HANA Scale-Out) this can save a lot of time trying to ensure all the snapshots match in the Azure Portal before cloning or reverting the volumes.  This means when using a setup with custom scripts to quiesce/unquiesce the database it’s necessary to create a copy of the backup configfile and change “otherVolume” to “dataVolume” and change “dataVolume” to “otherVolume” effectively switching them.

cp azacsnap.json azacsnap_snaptovol.json
vi azacsnap_snaptovol.json
        “anfStorage”: [
          {
            “otherVolume”: [],
            “dataVolume”: [

Down here are the specifications of your ANF volumes à keep unchanged change only dataVolume to otherVolume and otherVolume to dataVolume.

list the available SnapShots

azacsnap -c details
List snapshot details called with snapshotFilter ”
#, Volume, SnapshotName
#1, ralfA11data, ASE_hourly__2022-11-08T144805-3701065Z
#1, ralfA11sybase, ASE_hourly__2022-11-08T144805-3701065Z 

azacsnap -c restore –dbsid A11 –restore revertvolume –configfile azacsnap_snaptovol.json –snapshotfilter ASE_hourly__2022-11-08T144805-3701065Z

create the new /etc/fstab

pwd
/home/azacsnap/bin

grep rwclone ./logs/*.log
… Creating new volume ‘ralfa11data-rwclone-20221111-0732’
… Volume ‘ralfa11data-rwclone-20221111-0732’ successfully created from snapshot.
…
… Creating new volume ‘ralfa11sybase-rwclone-20221111-0732’
… Volume ‘ralfa11sybase-rwclone-20221111-0732’ successfully created from snapshot.

Since I only recover the data volume I only change the data volume location must be done as root.

exit

vi /etc/fstab
anf02:/ralfASEsoftware  /Software    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
#
anf02:/ralfA11shared/sapmnt  /sapmnt   nfs rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
anf02:/ralfA11shared/usr_sap  /usr/sap/A11    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
#
anf02:/ralfA11sybase/sybsystem  /sybase/A11/sybsystem    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
anf02:/ralfA11sybase/sybtemp  /sybase/A11/sybtemp    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
anf02:/ralfA11sybase/sapdiag  /sybase/A11/sapdiag    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
anf02:/ralfA11sybase/sybsecurity  /sybase/A11/sybsecurity  nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
anf02:/ralfA11sybase/saptemp  /sybase/A11/saptemp    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0
#
anf02:/ralfa11data-rwclone-20221111-0732/sapdata_1  /sybase/A11/sapdata_1 nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0anf02:/ralfA11log/saplog_1  /sybase/A11/saplog_1    nfs  rw,hard,timeo=600,vers=4.1,nconnect=8,rsize=262144,wsize=262144,noatime,lock  0  0

the clone of the “ralfA11sybase” volume should (must) be deleted manually. It is not required for a “normal” database recovery. We require only the data-volume.

mount the clone volumes

mount -a
anf02:/ralfA11shared/usr_sap    100G  3.6G   97G   4% /usr/sap/A11
anf02:/ralfA11log/saplog_1      100G   11G   90G  11% /sybase/A11/saplog_1
anf02:/ralfASEsoftware          100G   17G   84G  17% /Software
anf02:/ralfA11shared/sapmnt     100G  3.6G   97G   4% /sapmnt
anf02:/ralfA11sybase/sybsystem  100G  9.3G   91G  10% /sybase/A11/sybsystem
anf02:/ralfA11sybase/sybtemp    100G  9.3G   91G  10% /sybase/A11/sybtemp
anf02:/ralfA11sybase/sapdiag    100G  9.3G   91G  10% /sybase/A11/sapdiag
anf02:/ralfA11sybase/sybsecurity 100G 9.3G 91G  10% /sybase/A11/sybsecurity
anf02:/ralfA11sybase/saptemp    100G  9.3G   91G  10% /sybase/A11/saptemp
anf02:/ralfa11data-rwclone-20221111-0732/sapdata_1  100G   41G   60G  41% /sybase/A11/sapdata_1

su – a11adm
startdb
starting database A11 …
Log file: /sybase/A11/startdb.log
parse level 0: identified message ‘Database ‘master’ is now online.’
parse level 1: identified message ‘Database ‘tempdb’ is now online.’
parse level 2: identified message ‘Database ‘sybsystemprocs’ is now online.’
parse level 3: identified message ‘Recovery complete.’
Recovery Complete
startdb completed successfully

grep identified /sybase/A11/startdb.log
parse level 0: identified message ‘Database ‘master’ is now online.’
parse level 1: identified message ‘Database ‘tempdb’ is now online.’
parse level 2: identified message ‘Database ‘sybsystemprocs’ is now online.’
parse level 3: identified message ‘Recovery complete.’
Recovery Complete

Restore – manual

The restore process is easy.

After you discover an issue and you need to restore the ASE DB you stop the DB (if possible).

Make sure you have all logfile backups available in its original location

stopdb
stopping database A11 …
stop database completed successfully

kill all Sybase processes

killall -u syba11

Unmount the volume and revert it

umount /sybase/A11/sapdata_1

Revert the volume

Mount the data volume

mount -a

Start the DB and check the logfile

su – a11adm
startdb
starting database A11 …
Log file: /sybase/A11/startdb.log
parse level 0: identified message ‘Database ‘master’ is now online.’
parse level 1: identified message ‘Database ‘tempdb’ is now online.’
parse level 2: identified message ‘Database ‘sybsystemprocs’ is now online.’
parse level 3: identified message ‘Recovery complete.’
Recovery Complete
startdb completed successfully

grep identified /sybase/A11/startdb.log
parse level 0: identified message ‘Database ‘master’ is now online.’
parse level 1: identified message ‘Database ‘tempdb’ is now online.’
parse level 2: identified message ‘Database ‘sybsystemprocs’ is now online.’
parse level 3: identified message ‘Recovery complete.’
Recovery Complete

Now the media recovery is complete. Start SAP

su – a11adm
startsap all

Done…

have fun..

January Update Blog

by Contributed | Feb 3, 2023 | Technology

This article is contributed. See the original author and article here.

Hello from the Project Team! The January updates for Project for the Web are as follows: 

New Features

• Grid Conditional Coloring ~ Create rules on various project fields to visually highlight patterns in the project data. 


• Increased Taks Limit ~ Create up to 1,000 tasks within a single project 

Upcoming Features 

• Extended Timeline Zoom ~ Get a more complete picture of your long-term project in the Timeline view by using 4 new zoom scale options. 


• Advanced Dependencies ~ Set non-default dependencies between tasks such as Start-to-Start, Finish-to-Finish and Start-to-Finish dependencies. 


• Assigned to Me ~ View and update Project tasks assigned to you in the “Assigned to me” tab in Planner, Tasks in Teams, and To Do. 

Azure Marketplace new offers – February 2, 2023

by Contributed | Feb 2, 2023 | Technology

This article is contributed. See the original author and article here.

We continue to expand the Azure Marketplace ecosystem. For this volume, 81 new offers successfully met the onboarding criteria and went live. See details of the new offers below:

Get it now in our marketplace
	AGRIVI 360 Farm Insights: AGRIVI 360 Farm Insights simplifies administration and helps farmers make precise agronomic decisions based on real-time field information. This can ensure crop production traceability and enable compliance with quality, safety, and sustainability standards.
	Booking for Outlook (LV-Tron): IAdea’s LV-Tron, a meeting room booking system, seamlessly integrates with Microsoft Outlook and the Microsoft Graph API, allowing users to easily schedule and manage room reservations from within their Outlook calendar.
	Data Science Virtual Desktop – Ubuntu 22.04: This offer from Ntegral provides a customized virtual machine image built specifically for data science. Several popular tools for data exploration, analysis, modeling, and development are preinstalled, including Anaconda, Python, Jupyter Hub, Jupyter Lab, Visual Studio Code, and PySpark.
	DevOps All-in-One Platform with Jenkins: This offer from VMLab, an authorized reseller of Websoft9, provides GitLab CE 15.6 with Jenkins 2.375, NGINX 1.22, and Docker 20.10. GitLab CE bundles code review, continuous integration, and continuous deployment into a single UI.
	Firebird 3.0.7 on Ubuntu 20.04 LTS: This offer from Tidal Media provides Firebird 3.0.7 on Ubuntu 20.04 LTS. Firebird is a relational database management system that can scale from an embedded single-user model to enterprise-wide deployments with multiple 2-terrabye databases running and hundreds of simultaneous clients.
	Grid Vision: Built for the utilities industry, the AI-powered Grid Vision Inspect enables virtual inspections of overhead power lines. This improves inspection safety for transmission and distribution utilities globally, and it supports a transition to predictive maintenance of the power grid.
	Grid Vision Asset Guide: Grid Vision Asset Guide allows utilities organizations to consolidate their digitized substation inventory, documents, and images, then visualize that information through an intuitive user interface. Grid Vision Asset Guide can improve inspection planning, capacity planning, and operations.
	hyOffice for Microsoft Teams: Fit for the world of hybrid work, the hyOffice app for Microsoft Teams lets your team see who’s in the office for a meeting and who’s joining virtually. Employees can maintain a favorites list of their team colleagues, schedule their office days based on occupancy, and see meeting participants in the day’s calendar.
	Keycloak on Ubuntu Server 20.04 LTS: This offer from AskforCloud provides Keycloak on Ubuntu Server 20.04 LTS. Keycloak, an open-source identity and access management solution, encompasses user federation, strong authentication, user management, and fine-grained authorization.
	KNIME Analytics Platform on Windows Server 2016: This offer from AskforCloud provides KNIME Analytics Platform on Windows Server 2016. KNIME Analytics Platform is open-source software that lets you build analyses of any complexity level, from automating spreadsheets to ETL (extract, transform, load) to machine learning.
	Kubeark Container: Transform your on-premises product into software as a service with Kubeark, a container and app management platform. Using containers managed by Kubeark, your infrastructure costs will be lower, you will gain out-of-the-box high availability, and your DevOps team will be able to run containerized workloads on any infrastructure.
	Locust on Ubuntu Server 20.04 LTS: This offer from AskforCloud provides Locust on Ubuntu Server 20.04 LTS. Locust is an open-source load-testing tool that allows you to define the behavior of your users in regular Python code instead of being stuck in a UI or restrictive domain-specific language.
	ME Applications Manager with Add-ons (500 Monitors): ManageEngine Applications Manager is an integrated application and server performance-monitoring solution that helps businesses ensure high availability. It provides deep visibility into the performance of a diverse set of apps and infrastructure components, both within the datacenter and in the cloud.
	Melingo Search, Secured and Supported by HOSSTED: This offer from HOSSTED provides Morfix Search by Melingo on a Microsoft Azure virtual machine. Morfix Search is a morphological Hebrew-English plug-in for OpenSearch, a community-driven open-source search and analytics suite.
	MongoDB: This offer from Kockpit provides MongoDB Community Server, a distributed document database, on a Microsoft Azure virtual machine. MongoDB Community Server’s flexible document model, along with ad hoc queries, indexing, and real-time aggregation, gives you powerful ways to access and analyze your data.
	PureFTPd on Debian 10 Minimal: This offer from Art Group provides PureFTPd on a minimal installation of Debian 10. PureFTPd is a security-focused FTP server that uses simple command-line switches to enable the features you need, such as optional support for an SSL/TLS encryption layer using the OpenSSL library.
	PureFTPd on Debian 11 Minimal: This offer from Art Group provides PureFTPd on a minimal installation of Debian 11. PureFTPd is a security-focused FTP server that uses simple command-line switches to enable the features you need, such as optional support for an SSL/TLS encryption layer using the OpenSSL library.
	PureFTPd on Oracle 8.6 Minimal: This offer from Art Group provides PureFTPd on a minimal installation of Oracle 8.6. PureFTPd is a security-focused FTP server that uses simple command-line switches to enable the features you need, such as optional support for an SSL/TLS encryption layer using the OpenSSL library.
	QGIS Server: This offer from tunnelbiz Studio Sdn Bhd provides QGIS on a Microsoft Azure virtual machine. QGIS is an open-source geographic information system that supports viewing, editing, printing, and analysis of geospatial data.
	Red Hat Enterprise Linux 8.3 Minimal: This offer from Ntegral provides a minimal installation of Red Hat Enterprise Linux 8.3 on a Microsoft Azure virtual machine. Red Hat Enterprise Linux has built-in security features such as Security-Enhanced Linux (SELinux) and mandatory access controls to help you combat intrusions and meet regulatory compliance.
	Starbound Game Server on Windows Server 2019: This offer from Tidal Media provides Starbound on Windows Server 2019. Starbound is an action-adventure video game that takes place in a two-dimensional procedurally generated universe. Players can deploy the game server on Azure and modify the game to add new races, biomes, dungeons, or quests.
	Swift 5 on CentOS: This offer from AskforCloud provides Swift 5 on a CentOS Linux distribution. Swift is an open-source high-performance system programming language with clean and modern syntax. Swift offers seamless access to existing C and Objective-C code and frameworks, and it’s memory-safe by default.
	Swift 5 on Ubuntu Server 18.04 LTS: This offer from AskforCloud provides Swift 5 on Ubuntu Server 18.04 LTS. Swift is an open-source high-performance system programming language with clean and modern syntax. Swift offers seamless access to existing C and Objective-C code and frameworks, and it’s memory-safe by default.
	TIBCO Jaspersoft Reporting and Analytics for Azure v 8.1.1: TIBCO Jaspersoft is a reporting and analytics server built for Microsoft Azure that can run alone or be embedded in your application. Use it to to quickly connect to your Azure data sources, then create and distribute beautiful interactive reports, dashboards, and data visualizations.
	Touchcast Metaverse Car Configurator: Touchcast Metaverse Car Configurator gives car buyers a real-time 3D experience instead of static pictures or prerecorded videos. This immersive, hyper-personalized customer journey increases engagement and maximizes conversion rates.
	TrilioVault for Kubernetes (PAYG): TrilioVault for Kubernetes is a cloud-native, application-centric data protection and management platform designed from the ground up to support the scale, performance, and mobility requirements of Kubernetes container environments.
	Ubuntu Web Server: This offer from tunnelbiz Studio Sdn Bhd provides a preconfigured image containing an NGINX web server, the PHP scripting language, and an Ubuntu operating system on a Microsoft Azure virtual machine.
	Yoffix for Microsoft Teams: HybridOffice21’s Yoffix for Microsoft Teams introduces midsize and enterprise clients to flexible-office concepts, such as shared desks, to transparently manage office attendance and to cut costs. Yoffix lets companies manage hybrid work from within Microsoft Teams. Book desks, book parking, and enable collaboration with Yoffix.
	Zammad on Debian 10: This offer from AskforCloud provides Zammad on Debian 10. Zammad is an open-source user support and ticketing solution for managing customer communication across channels such as phone, chat, email, and social media.
	Zammad on Debian 11: This offer from AskforCloud provides Zammad on Debian 11. Zammad is an open-source user support and ticketing solution for managing customer communication across channels such as phone, chat, email, and social media.
Go further with workshops, proofs of concept, and implementations
	Accelerated Cloud Enabler for Azure Virtual Desktop (4 Weeks): Many businesses today have employees working remotely, which requires seamless and secure access to data and applications. This engagement from Devoteam will quickly set you up with an Azure Virtual Desktop solution following an assessment and a series of workshops.
	Accelerated Cloud Enabler for GitOps (4 Weeks): Devoteam’s Accelerated Cloud Enabler framework provides an automation engine using GitOps. Devoteam will implement a large number of best practices as Infrastructure as Code (IaC), automated processes, and ready-made templates, ensuring speed, consistency, security, and compliance in your Azure operations.
	Accelerated Cloud Enabler for SIEM (4 Weeks): Devoteam’s Accelerated Cloud Enabler for SIEM will enable your IT security team to work faster and more effectively. Devoteam will implement ACE SIEM, which utilizes Microsoft Sentinel, then train your organization to ensure you can use and adjust your new security operations.
	Accelerated Cloud Enabler for Transformation (8 Weeks): Devoteam will assess your company’s IT environment, break down your applications and solutions into workloads, and design an optimal migration plan for each workload. A structured migration will use automation and Infrastructure-as-Code processes to ensure consistency. This will be followed by testing and a series of workshops.
	AI and Intelligent Automation Workshop: This workshop from Productive Edge will accelerate your adoption of robotic process automation and intelligent automation on Microsoft Azure. You’ll identify potential use cases for automation and be able to take the initiative in standardizing processes and realizing cost savings.
	Automating Administration with PowerShell: This five-day course from John Bryce Training will focus on PowerShell. You’ll learn how to remotely manage single or multiple Windows-based servers and automate day-to-day management and administration tasks. Before taking this course, participants should have experience with Windows networking technologies and implementation.
	Azure Cost Analysis: In this assessment, TriStratus will provide greater transparency into your Azure consumption. You’ll save money by uncovering unnecessary expenses, get help setting a budget, and establish notifications and alerts to notify you if spending begins to creep over budgeted levels.
	Azure Data Warehouse: 4-Week Assessment: Taod will analyze your on-premises or hybrid-cloud architectures and work with you to design a new technological architecture based on Microsoft Azure. This offer is only available in German.
	Azure Managed Service (1 Year): In this managed service, experts from TriStratus will drive business optimization and ensure your environment is aligned to Microsoft best practices by continually monitoring against pillars of the Azure Well-Architected Framework. In addition, TriStratus’ sustainability pillar will help you monitor and reduce your carbon emissions.
	BaseIT Managed Service for SQL: In this managed service, Base-IT will provide proactive and reactive support for your Microsoft SQL Server and databases. Round-the-clock support is available upon request. This offer is available only in German.
	Brand Guardian Intelligent Content Management: 6-Hour Workshop: This collaborative workshop from Wunderman Thompson will identify new solutions to give marketing, creative, and production teams content quality assurance. It’s the first step toward a multi-level engagement involving an Azure-based SaaS solution that provides intelligent content management.
	Data Warehouse Foundation: 4-Week Implementation: R Systems will design an architecture for ingesting your organization’s data sources in a common data warehouse, then use pipelines to move, format, clean, validate, summarize, reorganize, and store them for reporting in a business intelligence dashboard.
	DevOps Live-Site Engineering and Support (10 Weeks): Quadrant’s implementation service will enable customers to onboard to Azure DevOps with tools and technologies to view service-level agreements and product health metrics through built-in dashboards.
	Fully Managed Essential 8 Cybersecurity: Spicy IT’s managed service involves application control, patch management, multifactor authentication, backups, disaster recovery, and more. Businesses will be able to assess their cybersecurity maturity against established benchmarks.
	Managed Cloud Services: Absolute Cloud can help you design, build, and manage comprehensive cloud solutions based on your requirements and goals. To begin, Absolute Cloud’s architects, engineers, and DevOps specialists will work closely with your IT team to help you migrate to the cloud.
	Managed Service for Windows and Linux Servers: Do you require additional smart eyes and hands to ensure your Azure environment is always up and running? IT Relation can provide continuous monitoring to simplify management of servers on Azure. Linux and Windows operating systems are covered, as are production, development, and test environments.
	MicroAge Managed Services for Azure: MicroAge provides managed services such as monitoring Microsoft Azure infrastructure. The standard package caters to cloud service provider clients who would like MicroAge to design, operate, and manage their public cloud infrastructure.
	ML Recommendation Engine: 6-Week Implementation: R Systems will implement its machine learning recommendation engine, powered by Microsoft Azure Synapse and Azure Databricks, so you can get a comprehensive profile of your customers. Gaining a deep understanding of your customers’ interests and purchasing patterns will enable you to better engage your customers and drive sales.
	SAP SuccessFactors and Azure AD Integration (6 Weeks): Whether your organization is using SAP SuccessFactors HCM or SuccessFactors Employee Central, Oxford Computer Group can help you provision SuccessFactors to Azure Active Directory and to on-premises Active Directory.
	SQL Server Health Check: Data Platform will conduct health checks on Microsoft SQL Server systems in your institution’s infrastructure to examine performance and reveal any potential actions for improvement. At the end of the study, suggestions will be presented to you in a report.
Contact our partners
10-Day Assessment for ilionx ZorgControl 2.0
Accenture ADAPT Forecast and Demand
Active Deposit Management Solution for Banks: FlowTracker Analytics
Argonaut Industry 4.0 on Multi-Access Edge Compute
Asgardeo by WSO2
Astera Centerprise
Astera DW Builder
Azure Data Platform: 1-Hour Briefing
Azure Operational Managed Services (Advanced)
Blockchain Traceability, Authenticity, and CX
Cloud for Tax
Cloud Migration and App Modernization Accelerator
Cloud-Native Development: 1-Hour Briefing
Customer Experience Accelerator
Data Strategy Service: 3-Week Assessment
Digital Strategy Accelerator for Azure
FinOps Program: 4-Week Assessment
HCL Enterprise 5G Consultancy Services
Health AI-Driven Intelligent Care Augmentation Solution for Epic and Cerner EHR
Insite AI
Insurance Analytics: 5-Week Assessment
Modern Data Platform and Analytics Accelerator
NAVIK Marketing AI
Optimizing Design Sprints and DevOps Accelerator
Pathr.ai
Public Sector Analytics: 5-Week Assessment
Retail Analytics: 5-Week Assessment
ScaleOps Platform
SWOOP Analytics for SharePoint
SymphonyAI NetReveal: Customer Due Diligence
Wipro devNXT: AI-Powered Modernization Solution