Hi all,
I want to create a program where all companies in Sage 200 should be able to access and the data provided in this program should be stored in a custom database, not individual company database. I assume for the create database query, I can add it in "AddIn.sql" in the packager/sandbox.
But to actually access the custom database from Sage 200, is there any Sage 200 method to do it? Or I need to have my own connection string, and access it manually using SqlConnection class (https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection?view=dotnet-plat-ext-5.0) ?
Please guide me. Thank you.