Familiarisation with the User Interface

Data Models

Overview

This section will help to familiarize you with the layout on the Data Models page of the DataChannel Console. A data model determines the fields, tables that will be fetched from the stored repository to create and map the schema in the destination web application. Thus, the data model will be the script that ensures that the correct data is fetched and moved to the desired destination.

data models page
  1. You can access the Data Models page by clicking on the Data Models Tab which lies on the sidebar, right below the Data Explorer Tab.

  2. The search box, located below the Top Banner, inside the Data Models page allows you to quickly find a specific Data Model created by you.

  3. The Data Models List pane displays a Table with the details of all the Data Models created by you.

  4. The icons in the actions column of the Table allow you to Delete/Edit a Data Model.

  5. Navigating between different pages of the Data Model List pane is possible through the page numbers on the navigation bar, near the bottom right corner of the pane.

  6. The Rows per page dropdown located on the top right part of the Main UI Screen allows you to select the number of rows visible on one page of the Data Models List pane.

  7. The Create New button, located below the Top Banner, on the top right corner of the Main UI Screen, allows you to create a new Data Model for applying to your Data in the Data Warehouse.

Creating a New Data Model

  1. Go to the Data Models page and click on the Create New button to create a new Data Model for applying to your data in the data warehouse. Make sure that you have added a data warehouse before attempting to create a Data Model.

  2. In the fields that appear on the screen, give a name to the Data Model and Select a Data Warehouse to which you want to apply the Data Model. Enter the Model Definition (SQL Query) that you wish to execute to fetch the required fields. Validate the SQL and don’t forget to click the Add Model button.

data models page2

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.