Tables H

Tables V (All Tabs)

Use this page to:

NOTE: Bulk Execution has been enabled on this page. Refer to Use Bulk Execution for more information.

NOTE: To receive a workflow email that a table download has failed in Collect, a user must be assigned to a security role that has the Collect WebApp group WorkFlowFailureAll or WorkFlowFaiureByTargetAccess assigned. Refer to Set Security in System Administration for more information.

To access this page:

  1. Click Collect > Targets in the Navigation pane.
  2. Click the Sources icon for a target.
  3. Click the Tables icon for a source.

Tables V (All Tabs)

Tables H

Use this page to:

This page contains the following tabs:

General tab

Advanced Settings tab

Field

Description

Table Rename

Displays the table name of the renamed table in target database. New table name must contain [TableName]. At run time, [TableName] is replaced with processing table name.

Where Clause Override

Displays a Where Clause that is used to limit data downloaded during a refresh process.

Table Schema Owner

Displays the database’s schema for the table.

NextRun

Displays next date and time when the refresh process is scheduled to run.

Package Type

Displays package type to refresh the target table with source data. Default value is CranPort.

Package Name

Displays name of package that refreshes target table with source data.

NOTE: The package name is set automatically and displays after the package is built for the package types CranPort, SSIS, or Data Services. The package must be manually built and the package name must be entered into Collect for package types ManualCranPort, ManualSSIS or Manual Data Services.

NOTE: The package name must follow the naming convention #Database#%#Source#%. Refer to Create Packages for more information.

NOTE: For Manual Data Services package types, select from the list of available jobs in the Data Services Repository assigned to the target on the Targets page’s Vertical View.

Schedule ID

Displays schedule for when target tables are refreshed with source data. Options are controlled in Common > Configuration > Schedules. Default value is Use Source Schedule setting. No Table Override Requested.

Schedule Group

Displays schedule to build packages, refresh or filter on tables in a group. Schedule Groups are managed in Configuration > Schedule Groups. Default value is No Group.

NOTE: If building a group with a DBMoto® package the following applies: 
If Schedule Group is set to NO GROUP, both Download and Mirror package will be built as an individual replication in DBMoto®. 
If Schedule Group is set to AUTO and if it is a Download package, the replication will be part of a group named <GroupPrefix>_Downloads. Otherwise, if it is a Mirror package the replication will be part of a group called <GroupPrefix>_<number> where number is an incremental value to count the number of groups. Groups cannot contain more than <Group_Size> replications. 
If Schedule Group is set to “existing group name” with no restriction to the <Group_Size> parameter the replication is built into that group. 

NOTE: The Replication Mode must be consistent with the Replication Group Mode (e.g a download package cannot be grouped with a mirror package). 

Synchronous

If enabled, packages for Data Services jobs execute synchronously.

If disabled, packages for Data Services jobs execute asynchronously.

With synchronous execution, the build package jobs respect the queue and wait until jobs are finished before starting another job.

This option applies to the Data Services Package Types.

Schedule Single Thread

If enabled, table is downloaded from the source in a queue with all other single-threaded tables. Default value is Disabled.

Pooled Table Name

Displays name of SAP pooled table. Collect automatically changes the download RFC for pooled tables (i.e., SAP tables that store a list of tables, for example, ATAB stores 200 tables within a single table). Refer to SAP documentation for more information about pooled tables.

Rfc Records Per Call

Displays number of records returned in a single block for Collect background process to parse and insert into database. Default value is 5000.

Encrypted Columns

Click to open the Target Source Table Column Encryption page to edit column encryption for the table.

Boomi

Boomi Process

Displays the name of the Boomi Process that runs when the Target Source is refreshed.

NOTE: A Boomi Process must be selected for each table.

NOTE: This field only displays if the source is an IG Universal Connect data source.

General Information tab

Action tab

Use this tab to purge data for tables.
Field Description
Truncate Table Click to delete all data in the table. Table can then be deactivated if it is no longer required.
Options Click to open the Table (Rfc Options)page to configure RFC options used by RFC download process. The icon  is only active if Package Type = BOA RFC using Options.

Data Protection tab

Use this tab to: