I want to perform db connect between oracle and splunk. Please let me know how can we do that?
Regards,
Santosh
Hi santosh11,
if you're using Splunk Cloud, surely you're using at least two (or more) Heavy Forwarders to concentrate logs to send to Splunk Cloud.
So you can use a dedicated Heavy Forwarder to install DB-Connect App following the instructions in Splunk documentation https://docs.splunk.com/Documentation/DBX/3.1.4/DeployDBX/AboutSplunkDBConnect.
If you have few logs, you can use one of the Heavy Forwarders used as concentrators, but this depends on the volume of logs.
Using this Heavy Forwarder, you can access your Oracle DB Server and extract the data you need.
Bye.
Giuseppe
Hello Gcusello,
I have successfully pushed data from Oracle to Splunk cloud using Splunk DB connect. Now i want to push the data back. I.E. from Splunk index data to oracle db through DB connect.
I have pushed data to Oracle DB from Splunk DB connect which is in HF. But how will we do that from Splunk Cloud Index data?
Regards,
Santosh
Hey Santosh,
The best recommended solution is to connect the DB via HF. By this way you can eradicate below challenges
So its better to install DB Connect in your Local HF( As you usually configure in Splunk enterprise) and forward its data to the cloud.
Hope this helps.
,
Hello skrajkumar,
I have successfully pushed data from Oracle to Splunk cloud using Splunk DB connect via HF. Now i want to push the data back. I.E. from Splunk index data to oracle db through DB connect via HF.
I have pushed data to Oracle DB from Splunk DB connect which is in HF. But how will we do that from Splunk Cloud Index data?
Regards,
Santosh