Packages H

Description

Displays the package name.

The naming convention for packages is #Database#%#Source#%, for example dswBRAZIL.stKNA1_QALegacyData_Customer.imp for an import or dswBRAZIL.stKNA1_QALegacyData_Customer.exp for an export.

Displays the Assemble data source to be used for source data.

Displays the source type. Options include:

• SQL Server
• Table
• ODBC
• Fixed File
• Delimited File
• Excel File

Displays the Assemble data source to be used for target data.

Displays the Target Type. Options include:

• SQL Server
• Table
• ODBC
• Fixed File
• Delimited File
• Excel File

Click to open the Source Columns page of the selected package.

Click to open the Target Columns page of the selected package.

Click to open the Package (Mapping) page which displays the selected package's column mapping.

Click to open the package summary page of the selected package.

Click to open the Packages (Run) page, from which the selected package can be executed.

Click to open the Log page, where the selected package's execution history, number of records, Time duration, etc. can be seen.

Description

Source Information

Displays the name of the table to extract data from. This name must be unique.

Target Information

Displays the name of the database table used as the target for this package. This name must be unique.

NOTE: If spaces or special characters are required in the table name, the name must be enclosed in square brackets ([ and ]).

If enabled, the Target Table already exists in the database.

Click to create the table in the target database in accordance with the target column specifications, and the column map.

Description

Displays the SQL command timeout used for database commands. This applies only to Assemble execution. It controls the time out for a database command when a CranPort package runs. Database commands include creating a table, truncating an existing table, selecting data and writing data. If the Time Out is not specified for a package, the Parameter Time Out value automatically defaults.

Displays the number of records moved to the target database in each transaction. The default batch size is 10,000.

This option is useful for dense datasets which can lead to performance degradation on the system running the package.

Displays the option for executing the package. The values are:

• Stop on Error – Execution will cease execution if an error is encountered.
• Continue On Error - Assemble will log the error, and then try to continue transferring data.

Displays which service queue will be used to process this package.

Source Options

Displays the field used to divide the package up into smaller execution segments or blank if no field is to be used. For example, if Source Segment Field is "Country", a package will be run for each country in the source query. In this way, the package can be multi-threaded to increase performance.

NOTE: For tables, it will break up the execution of the CranPort package based on whichever field in the table the user chooses.  This is an execution optimization option.

Displays the minimum percentage of the total records a segment must have to be run in its own thread. Segments that are below the threshold are run together.

NOTE: This field is used in conjunction with Source Segment Field and indicates the percentage of which a source segment can be its own partition. The default value is 5. If any of the source segment field values breakup is less than 5 percent of the total record set it will be included in a single segment reserved for other partitions that do not exceed this threshold.

When clicked, it opens a page with the first 15 records from the source.

Target Options

If enabled, records will be deleted from the target table before package execution. This may be used in conjunction with Target Delete Where Clause.

If Target Delete Where Clause is not blank and Target Delete Records is checked, the where clause will be used when deleting records from the target table. "WHERE" should not be entered.

Description

Source Information

Displays the SQL statement used to query the Source database.

Target Information

Displays the name of the database table used as the target for this package. This name must be unique.

NOTE: If spaces or special characters are required in the table name, the name must be enclosed in square brackets ([ and ]).

If enabled, the Target Table already exists in the database.

Click to create the table in the target database in accordance with the target column specifications, and the column map.

Description

Displays the SQL command timeout used for database commands. This applies only to Assemble execution. It controls the time out for a database command when a CranPort package runs. Database commands include creating a table, truncating an existing table, selecting data and writing data. If the Time Out is not specified for a package, the Parameter Time Out value automatically defaults.

Displays the number of records moved to the target database in each transaction. The default batch size is 10,000. This option is useful for dense datasets which can lead to performance degradation on the system running the package.

Displays the option for executing the package. The values are:

• Stop on Error – Execution will cease execution if an error is encountered.
• Continue On Error – Assemble will log the error, and then try to continue transferring data.

Displays which service queue will be used to process this package.

Source Options

When using SQL typed source, it will order the result set by this value. Order by should not be explicitly defined within the SQL itself. ORDER BY should also not be used in the value provided.

If Source Segment Field is not blank, it will be used to divide the package up into smaller execution segments. For example, if Source Segment Field is "Country", a package will be run for each country in the source query. In this way, the package can be multi-threaded to increase performance.

If Source Segment Field is used, the Segment Threshold specifies the minimum percentage of the total records a segment must have to be run in its own thread. Segments that are below the threshold are run together.

Displays a dataset of each segment value along with the record count. This is based on the Source Segment Field chosen for this package.

Target Options

If enabled, records will be deleted from the target table before package execution. This may be used in conjunction with Target Delete Where Clause.

If Target Delete Where Clause is not blank and Target Delete Records is checked, the where clause will be used when deleting records from the target table. "WHERE" should not be entered.

Description

Source Information

Displays thefile path specified by the Source Data Source.

Displays the subdirectory within the data source where the source file is located.

Displays the name of the file to be used for source data. This name will be appended to the data source file path and the Source Subdirectory if it exists, so it should not include drive specifications (i.e. c:\).

Click to upload a package source file to the web server form their local machine.

If enabled, the first row in the source file will be interpreted as a column header and not imported as data.

If populated, allows for skipping unnecessary data at the beginning of the Source file. The default is 1.

Displays the delimiter used to parse the Source file.

Target Information

Displays the name of the database table used as the target for this package. This name must be unique.

NOTE: If spaces or special characters are required in the table name, the name must be enclosed in square brackets ([ and ]).

If enabled, the Target Table already exists in the database.

Click to create the table in the target database in accordance with the target column specifications, and the column map.

Description

Displays the SQL command timeout used for database commands. This applies only to Assemble execution. It controls the time out for a database command when a CranPort package runs. Database commands include creating a table, truncating an existing table, selecting data and writing data. If the Time Out is not specified for a package, the Parameter Time Out value automatically defaults.

Displays the number of records moved to the target database in each transaction. The default batch size is 10,000.

This option is useful for dense datasets which can lead to performance degradation on the system running the package.

Displays the option for executing the package. The values are:

• Stop on Error – Execution will cease execution if an error is encountered.
• Continue On Error - Assemble will log the error, and then try to continue transferring data.

Displays which service queue will be used to process this package.

Source Options

Displays the encoding of the source file. Allows text files with different character sets to be imported.

Determines the way consecutive delimiters are handled. For instance, if this value is checked, a line reading "A,,B" will be split into 2 columns. . If unchecked (default behavior) the line will be split into 3.

If specified, it is stripped from the Source data file. For example A "B" C will be exported as A B C, if " is specified as the Source Text Qualifier.

If checked, the source file will be deleted after the package completes a successful execution. If the package errors they will see it as failed in the log for that package. Their Service light will also turn Yellow (If it’s not already) to indicate there was a failed job.

Target Options

If enabled, records will be deleted from the target table before package execution. This may be used in conjunction with Target Delete Where Clause.

If Target Delete Where Clause is not blank and Target Delete Records is checked, the where clause will be used when deleting records from the target table. "WHERE" should not be entered.

Description

Source Information

Displays thefile path specified by the Source Data Source.

Displays the subdirectory of the data source where the source file is located.

Displays the name of the file to be used for source data. This name will be appended to the data source file path, so it should not include drive specifications (i.e. c:\).

Click to upload a package source file to the web server form their local machine.

If checked, the first row in the source file will be interpreted as a column header and not imported as data.

If populated, allows for skipping unnecessary data at the beginning of the Source file. The default is 1.

Displays the delimiter used to parse the Source file.

Target Information

Displays the name of the database table used as the target for this package. This name must be unique.

NOTE: If spaces or special characters are required in the table name, the name must be enclosed in square brackets ([ and ]).

If enabled, the Target Table already exists in the database.

Click to create the table in the target database in accordance with the target column specifications, and the column map.

Description

Displays the SQL command timeout used for database commands. This applies only to Assemble execution. It controls the time out for a database command when a CranPort package runs. Database commands include creating a table, truncating an existing table, selecting data and writing data. If the Time Out is not specified for a package, the Parameter Time Out value automatically defaults.

Displays the number of records moved to the target database in each transaction. The default batch size is 10,000. This option is useful for dense datasets which can lead to performance degradation on the system running the package.

Displays options for executing package?

Values are:

• Stop on Error - Assemble will cease execution if an error is encountered.
• Continue On Error - Assemble will log the error, and then try to continue transferring data.

Displays which service queue will be used to process this package.

Source Options

Displays the name of the Excel worksheet containing the data to be imported.

If enabled, empty rows will be skipped, meaning empty records will not be written to the target.

If enabled, the source file will be deleted after the package completes a successful execution.

Target Options

If enabled, records will be deleted from the target table before package execution. This may be used in conjunction with Target Delete Where Clause.

If Target Delete Where Clause is not blank and Target Delete Records is checked, the where clause will be used when deleting records from the target table. "WHERE" should not be entered.

Description

Source Information

Displays the file path specified by the Source Data Source.

Displays the subdirectory of the data source where the source file is located.

Displays the name of the file to be used for source data. This name will be appended to the data source file path, so it should not include drive specifications (i.e. c:\).

Click to upload a package source file to the web server form their local machine.

If enabled, the first row in the source file will be interpreted as a column header and not imported as data.

If populated, allows for skipping unnecessary data at the beginning of the Source file. The default is 1.

Displays the delimiter used to parse the Source file.

Target Information

Displays the name of the database table used as the target for this package. This name must be unique.

NOTE: If spaces or special characters are required in the table name, the name must be enclosed in square brackets ([ and ]).

If enabled, the Target Table already exists in the database.

Click to create the table in the target database in accordance with the target column specifications, and the column map.

Description

Displays the SQL command timeout used for database commands. This applies only to Assemble execution. It controls the time out for a database command when a CranPort package runs. Database commands include creating a table, truncating an existing table, selecting data and writing data. If the Time Out is not specified for a package, the Parameter Time Out value automatically defaults.

Displays the number of records moved to the target database in each transaction. The default batch size is 10,000.

This option is useful for dense datasets which can lead to performance degradation on the system running the package.

Displays the option for executing the package. The values are:

• Stop on Error – Execution will cease execution if an error is encountered.
• Continue On Error - Assemble will log the error, and then try to continue transferring data.

Displays which service queue will be used to process this package.

Source Options

Displays the encoding of the source file. Allows text files with different character sets to be imported.

If enabled, the source file will be deleted after the package completes a successful execution.

Target Options

If enabled, records will be deleted from the target table before package execution. This may be used in conjunction with Target Delete Where Clause.

If Target Delete Where Clause is not blank and Target Delete Records is checked, the where clause will be used when deleting records from the target table. "WHERE" should not be entered.

Description

Source Information

Displays the file path specified by the Source Data Source.

Displays the subdirectory of the data source where the source file is located.

Displays the name of the file to be used for source data. This name will be appended to the data source file path, so it should not include drive specifications (i.e. c:\).

Click to upload a package source file to the web server form their local machine.

If enabled, the first row in the source file will be interpreted as a column header and not imported as data.

If populated, allows for skipping unnecessary data at the beginning of the Source file. The default is 1.

Displays the delimiter used to parse the Source file.

Target Information

Displays the name of the database table used as the target for this package. This name must be unique.

NOTE: If spaces or special characters are required in the table name, the name must be enclosed in square brackets ([ and ]).

If enabled, the Target Table already exists in the database.

Click to create the table in the target database in accordance with the target column specifications, and the column map.

Description

Displays the SQL command timeout used for database commands. This applies only to Assemble execution. It controls the time out for a database command when a CranPort package runs. Database commands include creating a table, truncating an existing table, selecting data and writing data. If the Time Out is not specified for a package, the Parameter Time Out value automatically defaults.

Displays the number of records moved to the target database in each transaction. The default batch size is 10,000. This option is useful for dense datasets which can lead to performance degradation on the system running the package.

Displays the option for executing the package. The values are:

• Stop on Error – Execution will cease execution if an error is encountered.
• Continue On Error - Assemble will log the error, and then try to continue transferring data.

Displays which service queue will be used to process this package.

Source Options

Displays the encoding of the source file. Allows text files with different character sets to be imported.

If enabled, the source file will be deleted after the package completes a successful execution.

Target Options

If enabled, records will be deleted from the target table before package execution. This may be used in conjunction with Target Delete Where Clause.

If Target Delete Where Clause is not blank and Target Delete Records is checked, the where clause will be used when deleting records from the target table. "WHERE" should not be entered.