ODBC Quick Start Workbench

Kourier Integrator Online Help

Data Warehouse ODBC 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 an ODBC 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 an ODBC export.

Here's the typical workflow for using the Workbench:

Analyze a selected ODBC 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 through 6 until complete.

Toolbar Commands

Toolbar Commands Help

	Click to perform analysis and data profiling on the selected ODBC table, or enter a new table 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 enter a schema name and SQL statement. 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 schema has been processed completely. Analyzing a schema after that has already been analyzed will overwrite all existing schema information that has been generated for the schema, including any revisions which were made in the schema editing process.
	Click to check-out the selected statement 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 statement 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 schema that is selected. The schema 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 schema. 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 schema and then return to the schemas' 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 schemas in the ODBC Quick Start Workbench with the selected status.
add	Click the Add command to add a new statement to the ODBC Quick Start Workbench and then automatically perform the Analyze command on that file.

File/Key Field

KT_ODBCSCHEMA/SCHEMA.ID

Files Analyzed Display Fields

Field Name	Description - Usage - Notes
	Selected file radio button. This is used to indicate which schema you want to use when performing the Quick Start command: Analyze, Check-In, Check-out, Generate Exports, and Delete.
Export Source	The Name of the ODBC schema.
Rows	Displays the number of rows that applied to the select statement.
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.