# Creating a Datamart

* Navigate to the Survey list.
* Click the ***More Options*** icon provided next to a survey name.
* Select the ***Manage Datamart*** option from the context menu.

&#x20;     ![](https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2F4pEU6JHiTkPl6gSniZen%2Fimage.png?alt=media\&token=0a24e144-4802-4d29-bdb2-3df35b0569ea)

* A new screen gets launched to create/ update Datamart.
* Fill the following information:
  * **Datamart Status**: It will show that no Datamart has been created.
  * **Database Type**: Currently **MySQL** database is supported.
  * **Database Name**: Enter the name of the database where you want to write the survey data.
  * **URL**: Enter the proper IP link or data address.
  * **Port:** Provide the port number.
  * **Username**: Provide the username.
  * **Password:** Provide a password.
  * **Datamart Description**: Enter a description of the Datamart (It is an optional field).
* Click the ***Create/ Update Datamart*** option to create a Datamart.

&#x20;                                                       **OR**

&#x20;      Click the ***Reset*** option to reset the details (if required).

<figure><img src="https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2Fw1whmGarKuGI0KxILltV%2Fimage.png?alt=media&#x26;token=1c239e2b-a43d-4ee4-8b96-49579d4673b2" alt=""><figcaption></figcaption></figure>

* The users get directed to a new page (if a Datamart is created successfully) and the ***Datamart Status*** gets displayed on that page to confirm the successful creation of a Datamart.
* Click the ***Refresh*** icon.

<figure><img src="https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FSo8RzKBVFAvDwn6ywsGe%2Fimage.png?alt=media&#x26;token=900d2a56-fc42-46e8-9cc7-ae3324ac8927" alt=""><figcaption></figcaption></figure>

* The created Datamart gets displayed on the page.

<figure><img src="https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2Fgx64A0kTuuOd5Go4VXdp%2Fimage.png?alt=media&#x26;token=e6305532-115c-4adc-8b45-52dea4d01722" alt=""><figcaption></figcaption></figure>

* Click the Datamart name to open the Datamart details.

<figure><img src="https://4128708524-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FASOReJFmObiJT6WmpXqP%2Fimage.png?alt=media&#x26;token=807902be-c696-47f7-b189-0ef820a7adc8" alt=""><figcaption></figcaption></figure>

&#x20;

&#x20;                     &#x20;
