# Using Datasets in Deployment: Transferring configuration data between DTAP instances

**URL:** <https://community.novulo.com/t/using-datasets-in-deployment-transferring-configuration-data-between-dtap-instances/205>\
**Category:** \[Q&A\] General\
**Tags:** deployment\
**Created:** [May 30, 2024, 11:29am UTC](https://community.novulo.com/t/using-datasets-in-deployment-transferring-configuration-data-between-dtap-instances/205 "2024-05-30T11:29:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![SteffenBeu](https://avatars.discourse-cdn.com/v4/letter/s/b487fb/32.png) [@SteffenBeu](https://community.novulo.com/u/SteffenBeu)\
**Post date:** [May 30, 2024, 11:29am UTC](https://community.novulo.com/t/using-datasets-in-deployment-transferring-configuration-data-between-dtap-instances/205/1 "2024-05-30T11:29:05Z")

</div>

Hello Novulo Community!

While working on setting up a new instance in my DTAP street (A) I have managed to succesfully deploy the application in the new instance. Since it is brand new there is no data available in the new instance. While it is normal that a different instance has different data, I would like to move configuration data (countries, currencies, import definitions, etc) to the new instance.  
I have noticed that there is a way to deploy datasets in the deployment street, however I don’t fully comprehend how this works and what my options are.  
Does anyone know the proper way of transferring configuration data between DTAP instances?

---

<div class="post-metadata">

**Author:** ![Helena](https://avatars.discourse-cdn.com/v4/letter/h/c68b51/32.png) [@Helena](https://community.novulo.com/u/Helena)\
**Post date:** [June 7, 2024, 7:21am UTC](https://community.novulo.com/t/using-datasets-in-deployment-transferring-configuration-data-between-dtap-instances/205/2 "2024-06-07T07:21:36Z")

</div>

We consider 2 different kinds of data: Globally know data or “verspreidingsdatasets” that contain things like countries and currencies and connectioncontacttypes that are usefull for almost all applications.  
The second kind of data is more specific to you model: Warehouselocations, rightsprofiles or invoicesettings.

The first kind of datasets already exist and you can send them to your new application:  
 ![image](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/1X/2dda7704a0a7159ffc5781ba0782909fc07078ff.png)

The datasets specific to your model you need to export from your test or config application in your DTAP street. There are datasets that help to export the most common kind of data, but not for all recods types. Par example there is a dataset to export rights (D744).  
 ![image](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/1X/211d39ff2cd3f155ce0a416ecbe92b492608645f.png)

You import this dataset to your application and you find it in the exportdefinitions and there set up a new datasource to export your own rightsdataset. This new rightsdataset then can be sent to your acceptance and production environments:  
 ![image](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/1X/ba7a1994075c574061dc17e47ff136cfe7e8bb91.png)

---

<div class="post-metadata">

**Author:** ![Joeri](https://yyz2.discourse-cdn.com/flex008/user_avatar/community.novulo.com/joeri/32/428_2.png) [@Joeri](https://community.novulo.com/u/Joeri)\
**Post date:** [June 11, 2024, 6:10pm UTC](https://community.novulo.com/t/using-datasets-in-deployment-transferring-configuration-data-between-dtap-instances/205/3 "2024-06-11T18:10:20Z")

</div>

We always use datasets (the lower one in Helena’s comment). For this to work, you configure export definitions which can then be exported as datasets which can then be added via this step in the deployment. Some examples which we use are:

![image](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/1X/b50ba2aa48d8e9c992c05f0afac88a7b8990d0e5.png)

In these export definitions you get total control of what tables (incl. nested tables) need to be exported and you are also in control of all the fields. Also it is possible to have advanced import actions which can be congfigured.

---

<div class="post-metadata">

**Author:** ![StephanRS](https://yyz2.discourse-cdn.com/flex008/user_avatar/community.novulo.com/stephanrs/32/92_2.png) [@StephanRS](https://community.novulo.com/u/StephanRS)\
**Post date:** [July 2, 2024, 11:36am UTC](https://community.novulo.com/t/using-datasets-in-deployment-transferring-configuration-data-between-dtap-instances/205/4 "2024-07-02T11:36:13Z")

</div>

Hi Helena, Thanks for the explination, I actually miss in the story how to create a data definition so that you can distribute it across the DTAP instances. For example, a dataset for exporting activity templates, etc. Can you explain to me how to create a dataset and then distribute it via the DTAP instances as mentioned above?

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![Rose](https://yyz2.discourse-cdn.com/flex008/user_avatar/community.novulo.com/rose/32/4_2.png) [@Rose](https://community.novulo.com/u/Rose)\
**Post date:** [July 3, 2024, 10:05am UTC](https://community.novulo.com/t/using-datasets-in-deployment-transferring-configuration-data-between-dtap-instances/205/5 "2024-07-03T10:05:30Z")

</div>

Hi,

Let’s take Activity templates as an example.

First you get the Basic dataset from Deployment into your test or develop application. Since this will be the source of your OTAP distribution line.

Best practise is to subscribe to this dataset in Deployment.

> **Subscribe to a dataset**
>
> ![image](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/1X/ac73ebe05e2e747990538fa97de37512ea94cf61.png)  
> Click on this dataset \> Subscriptions \> and add your test/dev application to the list.  
> Then go to your application \> Subscriptions \> **select** the dataset you want to install and click on:  
> ![image](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/1X/564d17b3d35c3e693bf00567568c140b12edbcb7.png)
> 
> A new installation will be added with the type: datasets.  
> _Important note: when you already started an application update, the dataset will be added to this installation._

When you have the export in your application you can start preparing it for Otap distribution.

> **Prepare OTAP Datasets**
>
> Go to Exportdefinitions \> [Basis][Ind] Export individueel Activiteitsjabloon \> [edit]  
> Set Save to app server to yes
> 
> ![image](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/1X/406723c695ec5f4f5513aeb505c29e679001d1af.png)
> 
> The overview “Export to deployment” will appear
> 
> ![image](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/1X/0f36c2cb916dd96b39a6ce4754757060c6942385.png)  
> Click on + to create your specific dataset - _think about the Naming convention you want to use._
> 
> ![image](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/1X/44da2dfc08d08eb26822b0679b80fd9b3d10a6c1.png)
> 
> 1. Fill in the Description (fi: Activiteitsjabloon - Opdrachtbevestiging naar klant (Weborder)
> 2. Fill in the Filename in Deployment (could be the same as description)
> 3. Click on Add new data source.  
> Safe
> 
> Now go to the parameter and click op Generate.
> 
> ![image](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/1X/2956dcf5c61c948c98e2b13ed984c96622eb97ab.png)  
> Edit the New Value to make your selection which activity template(s) you want to be part of the dataset.

Once you have your export in Deployment, you can add your Acceptance and Production applications as subscriptions. See Subscribe to a dataset in this article.
