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!

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...