So i want to get security logs from SAP HANA database for that as of my research i am going to use JDBC with logstach the jdbc will query the HANA database and store logs in the logstash from logstash it will be sent to elastic after converting to JSON. So my question is that since i am new to this SAP kind of thing. Is this the right architecture that i am going to use the JDBC and Logstash for querying SAP HANA. If yes then can you please help me how can i do that and if no what are the other options. My major concern is that i will be querying SAP and it is very closed source. So how can it be happened.
Are SAP security logs stored in a table in the database in a way that you can query it using JDBC?
This is more related to SAP than to Logstash, if you can query those logs on a database, then you can use Logstash to get it, but you need to check this on some specific SAP forum.
It's been years since I had to get logs from SAP, but from my experience SAP logs, at least audit logs, are only accessible through SAP interface, I had to build a custom application to read the SAP audit logs byte by byte because the files do not have any line break.
I'm not sure if this is the same in SAP HANA or if anything changed, but you need to check with some SAP forum or SAP support.