- bash script for the NETCAT connection test to a SAP S/4HANA system
The script is useful for automated monitoring of SAP system connectivity and logging connection events, making it ideal for system administrators to ensure the availability and integrity of their SAP systems. The Bash script checks the connection to a MessageServer of a SAP system instance. Here is a summary of its functionalities:
Connection Test: The script tests the nc connection to a MessageServer of a SAP system instance. It utilizes the check_connection function to perform the connection check.
Logging: The script logs the test results in two files: connectiontest.txt contains all test results, while connectiontest-failed.txt stores only failed connection attempts.
Notification on Connection Failures: In case of a connection failure, the script sends an email notification to the specified email address.
Cleanup of Old Entries: The script deletes old timestamps from the connectiontest.txt log file after 10 days to maintain file cleanliness and save storage space.
Endless Loop for Periodic Testing: The script includes a commented-out endless loop that performs connection tests at regular intervals. This feature can be enabled to continuously monitor the connection. It is recommended to set up a cronjob for this purpose.
Termination of nc Sessions: Upon completion of the script, it terminates all running nc sessions belonging to the current user.
- SAP HANA Native Storage Extension with Partition of table EDID4
HowTo:
When a column is loaded, it is copied from persistence into SAP HANA column store memory.
Unloads are table column displacements from column store memory.
In this SAP Note we focus on loads and unloads of columns in column store. Tables in row store are typically loaded during startup and remain in memory permanently.
Hot Data: Used to store very critical data for fast & real-time and analytical processing usually stored in DRAM [dynamic RAM], PMEM [Persistent Memory]
Warm Data: Used to store data that are not frequently used and need not reside continuously in SAP HANA memory. NSE manages this data as an expanded disk. Query performance on warm data might be reduced compared to hot data.
Cold Data: Used to store data that is rarely accessed.
SAP Native Storage Extension [NSE] – SAP HANA Native Storage Extension is HANA’s built-in warm storage solution. By default, in HANA 2.0 SP 04 & in SAP HANA CLOUD NSE is enabled, there is no different action needed aside from implementing correct SQL/DDL declarations.
- SAP HANA DevOps Co-Pilot
Neues OpenAI GPT Tool mit SAP Datenbank-Fokus: Der SAP HANA DevOps Co-Pilot wurde trainiert, um die Entwicklung, den Betrieb und die Verwaltung von SAP HANA zu vereinfachen. Dank des SAP HANA DevOps Co-Pilot können Unternehmen die Performance der SAP HANA Datenbank signifikant verbessern, was zu schnelleren Berichterstattungen und einer effizienteren Entscheidungsfindung führte. Der gesamte Prozess wird durch die Automatisierung und die Expertise des Co-Pilots effizient und risikoarm.
Um den SAP HANA DevOps Co-Pilot selbst zu testen ist lediglich ein OpenAI Account erforderlich. Dieser Artikel zeigt unterschiedliche Themengebiete der Datenbank-Administration und liefert fünf Beispiele wie der SAP HANA DevOps Co-Pilot helfen kann:
Administration der SAP HANA Datenbank: Integration von LDAP in SAP HANA mit dem DevOps Co-Pilot.
Entwicklung auf der SAP HANA Platform: Die Erstellung einer “Hello World” XSA-Anwendung in SAP HANA .
Performance Optimierung SAP HANA SQL: Optimierung der SQL-Performance durch Partitionierung in SAP HANA.
Integration auf der SAP HANA Platform: Einrichtung einer Remote Source und Anlegen virtueller Tabellen mit SAP HANA Smart Data Access (SDA).
Machine Learning auf der SAP HANA Platform: Optimierung von Sicherungsbestand und optimaler Bestellmenge mit SAP HANA und Machine Learning.
- SAP Security and KRITIS Update May 2023
SAP Security in focus of new legislations, particularly in regards to KRITIS (Critical Infrastructures), have raised the level of mandatory security precautions that companies must take. These changes are both a challenge and an opportunity to improve the security and resilience of IT systems. At the same time, they ensure that companies serving KRITIS sectors are better protected against potential cyber attacks. Given the constantly evolving threat landscape, it is crucial for SAP operators to stay informed about the latest legislative changes and take appropriate measures to adapt their IT infrastructures.
- SAP S/4HANA audit guide DSAG 2023
The DSAG SAP audit guideline, updated in 2023, supports IT auditors in the selection and evaluation of control objectives. The test guide comprises 335 pages and focuses on S4/HANA OnPremise and S4/HANA Cloud. The article deals with the control objectives of the audit guide and summarizes the topics of the working group on auditing and risk management.
- SAP Security Audit Log SM20 data leak detection
The SAP Security Audit Log (transaction SM20) can record specific security-related activities and provides detailed insights into the NetWeaver Application Server ABAP. This article shows how it works and configuration options so that data leaks can be detected using logging. In addition, the article shows the limits of SM20 and explains what more you can expect from a SIEM tool like SAP ETD Enterprise Threat Detection.
- Using SAP Enterprise Threat Detection to Prevent Data Leaks: A Tesla Case Study
Eine Fallstudio zu Tesla Datenleck und wie SAP ETD Unternehmen dabei helfen kann auf Sicherheitsbedrohungen zu erkennen und darauf zu reagieren.