Getting Data In

AS400 and Splunk Integration

sarahnazzar
Explorer

Hi Splunkers,

Is it feasible to collect data from a DB2/AS400 server using Splunk?

i.e. to collect required data which is stored in a database (DB2 Database) hosted on a AS400 server.

 

Thanks in Advance!

Cheers! 

 

Labels (1)
0 Karma

PickleRick
Ultra Champion

DB Connect (https://splunkbase.splunk.com/app/2686/) is supposed to be able to connect to DB2 database. I haven't tried this particular database myself but it's the general solution for RDBMS connectivity. You might have to fiddle a bit with particular JDBC configuration to make it work.

0 Karma

sarahnazzar
Explorer

Thank you for the response!

Yes, but I could see that DB Connect support DB2 only when it is hosted a Linux box but not AS400

From Splunk base https://splunkbase.splunk.com/app/2686/:

 Splunk DB Connect supports DB2/Linux, Informix, MemSQL, MySQL, AWS Aurora, Microsoft SQL Server, Oracle, PostgreSQL, AWS RedShift, SAP SQL Anywhere, Sybase ASE, Sybase IQ, and Teradata.

 

0 Karma

PickleRick
Ultra Champion

Disclaimer - I never used DB2 so I have no idea if there are or aren't any huge differences between differently hosted databases. But I'd test it anyway. DB Connect after all is just a client app for the database. If you can connect with the database client to a DB2 on Linux, why shouldn't you be able to connect to AS400 one?

Doesn't cost you more than a bit of your time to test it 😉

0 Karma

isoutamo
SplunkTrust
SplunkTrust

If I recall right, there could be something special with DB/2 on AS400/iSeries/OS400? There seems to be some instructions how to use/connect with jdbc on net. You should just use google to find those.

r. Ismo

0 Karma
Get Updates on the Splunk Community!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...