I want to connect Magento 2.3.5 to MSSQL database to export records about new orders like (product ID - Quantity sold - price - customer information) So what are my options?

Before I post this question I found many solutions, but I don't know if it's will work or no? Microsoft Flow Blend.co PDO connector

1 Answer 1


If you are doing this in order to have some sort of integration with a different system (for example an internal site /ERP) I strongly advise you not to work directly with Magento 2 database.

You should use the REST Webservices Magento provides and store the information you need in MSSQL.

In our case we created a C# library just for that purpose, to integrate the Orders / Products / Customer in our internal ERP.

You can find information on all webservices that are available out of the box in Magento here:


  • Thank you for your answer Commented Jul 11, 2020 at 14:15
  • No ptoblem if you need any help let me know :)
    – Joao71
    Commented Jul 11, 2020 at 14:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.