How do i get data in dhis2 from my MySQL Data Base

Support - Assistance technique
1

Please guide me how i get the data from my MySQL database.

What techniques i have to use

2

Hi @Saupi

Welcome to the DHIS2 Community of Practice.

DHIS2 uses PostgreSQL and not MySQL database and there’s a difference between both databases, but I’m wondering if your use case requires MySQL? Are you connecting to an external service for example?

You can use pgAdmin to connect to DHIS2 postgresql database, and if you have time you could research how to use pgAdmin to connect to MySQL databases in the case you need to connect to an external MySQL database. Note that I have not tried this method.