Zameer here from the Shopify Developer Experience team.
It sounds like you're looking to store shop data such as inventory levels, in your own database. This is definitely possible through the use of our REST or GraphQL API. You can retrieve all the relevant information from the shop using your access token, and then write the data to your SQL server.
To keep the information in sync, I would recommend subscribing to the relevant webhooks that you require. However, since webhook delivery is not always guaranteed, you should implement reconciliation jobs to periodically fetch data from Shopify as well.
I'm not familiar with Pervasive PSQL myself, however, I see no reason why it can't be used to store Shopify data that is retrieved from the Admin API.
If you're looking for an expert that can help you implement a solution, check out this link that let's you look through the full catalogue of official Shopify Experts.
Best of luck!
The Admin API gives you access to a series of endpoints that you can use to retrieve a variety of data from a Shopify store. This includes info about products, orders, customers etc.
We need the same. We are moving from Umbraco to Shopify. But we want to keep using MS SQL as database. So can you confirm that using your REST or GraphQL API, we can synchronize our local MS SQL database with Shopify? Which membership plan should we sign up for, and is it extra charged per data request basis?