Description

Application Information

Displays current release version of the component, Collect.

Displays date when the component version was released.

Filters

Displays prefix used for action stored procedures. Default value is asp%.

Displays prefix used for rule stored procedures. Default value is ir%.

Connection Info

Displays name of server where application resides

Displays time, in milliseconds, for an idle transaction in DB2. Default value is 180.

Displays time, in milliseconds, for an idle transaction in Oracle. Default value is 180.

Displays time, in milliseconds, for an idle transaction in SQL Server. Default value is 180.

Description

Job Settings

Displays queue used for table downloads when a Collect service is used to distribute the load on the server. Default value is General.

Displays number of times the download process is recycled. If the job fails, the table is recycled into the job queue at the end of the current cycle. This feature is designed to monitor network problems. If set to 0, the job isn’t recycled. Default value is 3.

Displays limit (in seconds) for long-running tables. These tables display in the Duration Warning List report, which is available in Collect under Reports > Duration Warning List.

Displays a value that captures run and duration times for data downloads and conversions.

Values are:

• No Metrics – Disables metric process
• Build Job Metrics – Stores duration for the job to complete all events
• Build Event and Job Metrics – Stores duration of each event and total for the job

Default value is Build Job Metrics.

Displays number of days to store Table Download Runtime processing data. Default value is 1 day.

Misc. Settings

If checked, Collect service jobs run in the background. Default is Enabled.

If checked, the ability to log in to the source system is tested before the current data is deleted and before the creation of the download. Default value is Enabled.

Displays maximum value of how large the DebugLog table can get before logging for Collect turns off.

Displays the language option for text data in the database.

Values are: General Latin Case-insensitive, General Latin Case-sensitive

Default value is General Latin Case-insensitive, which means the collation uses Latin characters and is case-insensitive.

Display the threshold for the number of sources that can be registered for the Record Count on the Tables page’s Vertical View to be calculated.

If the number of sources registered exceeds the threshold set by this parameter, no Record Count is calculated and the Record Count field on the Tables page’s Vertical View is 0.

Description

General Package Settings

Displays default setting for building tables. Default value is CranPort.

Displays characters appended to the package name. Default value is imp.

SSIS Settings

Displays number of milliseconds to pause before building the next package. Parameter is used to slow down the build process. Default value is 100 milliseconds (1 second)

Displays number of records committed in a single SQL Server Transaction when running table downloads. Default value is 1000.

Displays folder on the component server that stores SSIS packages.

RFC Settings

Displays option for RFC name.

Values are:

• NAMESPACE - uses the namespace version of the BOA Function Module
• NONNAMESPACE – uses non-namespace version of the BOA Function Module.

NOTE: The namespace concept describes how customers and partners name their development objects to avoid overlapping when SAP software is upgraded. BDC Function Modules and BAPI Function Modules can be namespace or non-namespace objects.

Default value is NONNAMESPACE.

Displays type of RFC used.

Values are:

• SAP RFC – Uses SAP’s Remote Function Call
• BOA RFC – Uses custom Remote Function Call developed by BackOffice
• BOA RFC using Options – Uses custom Remote Function Call developed by BackOffice with options applied as a Where Clause to limit data read from tables

Default value is BOA RFC.

Enter number of records to pull per block from SAP. Default value is 5000.

Description

Datastore Settings

Displays the format for a Datastore object created for a source connection when building a SAP Data Services package. Default value is #SOURCE#.

Displays the format for a Datastore object created for a target connection when building an SAP Data Services package. Default value is #TARGET#.

Displays the format for a Datastore object created for a collect connection when building a SAP Data Services package. Default value is dgDataGarage.

Download Job Settings

Displays name format for the job that executed a download of source table to a target table. Default value is #SOURCE#_#TARGET#_#SOURCETABLE#_imp.

Displays the format for the Data Flow object in a Download job. Default value is DF_#SOURCE#_#TARGET#_#SOURCETABLE#.

Displays the format for the source table display name in a Data Flow object of a Download job. Default value is #SOURCETABLE#_#SOURCE#.

Displays the format for the target table display name in a Data Flow object of a Download job. Default value is #TARGETTABLE#_#TARGET#.

Displays the format of the source table description in a Download job. Default value is #SOURCETABLE# table from #SOURCE#.

Displays the format of the target table description in a Download job. Default value is #TARGETTABLE# table from #TARGET#.

Displays the format of the Schema Name object in a Download job. Default value is TFM_#TARGETTABLE#.

Query Job Settings

Displays name format for the job that executes a schema query on a Datastore. Default value is Collect staging table dg#JOBTYPE#Query_#SOURCE#.

Displays name format for a DataFlow object in a Query job. Default value is DF_dg#JOBTYPE#Query_#SOURCE#.

Displays name format for a SQLQuery object in a Query job. Default value is SQL_dg#JOBTYPE#Query_#SOURCE#.

Displays format for the target table display name in a Data Flow of a Query job. Default value is #QUERYJOBTARGETTABLE#(Collect).

Displays format of the target table description in a Query job. Default value is Collect staging table #QUERYJOBTARGETTABLE#.

Description

Application Settings

Displays the server name where DBMoto® is installed on.

Displays number of tables in each monitoring group – to be determined by the client. Groups are table sets that share the same log reader thread. It is more efficient to check for changes once for a group of tables than to log in for each table individually. Also, the changes for all the tables in a group are processed in the same order as they appear in the transaction log. This is useful when there are referential constrains between tables. Each group runs in a single thread mode with one table refreshing at a time. Default value is 50.

Displays limit of simultaneous connections to the source system. Default value is 8.

Displays number of seconds between checking the system log for changes. Recommended value is no less than 60 seconds. Default value is 300 seconds.

If enabled, DBMoto® Replicator is started after each build package process completes. If disabled, DBMoto® Replicator must be manually restarted in the DBMoto® Management Center on the application server. Default value is Disabled.

If disabled, the DBMoto® packages do not automatically run after the build process is complete. The package stays in a Replication Status of Disabled and an Initialization Status of Pending. The user must manually enable the replication in the DBMoto® Management Center.

If enabled, the DBMoto® packages automatically start executing after the build process completes.

Displays date when all tables without rules will have boaDBMotoInd set back to zero and daily change count insert into Metric log. Default value is 11:00 pm.

Description

Retention Date Notification

Displays the number of days before data is purged (the retention expiration date) that a warning workflow email is sent to the Data Controller.

The email contains a list of objects whose data will be purged and a link to access the objects in the DSP.

The DSP sends this email daily when an object is scheduled to be purged during this time.

Click to open the Collect Retention Expiration Email page to configure the subject line and body of the workflow email sent when an object’s retention date is within the number of days set in the Retention Expiration Date Notification field.

Email Contents

Displays email address of account that sends workflow emails.

Displays text for body of failed table workflow emails.

Displays the header definition for failed table workflow emails.

Displays text for body of summary workflow emails.

Displays table header row in summary workflow emails.

Displays the row definition for summary workflow emails.