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.
|
|
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 when 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 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. |
 |
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
None.
Analyzing a file after it 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.
| 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. |
