topic Re: Has anyone integrated Splunk with Informatica and how was your experience? in Splunk Search

Has anyone integrated Splunk with Informatica and how was your experience?

muebel — Tue, 22 Jul 2014 19:14:49 GMT

Has anybody integrated Splunk with Informatica in any way? Bad/Good experiences?

Re: Has anyone integrated Splunk with Informatica and how was your experience?

stanwin — Wed, 25 Mar 2015 09:11:06 GMT

Hello Muebel

Firstly INFORMATICA writes outs logs as .bin files. SO ask them to change that ,there is a option that enabled informatica to write .log files as well.

The logs themself are different from when viewed in the INformatica GUI as the product formats & adds additional info there like timestamp, severity for each logger. The normal log seems to have lot of unnecessary info (not debug level). Plenty of SQL query logs etc with no timestamp for each logged statement.

My activity is still work in progress. I was hoping for some more info in the forums also..

Surprised there is no app from community yet on this 🙂

Re: Has anyone integrated Splunk with Informatica and how was your experience?

MikeBertelsen — Mon, 28 Sep 2020 20:17:16 GMT

I was offered this by another source. It did the trick for us.
use the ‘BREAK_ONLY_BEFORE’ Advanced setting with the REGEX pattern .*> [A-Z]+_[0-9]+

Re: Has anyone integrated Splunk with Informatica and how was your experience?

MikeBertelsen — Mon, 28 Sep 2020 20:17:19 GMT

This was while creating a source type which I called Informatica_Workflow_Monitor

Re: Has anyone integrated Splunk with Informatica and how was your experience?

vittal9892 — Tue, 08 Mar 2016 09:35:48 GMT

Dear Mike,

We are getting the following error while reading logs from informatica :-

"cannot concantenate str and "nonetype" objects

Any help here is highly appreciated.