Shopware 5, Getting the data to MySQL and creating reports for Order Management and need to connect data from various sources

Hi All,
I am working in a small shop which uses Shopware 5 for maintaining their e-commerce website.
I and the Owner are going to work on this.
Now the owner wants to take the shop ware data and integrate it with other sources like logistic data(DHL and DPD) and warehouse data(Some logistic company in Hamburg) and some supplier data.
Can I connect the shopware with MySQL and create various reports?
Or is using tools like Zapier to connect various data sources and put it in excel?
Which would be better? And the company generates only 1500 -2000 rows of data only.
Kindly suggest to me what to do.