Expert configuration options, on-premises deployment, and SAPControl log sources
This article describes how to deploy the Microsoft Sentinel for SAP data connector in an expert or custom process, such as using an on-premises machine and an Azure Key Vault to store your credentials.
Note
The default, and most recommended process for deploying the Microsoft Sentinel for SAP data connector is by using an Azure VM. This article is intended for advanced users.
Prerequisites
The basic prerequisites for deploying your Microsoft Sentinel for SAP data connector are the same regardless of your deployment method.
Make sure that your system complies with the prerequisites documented in the main SAP data connector prerequisites document before you start.
Create your Azure key vault
Create an Azure key vault that you can dedicate to your Microsoft Sentinel solution for SAP® applications data connector.
Run the following command to create your Azure key vault and grant access to an Azure service principal:
kvgp=<KVResourceGroup>
kvname=<keyvaultname>
spname=<sp-name>
kvname=<keyvaultname>
# Optional when Azure MI not enabled - Create sp user for AZ cli connection, save details for env.list file
az ad sp create-for-rbac –name $spname --role Contributor --scopes /subscriptions/<subscription_id>
SpID=$(az ad sp list –display-name $spname –query “[].appId” --output tsv
#Create key vault
az keyvault create \
--name $kvname \
--resource-group $kvgp
# Add access to SP
az keyvault set-policy --name $kvname --resource-group $kvgp --object-id $spID --secret-permissions get list set
For more information, see Quickstart: Create a key vault using the Azure CLI.
Add Azure Key Vault secrets
To add Azure Key Vault secrets, run the following script, with your own system ID and the credentials you want to add:
#Add Abap username
az keyvault secret set \
--name <SID>-ABAPUSER \
--value "<abapuser>" \
--description SECRET_ABAP_USER --vault-name $kvname
#Add Abap Username password
az keyvault secret set \
--name <SID>-ABAPPASS \
--value "<abapuserpass>" \
--description SECRET_ABAP_PASSWORD --vault-name $kvname
#Add Java Username
az keyvault secret set \
--name <SID>-JAVAOSUSER \
--value "<javauser>" \
--description SECRET_JAVAOS_USER --vault-name $kvname
#Add Java Username password
az keyvault secret set \
--name <SID>-JAVAOSPASS \
--value "<javauserpass>" \
--description SECRET_JAVAOS_PASSWORD --vault-name $kvname
#Add abapos username
az keyvault secret set \
--name <SID>-ABAPOSUSER \
--value "<abaposuser>" \
--description SECRET_ABAPOS_USER --vault-name $kvname
#Add abapos username password
az keyvault secret set \
--name <SID>-ABAPOSPASS \
--value "<abaposuserpass>" \
--description SECRET_ABAPOS_PASSWORD --vault-name $kvname
#Add Azure Log ws ID
az keyvault secret set \
--name <SID>-LOGWSID \
--value "<logwsod>" \
--description SECRET_AZURE_LOG_WS_ID --vault-name $kvname
#Add Azure Log ws public key
az keyvault secret set \
--name <SID>-LOGWSPUBLICKEY \
--value "<loswspubkey>" \
--description SECRET_AZURE_LOG_WS_PUBLIC_KEY --vault-name $kvname
For more information, see the az keyvault secret CLI documentation.
Perform an expert / custom installation
This procedure describes how to deploy the Microsoft Sentinel for SAP data connector using an expert or custom installation, such as when installing on-premises.
We recommend that you perform this procedure after you have a key vault ready with your SAP credentials.
To deploy the Microsoft Sentinel for SAP data connector:
On your on-premises machine, download the latest SAP NW RFC SDK from the SAP Launchpad site > SAP NW RFC SDK > SAP NW RFC SDK 7.50 > nwrfc750X_X-xxxxxxx.zip.
Note
You'll need your SAP user sign-in information in order to access the SDK, and you must download the SDK that matches your operating system.
Make sure to select the LINUX ON X86_64 option.
On your on-premises machine, create a new folder with a meaningful name, and copy the SDK zip file into your new folder.
Clone the Microsoft Sentinel solution GitHub repository onto your on-premises machine, and copy Microsoft Sentinel solution for SAP® applications solution systemconfig.ini file into your new folder.
For example:
mkdir /home/$(pwd)/sapcon/<sap-sid>/ cd /home/$(pwd)/sapcon/<sap-sid>/ wget https://raw.githubusercontent.com/Azure/Azure-Sentinel/master/Solutions/SAP/template/systemconfig.ini cp <**nwrfc750X_X-xxxxxxx.zip**> /home/$(pwd)/sapcon/<sap-sid>/Edit the systemconfig.ini file as needed, using the embedded comments as a guide. For more information, see Manually configure the Microsoft Sentinel for SAP data connector.
To test your configuration, you may want to add the user and password directly to the systemconfig.ini configuration file. While we recommend that you use Azure Key vault to store your credentials, you can also use an env.list file, Docker secrets, or you can add your credentials directly to the systemconfig.ini file.
Define the logs that you want to ingest into Microsoft Sentinel using the instructions in the systemconfig.ini file. For example, see Define the SAP logs that are sent to Microsoft Sentinel.
Define the following configurations using the instructions in the systemconfig.ini file:
- Whether to include user email addresses in audit logs
- Whether to retry failed API calls
- Whether to include cexal audit logs
- Whether to wait an interval of time between data extractions, especially for large extractions
For more information, see SAL logs connector configurations.
Save your updated systemconfig.ini file in the sapcon directory on your machine.
If you have chosen to use an env.list file for your credentials, create a temporary env.list file with the required credentials. Once your Docker container is running correctly, make sure to delete this file.
Note
The following script has each Docker container connecting to a specific ABAP system. Modify your script as needed for your environment.
Run:
############################################################## # Include the following section if you're using user authentication ############################################################## # env.list template for Credentials SAPADMUSER=<SET_SAPCONTROL_USER> SAPADMPASSWORD=<SET_SAPCONTROL_PASS> LOGWSID=<SET SENTINEL WORKSPACE id> LOGWSPUBLICKEY=<SET SENTINEL WORKSPACE KEY> ABAPUSER=SET_ABAP_USER> ABAPPASS=<SET_ABAP_PASS> JAVAUSER=<SET_JAVA_OS_USER> JAVAPASS=<SET_JAVA_OS_USER> ############################################################## # Include the following section if you are using Azure Keyvault ############################################################## # env.list template for AZ Cli when MI is not enabled AZURE_TENANT_ID=<your tenant id> AZURE_CLIENT_ID=<your client/app id> AZURE_CLIENT_SECRET=<your password/secret for the service principal> ##############################################################Download and run the pre-defined Docker image with the SAP data connector installed. Run:
docker pull mcr.microsoft.com/azure-sentinel/solutions/sapcon:latest-preview docker run --env-file=<env.list_location> -d --restart unless-stopped -v /home/$(pwd)/sapcon/<sap-sid>/:/sapcon-app/sapcon/config/system --name sapcon-<sid> sapcon rm -f <env.list_location>Verify that the Docker container is running correctly. Run:
docker logs –f sapcon-[SID]Continue with deploying Microsoft Sentinel solution for SAP® applications.
Deploying the solution enables the SAP data connector to display in Microsoft Sentinel and deploys the SAP workbook and analytics rules. When you're done, manually add and customize your SAP watchlists.
For more information, see Deploy the Microsoft Sentinel solution for SAP applications® from the content hub.
Manually configure the Microsoft Sentinel for SAP data connector
The Microsoft Sentinel for SAP data connector is configured in the systemconfig.ini file, which you cloned to your SAP data connector machine as part of the deployment procedure.
The following code shows a sample systemconfig.ini file:
[Secrets Source]
secrets = '<DOCKER_RUNTIME/AZURE_KEY_VAULT/DOCKER_SECRETS/DOCKER_FIXED>'
keyvault = '<SET_YOUR_AZURE_KEYVAULT>'
intprefix = '<SET_YOUR_PREFIX>'
[ABAP Central Instance]
##############################################################
# Define the following values according to your server configuration.
ashost = <SET_YOUR_APPLICATION_SERVER_HOST>
mshost = <SET_YOUR_MESSAGE_SERVER_HOST> - #In case different then App
##############################################################
group = <SET_YOUR_LOGON_GROUP>
msserv = <SET_YOUR_MS_SERVICE> - #Required only if the message server service is not defined as sapms<SYSID> in /etc/services
sysnr = <SET_YOUR_SYS_NUMBER>
user = <SET_YOUR_USER>
##############################################################
# Enter your password OR your X509 SNC parameters
passwd = <SET_YOUR_PASSWORD>
snc_partnername = <SET_YOUR_SNC_PARTNER_NAME>
snc_lib = <SET_YOUR_SNC_LIBRARY_PATH>
x509cert = <SET_YOUR_X509_CERTIFICATE>
##############################################################
sysid = <SET_YOUR_SYSTEM_ID>
client = <SET_YOUR_CLIENT>
[Azure Credentials]
loganalyticswsid = <SET_YOUR_LOG_ANALYTICS_WORKSPACE_ID>
publickey = <SET_YOUR_PUBLIC_KEY>
[File Extraction ABAP]
osuser = <SET_YOUR_SAPADM_LIKE_USER>
##############################################################
# Enter your password OR your X509 SNC parameters
ospasswd = <SET_YOUR_SAPADM_PASS>
x509pkicert = <SET_YOUR_X509_PKI_CERTIFICATE>
##############################################################
appserver = <SET_YOUR_SAPCTRL_SERVER IP OR FQDN>
instance = <SET_YOUR_SAP_INSTANCE NUMBER, example 10>
abapseverity = <SET_ABAP_SEVERITY 0 = All logs ; 1 = Warning ; 2 = Error>
abaptz = <SET_ABAP_TZ --Use ONLY GMT FORMAT-- example - For OS Timezone = NZST use abaptz = GMT+12>
[File Extraction JAVA]
javaosuser = <SET_YOUR_JAVAADM_LIKE_USER>
##############################################################
# Enter your password OR your X509 SNC parameters
javaospasswd = <SET_YOUR_JAVAADM_PASS>
javax509pkicert = <SET_YOUR_X509_PKI_CERTIFICATE>
##############################################################
javaappserver = <SET_YOUR_JAVA_SAPCTRL_SERVER IP ADDRESS OR FQDN>
javainstance = <SET_YOUR_JAVA_SAP_INSTANCE for example 10>
javaseverity = <SET_JAVA_SEVERITY 0 = All logs ; 1 = Warning ; 2 = Error>
javatz = <SET_JAVA_TZ --Use ONLY GMT FORMAT-- example - For OS Timezone = NZST use javatz = GMT+12>
Define the SAP logs that are sent to Microsoft Sentinel
Add the following code to the Microsoft Sentinel solution for SAP® applications systemconfig.ini file to define the logs that are sent to Microsoft Sentinel.
For more information, see Microsoft Sentinel solution for SAP® applications solution logs reference (public preview).
##############################################################
# Enter True OR False for each log to send those logs to Microsoft Sentinel
[Logs Activation Status]
ABAPAuditLog = True
ABAPJobLog = True
ABAPSpoolLog = True
ABAPSpoolOutputLog = True
ABAPChangeDocsLog = True
ABAPAppLog = True
ABAPWorkflowLog = True
ABAPCRLog = True
ABAPTableDataLog = False
# ABAP SAP Control Logs - Retrieved by using SAP Conntrol interface and OS Login
ABAPFilesLogs = False
SysLog = False
ICM = False
WP = False
GW = False
# Java SAP Control Logs - Retrieved by using SAP Conntrol interface and OS Login
JAVAFilesLogs = False
##############################################################
SAL logs connector settings
Add the following code to the Microsoft Sentinel for SAP data connector systemconfig.ini file to define other settings for SAP logs ingested into Microsoft Sentinel.
For more information, see Perform an expert / custom SAP data connector installation.
##############################################################
[Connector Configuration]
extractuseremail = True
apiretry = True
auditlogforcexal = False
auditlogforcelegacyfiles = False
timechunk = 60
##############################################################
This section enables you to configure the following parameters:
| Parameter name | Description |
|---|---|
| extractuseremail | Determines whether user email addresses are included in audit logs. |
| apiretry | Determines whether API calls are retried as a failover mechanism. |
| auditlogforcexal | Determines whether the system forces the use of audit logs for non-SAL systems, such as SAP BASIS version 7.4. |
| auditlogforcelegacyfiles | Determines whether the system forces the use of audit logs with legacy system capabilities, such as from SAP BASIS version 7.4 with lower patch levels. |
| timechunk | Determines that the system waits a specific number of minutes as an interval between data extractions. Use this parameter if you have a large amount of data expected. For example, during the initial data load during your first 24 hours, you might want to have the data extraction running only every 30 minutes to give each data extraction enough time. In such cases, set this value to 30. |
Configuring an ABAP SAP Control instance
To ingest all ABAP logs into Microsoft Sentinel, including both NW RFC and SAP Control Web Service-based logs, configure the following ABAP SAP Control details:
| Setting | Description |
|---|---|
| javaappserver | Enter your SAP Control ABAP server host. For example: contoso-erp.appserver.com |
| javainstance | Enter your SAP Control ABAP instance number. For example: 00 |
| abaptz | Enter the time zone configured on your SAP Control ABAP server, in GMT format. For example: GMT+3 |
| abapseverity | Enter the lowest, inclusive, severity level for which you want to ingest ABAP logs into Microsoft Sentinel. Values include: - 0 = All logs - 1 = Warning - 2 = Error |
Configuring a Java SAP Control instance
To ingest SAP Control Web Service logs into Microsoft Sentinel, configure the following JAVA SAP Control instance details:
| Parameter | Description |
|---|---|
| javaappserver | Enter your SAP Control Java server host. For example: contoso-java.server.com |
| javainstance | Enter your SAP Control ABAP instance number. For example: 10 |
| javatz | Enter the time zone configured on your SAP Control Java server, in GMT format. For example: GMT+3 |
| javaseverity | Enter the lowest, inclusive, severity level for which you want to ingest Web Service logs into Microsoft Sentinel. Values include: - 0 = All logs - 1 = Warning - 2 = Error |
Configuring User Master data collection
To ingest tables directly from your SAP system with details about your users and role authorizations, configure your systemconfig.ini file with a True/False statement for each table.
For example:
[ABAP Table Selector]
USR01_FULL = True
USR02_FULL = True
USR02_INCREMENTAL = True
UST04_FULL = True
AGR_USERS_FULL = True
AGR_USERS_INCREMENTAL = True
USR21_FULL = True
AGR_1251_FULL = True
ADR6_FULL = True
AGR_TCODES_FULL = True
DEVACCESS_FULL = True
AGR_DEFINE_FULL = True
AGR_DEFINE_INCREMENTAL = True
AGR_PROF_FULL = True
PAHI_FULL = True
For more information, see Tables retrieved directly from SAP systems.
Next steps
After you have your SAP data connector installed, you can add the SAP-related security content.
For more information, see Deploy the SAP solution.
For more information, see:
- Deploy the Microsoft Sentinel solution for SAP® applications data connector with SNC
- Monitor the health of your SAP system
- Microsoft Sentinel solution for SAP® applications detailed SAP requirements
- Microsoft Sentinel solution for SAP® applications logs reference
- Microsoft Sentinel solution for SAP® applications: security content reference
- Troubleshooting your Microsoft Sentinel solution for SAP® applications deployment