Blog: API

Guest post by We Are Magneto 

Recently, we had a requirement to integrate a Microsoft SQL (MSSQL) product database into a Magento 2 store. This integration would constantly sync product data between the two systems. For this integration, we would have to find some way of communicating with the external database, receiving the product data, and importing it into Magneto’s own database. Unfortunately Magento 2, like a lot of PHP frameworks, doesn't provide a PDO adapter for communicating with MSSQL directly. An added complication, in this case, was that access to the MSSQL server was protected behind a firewall.