Alexandre Pantanella
Business Central Solution Architect ยท Creator of BC2SQL
BC2SQL is built by someone who has spent over a decade inside Microsoft Dynamics NAV and Business Central, and who still ships Business Central projects for a living. It is not a side experiment: it is a tool made by the person who has to make these integrations work in production.
Why I built BC2SQL
Business Central SaaS has no direct database access. Everything that wants your data, from Power BI to reporting tools to other systems, has to go through the API.
The need is simple to state and tedious to do well: have your Business Central data in a SQL database you control, current, and without loading the ERP that people are working in. Across my projects, customer after customer asked for exactly that, and every time I ended up building the same custom sync from scratch.
After doing it for several customers, I stopped rebuilding it and decided to generalize it: one tool, configured instead of coded, that anyone running Business Central can use. That tool is BC2SQL.
It runs on your own server, reads Business Central through its official OData API, and keeps your SQL Server, PostgreSQL or MySQL database up to date, on a schedule or in near real time through native BC webhooks. Because it comes out of real customer projects, it is shaped by what breaks in production, not by what looks good in a demo.
Experience
- Solution Architect / Developer at Var Prime S.r.l. (Var Group), since September 2024
- Business Central AL, Dynamics 365 and Dynamics NAV development
- REST, SOAP and OData integrations, including WMS
- Cloud cost optimization on Azure, with a 15% reduction in recurring annual cloud costs
Technical focus
- SQL Server, PostgreSQL, MySQL, T-SQL, SSIS and ETL
- Azure, Azure Functions, Windows Server, Linux, Docker, Nginx
- Go, C#, C/AL, PHP, PowerShell, Bash
- Licensed civil engineer, with PhDs in Applied Mathematics and Economics
Let's talk about your Business Central data
Questions about BC2SQL, a setup you are unsure about, or a case that is not covered by the guide? Write to me directly.