Statistics Setup window

Use the Statistics Setup window to configure the settings for gathering statistical data for the Transformation Statistics export connector. You can store statistical data either using a Microsoft SQL database or a Microsoft Access Database File. In addition, you can define a group value that is used to group the gathered data either according to the classification result or a defined index field.

For the Database the following settings are available:

Microsoft SQL Server

Select this setting and configure the displayed connection string to gather the statistical data as SQL database.

Microsoft Access Database File (OLE DB)

This setting is selected by default. If selected, the statistical information is stored as a Microsoft Access database (.mdb).

Path

The default path is set to C:\Statistics that you can change as needed by pressing the Browse button or typing the path you want to use.

For Group Label the following settings are available:

Index field

Select this setting and an index field from the drown-down list box to group the gathered statistical data for the selected index field.

Classification result

Select this setting to group the gathered statistical data for the classification results.

Define the number of days Cleanup Interval when the statistical data is refreshed and the "old" data is deleted from the database.