Splunk Dev

Can we write UNIX Shell script for Oracle database extract using sql query?

anantdeshpande
Path Finder

Hi,
Below article gives python script to extract database using SQL query. However can we write UNIX shell script instead Python Script?

https://docs.splunk.com/Documentation/Splunk/6.5.0/AdvancedDev/ScriptExample

Tags (1)
0 Karma

guarisma
Contributor

"You can use shell scripts, python scripts, Windows batch files, PowerShell, or any other utility that can format and stream the data that you want to index."
https://docs.splunk.com/Documentation/Splunk/6.5.0/AdvancedDev/ScriptedInputsIntro

Hope that helps 🙂

0 Karma

anantdeshpande
Path Finder

Thanks. Referred the same. Will try to implement incremental logic in UNIX shell script same as Python. Any document for shell script will help.

0 Karma

dmaislin_splunk
Splunk Employee
Splunk Employee

Why not just leverage the Splunk App for Database Connectivity to do the same?

https://splunkbase.splunk.com/app/2686/

0 Karma

anantdeshpande
Path Finder

There are some hardware resources issue for using heavy forwarder for DB2 connect. Thats why using script.

0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...