Processes for Automation: Virtual Data Mart creation / deletion

This article explains how to create and delete Virtual Data Marts (VDMs) in Zetaris.

Steps to Create a Virtual Data Mart

  1. Login to Zetaris

  2. Go to the Virtual Data Mart tab

 VDMImage1


3.   On the left pane, Click on the plus button (+) next to Data Marts.

VDMImage2  

4.   A pop-up will appear. Fill in the details and click the "Create" button

VDMImage3
 
5.   Once the create button is clicked, the middle pane will be available for dragging and dropping data sources needed for your Data Mart. If there are links between tables it also possible to join them. (This is not a mandatory step.)
VDMImage4

6.   Once all the tables/data sources are dragged and dropped in the middle pane click on "Save changes."

7.   This will save your data mart for future use.

 

Steps to Delete a Virtual Data Mart

  1. Login to Zetaris

  2. Go to the Virtual Data Mart tab

 VDMImage5
 3.   On the left pane, under Data Marts, all the available Data Marts are listed.

VDMImage6 

4.   Click on the bin to delete a particular Data Mart.

5.   The Data Mart will be deleted.

 

Steps to Update a Virtual Data Mart

HubSpot Video
  1. Login to Zetaris

  2. Go to the Virtual Data Mart tab.

 VDMImage7

3.   On the left pane, under Data Marts, all the available Data Marts are listed.


VDMImage8 
4.   Click on the Data Mart which needs to be updated.

5.   After clicking, the middle pane will show the data sources in that data mart.

6.   Simply drag and drop more tables as required. The "Clear model" button can also be used to clear the model completely so you can start afresh.