CODEWITHSUNDEEP
kettlepentaho-data-integration
maxandsamfactor
maxandsamfactor

Reputation: 1

inheritance of pentaho log kettle.properties in sub transforms

I have setup to log Pentaho jobs and transformations to a database

This works fine provided I define every job and every transformation in its individual log settings dialogue.

I see that I can configure the kettle properties file to hold these values. However I can't get this to inherit autoamtically in a transformation when it is called by a job. I assume that if defined in properties it should just inherit and work.

Any ideas on what I am missing?

Thanks

(MS windows env with MS Sql server- we don't have Pentaho enterprise).

Upvotes: 0

Views: 524

Answers (2)

maxandsamfactor
maxandsamfactor

Reputation: 1

Ok so I have foound that provided I set the proerties file on the machine and then set each transformation by right clicking and setting each log to have the connection, then when I call the job it all logs correctly.

So you need the database connection in all transforms and you need to set this a sdefault in the logging tab.

I think this is right anyway unless someone else has a shorter cut

Upvotes: 0

Niraj
Niraj

Reputation: 106

You can do it by adding below entries in "kettle.properties" file.

kettle logging properties

KETTLE_TRANS_LOG_DB=

KETTLE_TRANS_LOG_SCHEMA=

KETTLE_TRANS_LOG_TABLE=etl_trans_log

KETTLE_JOB_LOG_DB=

KETTLE_JOB_LOG_SCHEMA=

KETTLE_JOB_LOG_TABLE=etl_job_log

Upvotes: 1

Related Questions