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!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...