FlowWright's ETL Data Schema Designer fits within its ETL (Extract, Transform, Load) functionality: it defines the structure of the data an ETL process uses, including the fields, their data types, and how data is represented as it moves between systems.

For a FlowWright ETL workflow, the schema matters because it sets the expected data structure that subsequent steps must read, transform, validate, or load.

The key distinction is that a data schema defines the data structure, while the ETL definition defines the processing logic that operates on that data.

Navigate to the ETL > Data Schema page. 

In this example, the ETL Data Schema page displays existing schema definitions. Use the Search text box to narrow down the results. 

Select the Actions menu to access “Create, Design, Copy, Rename, and Remove” features.  

Select the Export menu to access “XML and SQL” features.  

Select the Import menu to access the “XML” feature.  

Actions - Create.

Select the Actions - Create menu option to initiate. 

A configuration pop-up window is displayed. Enter a new name for the data schema. Select the Designer Canvas checkbox. Click Create 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 application server loads the data schema file, and a confirmation message appears in the top-right corner, as shown in the image below. 

Configure the field name, data type, and format. Click the “Add New Field” button to insert an empty row. Enter the field name (column title). Select the data type from the drop-down list (string, integer, double, decimal, datetime, time, and boolean). Enter the format for representation. 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. 

Actions - Design.

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 line items by dragging and dropping them, and removing unnecessary rows from the table. Click the “Save Design” button to confirm the changes. 

Actions - Copy.

This function is used to create a copy of the data schema.  

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

A pop-up window is displayed for configuration. Provide a new name and click the “Copy” button to confirm. 

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

Actions - Rename.

This function is used to rename the data schema.  

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

A configuration pop-up window is displayed. Enter a new name, then click the “Update” button to confirm. 

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