This feature creates data schemas used in ETL transformations.

You must navigate from the ETL - Data Schemas menu option. 

The page is rendered on a new page as below. 

Create Data Schema

Select the Actions - Create menu option to initiate. 

A popup window is displayed for configuration. Provide a new name for the data schema. Select the checkbox for the designer canvas. Click the Create button to confirm. 

The data schema requires more user inputs 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.   

The file upload will overwrite the existing schema design. Click OK to continue. 

The data schema file is loaded to the application server, and a confirmation message is displayed in the top right-end corner, as below. 

The field names, data type, and format require configuration. Click the Add New Field button to insert an empty row. Provide the field name (column title). Select the data type from the drop-down list (string, integer, double, decimal, datetime, time, and boolean). Provide the format for representation. Repeat the field additions to include all/necessary columns. Click the Save Design button to confirm.  A confirmation message is displayed in the top right-end corner. The data schema will now be 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 and click on the Actions - Design menu option. 

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

Copy Data Schema

This function makes a copy of an existing schema.  

On the ETL Data Schema page, select the schema from the table list and click on the Actions—Copy menu option.  

A popup window is displayed. Provide a new name for the copy and click the Copy button. 

A copy of the data schema is created, and a confirmation message is displayed at the top right-end corner. 

Rename Data Schema

This function renames an existing schema.  

On the ETL Data Schema page, select the schema from the table list and click on the Actions—Rename menu option.  

A popup window is displayed. Provide a new name for the copy and click the Update button. 

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

Remove Data Schema

This function permanently removes an existing schema. 

On the ETL Data Schema page, select the schema from the table list and click on the Actions—Remove menu option.  

A popup window is displayed. Click OK to confirm the deletion. 

The data schema is removed, and a confirmation message is displayed at the top right-end 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 and click on the Export—XML menu option.  The XML file is generated and downloaded to the local folder. Using the Export-Import functions, you may 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 and click on the Export—SQL menu option.  The SQL file is generated and downloaded to the local folder. You may execute this SQL syntax in SQL Server Management Studio to insert the data schema in the FlowWright target database. 

The SQL content 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 and click on the Import—XML menu option.  

A popup window is displayed for configuration. Select the XML file from the local folder and 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 is displayed in the top right-end corner.