How to Setup Data Sources in SAP IT Operations Analytics
Abstract
This page provides information about data integration in SAP IT Operations Analytics (SAP ITOA). The target is to provide a guideline how to connect and structure data sources.
General Information
SAP ITOA provides different integration technologies to ingest data sources. An abstract of examples is described in this blog.
In general SAP ITOA Adapter supports pull and push mechanism to receive data, process data and store data in SAP HANA database, where the SAP ITOA application is running.
SAP ITOA supports the following data integration technologies:
| TECHNOLOGY | METHOD | INFORMATION |
| Stream Log Files | Push | By example Syslog, Rsyslog, SNMP, etc… |
| SAP Host Agent | Pull | Access standard operating system metrics from SAP instances (SAP ABAP, SAP JAVA, SAP HANA, etc…). In addition SAP Host Agent can be installed in non SAP instances. |
| SAP ITOA Adapter | Pull | Access application data from SAP ABAP or SAP HANA |
| SAP SDA (*) | Pull | Access database content (e.g. master data information or CMDB) via remote connection or replication service (synchronize). |
| Import Files | Manual | By example upload master data information using CSV files |
Further details is described in the SAP ITOA administration manual
(*) Please check license for SAP HANA (SAP Smart Data Access usage)
General Approach
Identify desired data sources (examples).
Identity desired data content
| DATA SOURCE | DESCRIPTION |
| Syslog / Rsyslog | System and application information |
| SAP Host Agent | Operating system metrics (e.g. CPU, memory, storage, network, process, etc…) |
| SAP ITOA Adapter | Application and system logs from SAP ABAP and SAP HANA |
| SAP SDA | Any kind of information available in the desired database (typically master data information, CMDB, alerts, application, etc…) |
Connect data source with SAP ITOA (by example Syslog or Rsyslog)
If required extract information from streaming content using the Attribute Editor (example Nagios or Microsoft Active Directory).
Recommendation is to create a documentation for your data model.
Create dashboards (stories) and alerts using the Analytics Builder
FAQ’s
| QUESTION | ANSWER |
| Is it possible to install SAP ITOA Adapter on the same instance as SAP HANA? | For production environment the recommendation is to install SAP ITOA Adapter in a different instance |
| Collect data in one data container (bucket) or several data containers? | This depends to customer requirements, but typically in different data containers, because for security and / or organizational reasons. |
Further Information
| Content Type | Information |
| SAP Entry Page | https://www.sap.com/itoa |
| SAP Help Page | https://help.sap.com/itoa |