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:
Refer to the Moving MultiValue Data to SQL Server guide for more information.
|
|
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. The status will display as Analyzed once a file has been processed completely.
|
|
|
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 the Delete icon in the toolbar to delete the Quick Start Schema information related to the currently selected File Name.
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. |
|
|
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. |
KT_SCHEMA/File
|
Field Name |
Description - Usage - Notes |
|
|
Selected file radio button. This is used to indicate which File you want to use when performing the a Quick Start command: Analyze, Check-In, Check-out, Generate Exports, and Delete. |
|
File Name |
The Name of the U2 file |
|
Records |
Displays the number of 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, Checked-out, Generated. |
|
Last Updated |
This displays the last date/time the file was processed using one of the Quick Start commands. |
