Parse xml from database and index into elastic seasrch

Elastic Stack Logstash
1

Please help me out to read xml from database column and store indexes in elastic search by xml tag name

My XML looks like below.

<?xml version="1.0" encoding="UTF-8"?> 2019-01-10 01:56:43 100 1539912_029_07/01/2018 Entity 2019-01-10 01:56:43 01-10-2019 TEST_PID LARGEBATCH 100 7 1539912_029_07/01/2018 ISIS IN THE ISLAMIC SAHEL ISIS IN THE ISLAMIC SAHEL Sanctions
2

Please find the sample here[Unable to load xml file in logstash]

3

But my input is from DB as

input {
jdbc {
#input Configuration
jdbc_connection_string => "jdbc:oracle:thin:@oraasgtd37-scan.nam.nsroot.net:8889/CW1S"
jdbc_user => "ACT_WLF_RCM"
jdbc_password => "*****"
jdbc_driver_library => "I:\Jars\ojdbc6.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
statement => "select html_file_key from alert"

	}

}

where html_file_key is having my xml

4

ok, Also make sure path as below,

jdbc_driver_library => "I:/Jars/ojdbc6.jar"

Need to verify whether we can read xml from database directly

5

You got something?

6

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.