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 ...

Stay Connected: Your Guide to January Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...

[Puzzles] Solve, Learn, Repeat: Reprocessing XML into Fixed-Length Events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...