Versions Compared

Old Version 5

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

This step can be used to query file based repositories and database or the DI repository in combination with the Get repository names step.

Example (file based)

A sample titled 'Automatic Documentation Output - Generate Kettle HTML Documentation' is included in the <installation-directory>\data-integration\samples\transformations folder.

...

NOTE: some samples in the samples directory require that you setup sample data sets in advance of running them.  If you do not have that sample data set up, you may get errors running this sample indicating that a database in MySQL doesn't exist.  You can change the Get Files list to point to another location containing ktrs and kjbs that you want to generate documentation for.

Example (Repository based with METADATA)

The following example is attached:

Image Added

It will:

  • Gather a list of transformations and jobs from the repository
  • Returns the number of step and job entries and the XML representation (you can access any further METADATA from the job and transformation, this is only a simplified sample)

Configuration options

Option

Definition

Step name

Defines the name of the step as it will appear in the transformation graph.

File name field

Select the input field containing the name of the file you are generating documentation for.

File type field

Select the input field containing the type of file (transformation or job)

Target filename

Specify the target location and filename for the generated documentation.

Output type

Select the output type for the generated documentation (PDF, HTML, DOC, Excel, CSV, or METADATA)
Note: The output type METADATA returns a field called meta that is a serialized instance of the object depending on the object type, e.g. TransMeta or JobMeta.

Include the name?

Define whether or not to include the file name in the generated documentation.

Include the description?

Choose to include the description in the generated documentation (description can be modified by going to Edit->Settings).

Include the extended description?

Choose to include the extended description in the generated documentation (extended description can be modified by going to Edit->Settings).

Include the creation date and user?

Choose to include the creation date and user name for the creator in the generated documentation.

Include the modification date and user?

Choose to include the date of the last modification made to the file and user who modified it.

Include the image?

Choose to include the job or transformation graph in the generated documentation.

Include logging configuration details?

Choose to include a summary of the connections used for logging in the transformation or job.

Include the last execution result?

Choose to include a summary of the last execution results such as whether it completed successfully or ended in failure.