Quick Start Workbench

Kourier Integrator Online Help

Data Warehouse Quick Start Workbench

Purpose

The Quick Start Workbench accelerates development of the Data Export Specifications used within Kourier Integrator to build a Microsoft SQL Server data warehouse. After analyzing a U2 file you are able to review and edit the generated schema, which will be used to automatically generate all related export(s) for the file. These exports are designed to create a normalized data warehouse from a multi-valued U2 file.

Here's the typical workflow for using the Workbench:

Analyze a selected U2 file.
Check Out the selected file for schema editing.
Edit the schema using Excel.
Check In the file and related schema.
Generate Exports for the selected file.
Review the generated exports.
Repeat Steps 2 through7 until complete.

Refer to the Moving MultiValue (MV) Data to a SQL Server Data Warehouse guide for more information.

Toolbar Commands

Toolbar Commands Help

	Click to perform analysis and data profiling on the selected U2 file, or enter a new file name to perform a new analysis and add to the Quick Start Workbench. The status will change to In-process while the file is being processed. When analyzing a file, you will be prompted to do the following: Enter a schema name Select a valid verb to perform the selection, such as SELECT or SSELECT. For UniData systems, ECLTYPE P or ECLTYPE U syntax verbs are available. Enter the name of the data file to use to select data records for exporting. Enter the name of the file that contains the dictionary items referenced in the select statement. Enter the selection criteria statement using standard U2 query syntax. This field may also contain substitution tags. You can re-analyze a file that has already been analyzed by selecting the Overwrite checkbox that appears in the Analyze File window. The status will display as Analyzed once a file has been processed completely. Analyzing a file after that has already been analyzed will overwrite all existing schema information that has been generated for the file, including any revisions which were made in the schema editing process.
	Click to check-out the selected file and open the associated Quick Start Schema file for viewing or editing. This will change the file status to Checked-out.
	Click to check-in the selected file and load the associated Quick Start Schema file that was generated when the file was checked-out. This will change the file status to Checked-in.
	Click the Generate Exports icon in the toolbar to generate the related Data Export Specifications and Service for the file that is selected. File must be checked-in before you can generate exports. This will change the file status to Generated.
	Click to compare information in all exports for an integration and selected schema name. It reports back information such as NotUsed and DiffDataType. Choosing this option causes a new column called "Comparison Exception" to be added to the corresponding spreadsheet.
	Click the Delete icon in the toolbar to delete the Quick Start Schema information related to the currently selected File Name. This action is immediate and you will not be prompted with a confirmation dialog. This process will delete the schema information that has been generated for the selected file and then return to the files analyzed listing.
	Click the Help balloon to open the help for this page.

Files Analyzed Display Commands

	The File Status filter defaults to (All). Select a file status from the list provided to display only the files in the Quick Start Workbench with the selected status.
add	Click the Add command to add a new U2 file to the Quick Start Workbench and then automatically perform the Analyze command on that file.

File/Key Field

KT_U2SCHEMA/SCHEMA.ID

Files Analyzed Display Fields

Field Name	Description - Usage - Notes
	Selected file radio button. This is used to indicate which File you want to use when performing the Quick Start command: Analyze, Check-In, Check-out, Generate Exports, Compare, and Delete.
Export Source	The Name of the U2 file
Rows	Displays the number of rows/records that were processed when the Analyze file command was last run.
Status	Displays the current status of the file within the Quick Start Workbench: Analyzed, Checked-in, In-Process, Select Failed, Checked-out, Generated.
Last Updated	This displays the last date/time the file was processed using one of the Quick Start commands.