cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ask a Question
kgudapati
New Member
Member since: ‎12-11-2016
‎06-05-2020
Community Statistics
Posts 4
Solutions 0
Karma Given 0
Karma Received 0
Member Since ‎12-11-2016
View All

Splunk ODBC connection for SSIS package

by in Splunk Enterprise
‎05-23-2018 10:22 AM
‎05-23-2018 10:22 AM
Hi, The aim is to use splunk ODBC driver to connect to splunk from SQL Server using visual Studio (SSIS), run a search, export the results to a table in SQL Server. I was able to configure the ODBC connection. however when I try to run a Splunk query, I get the error as below. TITLE: Microsoft Visual Studio Error at Data Flow Task 1 [ODBC Source [1]]: Open Database Connectivity (ODBC) error occurred. state: '42000'. Native Error Code: 31480. [Splunk]SQLEngine syntax error near 'GK_Daily_Camera_Mac_Checkins<<< ??? >>>'. Can any one let me know a resolution? Thanks, Krishna. ... View more

Re: Automate: Execute a Splunk search and export t...

by in Reporting
‎12-12-2016 08:22 AM
‎12-12-2016 08:22 AM
Thank you for the instant response. I am a SQL/BI person, hence is challenged with coding. I did review the CURL "Remotely using REST API". Copule of Questions Is the Python example a working model? How can the Python code be executed and scheduled on a windows machine (sorry for being dumb here) Is there a working model where I can plug in my Splunk Search, and magically get the output in csv :).... I know its too much to ask for. Thanks in advance for the help. Krishna. ... View more

Re: Automate: Execute a Splunk search and export t...

by in Reporting
‎12-12-2016 08:10 AM
‎12-12-2016 08:10 AM
Thank you for the direction. I did try this option. However, looks like we do not have access to save or schedule searches 😞 . ... View more

Automate: Execute a Splunk search and export the r...

by in Reporting
‎12-11-2016 09:13 AM
‎12-11-2016 09:13 AM
Hi Experts, I'm a new bee to Splunk. and I am trying to find an automated way to execute a splunk search, export the results in a csv format to my Windows 7 VM or a share drive. The aim is to load the data to a SQL Server. With the Splunk set-up that we have, We cannot use DB-Connect. A few teams are using python script to execute and automate this process but I am not a linux or a python coder. Hence struggling to automate it. Can anyone please hep me on how to automate the process. Thanks, Krishna. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-05-2020 02:04 AM