{"id":39,"date":"2023-01-13T19:51:08","date_gmt":"2023-01-13T17:51:08","guid":{"rendered":"https:\/\/techltx.com\/?page_id=39"},"modified":"2023-07-08T12:06:00","modified_gmt":"2023-07-08T09:06:00","slug":"sap","status":"publish","type":"page","link":"https:\/\/techltx.com\/en\/sap\/","title":{"rendered":"SAP"},"content":{"rendered":"<ul class=\"wp-block-latest-posts__list wp-block-latest-posts\"><li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/techltx.com\/en\/sap\/bash-script-netcat-connection-sap-s-4hana-system\/2024\/05\/\">bash script for the NETCAT connection test to a SAP S\/4HANA system<\/a><div class=\"wp-block-latest-posts__post-excerpt\">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:\n\nConnection 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.\n\nLogging: The script logs the test results in two files: connectiontest.txt contains all test results, while connectiontest-failed.txt stores only failed connection attempts.\n\nNotification on Connection Failures: In case of a connection failure, the script sends an email notification to the specified email address.\n\nCleanup 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.\n\nEndless 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.\n\nTermination of nc Sessions: Upon completion of the script, it terminates all running nc sessions belonging to the current user.<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/techltx.com\/en\/sap\/sap-hana-native-storage-extension-with-partition-of-table-edid4\/2024\/04\/\">SAP HANA Native Storage Extension with Partition of table EDID4<\/a><div class=\"wp-block-latest-posts__post-excerpt\">HowTo: \n\nWhen a column is loaded, it is copied from persistence into SAP HANA column store memory.\n\nUnloads are table column displacements from column store memory.\n\nIn 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.\n\nHot Data: Used to store very critical data for fast &#038; real-time and analytical processing usually stored in DRAM [dynamic RAM], PMEM [Persistent Memory]\n\nWarm 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.\nCold Data:  Used to store data that is rarely accessed.\n\n\nSAP Native Storage Extension [NSE] &#8211;  SAP HANA Native Storage Extension is HANA\u2019s built-in warm storage solution. By default, in HANA 2.0 SP 04 &#038; in SAP HANA CLOUD NSE is enabled, there is no different action needed aside from implementing correct SQL\/DDL declarations.<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/techltx.com\/en\/sap\/sap-hana-devops-co-pilot-chatgpt\/2024\/02\/\">SAP HANA DevOps Co-Pilot<\/a><div class=\"wp-block-latest-posts__post-excerpt\">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\u00f6nnen Unternehmen die Performance der SAP HANA Datenbank signifikant verbessern, was zu schnelleren Berichterstattungen und einer effizienteren Entscheidungsfindung f\u00fchrte. Der gesamte Prozess wird durch die Automatisierung und die Expertise des Co-Pilots effizient und risikoarm.\n\nUm 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\u00fcnf Beispiele wie der SAP HANA DevOps Co-Pilot helfen kann:\n\nAdministration der SAP HANA Datenbank: Integration von LDAP in SAP HANA mit dem DevOps Co-Pilot.\nEntwicklung auf der SAP HANA Platform: Die Erstellung einer &#8220;Hello World&#8221; XSA-Anwendung in SAP HANA .\nPerformance Optimierung SAP HANA SQL: Optimierung der SQL-Performance durch Partitionierung in SAP HANA.\nIntegration auf der SAP HANA Platform: Einrichtung einer Remote Source und Anlegen virtueller Tabellen mit SAP HANA Smart Data Access (SDA).\nMachine Learning auf der SAP HANA Platform: Optimierung von Sicherungsbestand und optimaler Bestellmenge mit SAP HANA und Machine Learning.<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/techltx.com\/en\/sap\/sap-security-kritis-bsi\/2023\/07\/\">SAP Security and KRITIS Update May 2023<\/a><div class=\"wp-block-latest-posts__post-excerpt\">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.<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/techltx.com\/en\/sap\/sap-security-dsag-pruefleitfaden-s4hana\/2023\/07\/\">SAP S\/4HANA audit guide DSAG 2023<\/a><div class=\"wp-block-latest-posts__post-excerpt\">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.<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/techltx.com\/en\/sap\/sap-security-audit-log-sm20-data-leak\/2023\/07\/\">SAP Security Audit Log SM20 data leak detection<\/a><div class=\"wp-block-latest-posts__post-excerpt\">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.<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/techltx.com\/en\/sap\/nutzung-der-sap-enterprise-threat-detection-zur-verhinderung-von-datenlecks-eine-tesla-fallstudie\/2023\/06\/\">Using SAP Enterprise Threat Detection to Prevent Data Leaks: A Tesla Case Study<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Eine Fallstudio zu Tesla Datenleck und wie SAP ETD Unternehmen dabei helfen kann auf Sicherheitsbedrohungen zu erkennen und darauf zu reagieren.<\/div><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"content-type":"","_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-39","page","type-page","status-publish","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"BALTX","author_link":"https:\/\/techltx.com\/en\/author\/baltx-com\/"},"uagb_comment_info":0,"uagb_excerpt":null,"_links":{"self":[{"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/pages\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/comments?post=39"}],"version-history":[{"count":7,"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/pages\/39\/revisions"}],"predecessor-version":[{"id":434,"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/pages\/39\/revisions\/434"}],"wp:attachment":[{"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/media?parent=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}