Target Source Tables H

Description

Click to build the package and download active tables from the source. If the package already exists, the table is refreshed (i.e., data is downloaded from the source database). If the package does not exist, a package is immediately scheduled to be built and the table is refreshed. The Refresh icon is disabled for DBMoto® package types because the refresh is run by DBMoto® instead of by Collect.

Click to reset a running refresh. This process activates the Refresh icon and triggers batch job schedule to calculate new run dates for next scheduled refresh. Reset source if the download process backs up due to network problems.

Click to build a package to download active tables from the source.

Click to manually extract a copy of data from the source and load into the target.

Displays the database where tables are refreshed with source data.

Displays the database where data is refreshed from and stored in the target.

Displays table name in the source database.

Displays package type to refresh target table with source data. Default value is CranPort. Refer to Package Types for a description of each package type available.

NOTE: When the package type is CranPort package, the package name is hyperlinked to the CranPort package in Assemble in the view.

NOTE: If source has an SAPAPPSERVER connection type, only the following RFC package types are available in the Package Type list box:

• BOA RFC

• SAP Data Services using RFC

• SAP RFC

• SAP Text

If enabled, table is active. Only active tables are downloaded from the source during refresh. Default value is Active.

If enabled, package for table has been built. This setting cannot be updated from within Collect.

Displays amount of time (in seconds) it took for the table to download from the source. This field is protected and updated by Collect when the table refresh process completes.

Displays the Unit of Measure used for measure the duration.

Displays number of records in the table. This field is protected and updated by Collect when the table refresh process completes.

Displays order that tables are refreshed with source data and sorted on the page. Default value is 99999.

Displays date and time when the manual refresh completed.

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

Click to open the Table (Rule) page to register rules to table.

Click to open the Table (Indices) page to register indices to table.

Click to open the Tables page to view table data downloaded from source.

Description

Click to build a package to download active tables from the source.

Click to reset a running refresh. This process activates the Refresh icon and triggers batch job schedule to calculate new run dates for next scheduled refresh. Reset source if the download process backs up due to network problems.

Click to manually extract a copy of data from the source and load into the target.

Displays the target database where tables are refreshed with source data.

Displays the database where data is refreshed from and stored in the target.

Displays table in the source database.

If enabled, table is active. Only active tables are downloaded from the source during refresh. Default value is Active.

Displays information about table, e.g., data contained within table.

Description

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.

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

Displays the database’s schema for the table.

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

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

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, the default package name can be accepted, or it can be edited as needed

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.

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).  

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

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.

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

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

Description

Displays unique identifier of with the Platform job that ran the package.

Displays date and time when manual refresh completed.

Displays number of records in the table. This field is protected and updated by Collect when the table refresh process completes.

Displays number of records currently in the table. Ideally, this count is the same as Record Count.  If there is no primary key or unique index, this count may display zero but the table could have data.

Displays amount of time (in seconds) the table took to download from the source during the refresh process.

Displays last process that ran against table, e.g., build package, download or reset.

Click to open the Data Source Tables page to view, edit and delete details about the table.

Click to open the Download Metrics page to view and download metrics for table.

Click to open the Table Download Task List page to view job tasks used to download table.

Description

Click to delete all data in the table. Table can then be deactivated if it is no longer required.