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

[anantdeshpande]

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

[guarisma]

"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 🙂

[anantdeshpande]

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

[dmaislin_splunk]

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

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

[anantdeshpande]

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