This feature generates data schemas for ETL transformations.

Navigate to the ETL - Data Schemas menu option. 

The page opens in a new tab, as shown below. 

Create Data Schema.

Select the Actions > Create menu option to initiate. 

A configuration pop-up window appears. Enter a new name for the data schema. Select the checkbox for the designer canvas. Click the Create button to confirm. 

The data schema requires additional user input to complete. Select the CSV file type from the drop-down list. Select the CSV input file from the local folder. Click the Upload File button to confirm.   

Uploading the file will overwrite the current schema design. Click OK to continue. 

The data schema file is loaded onto the application server, and a confirmation message appears in the top-right corner, as shown below. 

The field name, data type, and format must be configured. Click the Add New Field button to add an empty row. Enter the field name (column title). Select the data type from the drop-down list (string, integer, double, decimal, datetime, time, or boolean). Enter the display format. Repeat the field additions to include all necessary columns. Click the Save Design button to confirm. A confirmation message appears in the top-right corner. The data schema is now available for use. 

Design Data Schema.

This function is used to modify an existing schema.  

Select the schema from the table list on the ETL Data Schema page, then click the Actions - Design menu option. 

The data schema is displayed on a new page. You may modify the data schema by uploading a new input file, changing field data types and formats, reordering the appearance by dragging and dropping line items, and removing unnecessary row items from the table. Click the Save Design button to confirm the changes. 

Copy Data Schema.

This function creates a copy of an existing schema.  

On the ETL Data Schema page, select the schema from the table list, then click the Actions > Copy menu option.  

A pop-up window appears. Enter a new name for the copy, then click the Copy button. 

A copy of the data schema is created, and a confirmation message appears in the top-right corner. 

Rename Data Schema.

This function renames an existing schema.  

On the ETL Data Schema page, select the schema from the table list, then click Actions > Rename.  

A pop-up window appears. Enter a new name for the copy, then click the Update button. 

The data schema is renamed, and a confirmation message appears in the top-right corner. 

Remove Data Schema.

This function permanently removes an existing schema. 

On the ETL Data Schema page, select the schema from the table list, then click Actions > Remove.  

A pop-up window appears. Click OK to confirm.

The data schema is removed, and a confirmation message appears in the top-right corner. 

Export - XML.

This function downloads the data schema as an XML file.  

Select the schema from the table list on the ETL Data Schema page, then click Export > XML. The XML file is generated and downloaded to the local folder. Using the Export-Import functions, you can move data schemas between FlowWright environments. 

Export - SQL.

This function downloads the data schema as an SQL file.  

Select the schema from the table list on the ETL Data Schema page, then click Export > SQL. The SQL file is generated and downloaded to the local folder. You can execute this SQL in SQL Server Management Studio to insert the data schema into the FlowWright target database. 

The SQL is included below for reference.

Import - XML.

This function imports the data schema as an XML file.  

Select the schema from the table list on the ETL Data Schema page, then click Import > XML.  

A pop-up window opens for configuration. Select the XML file from the local folder, then click the Import XML button. The data schema file is imported and overwrites the selected data schema item in the table list. 

After successfully importing the data schema, a confirmation message appears in the top-right corner.