Hello, I am the data architect of a company that uses Sage 200 Evolution in one of its subsidies in Nigeria. I was tasked to link the Sage SaleOrders data in our Power BI reporting. I have full access to the underlying MS SQL Server database, but cannot find any documentation on which tables to query, joins, etc. I can only see weird underscore prefixed tables and views, and functions that seem to query them. I could not find ANY documentation online on these underscore prefixed tables...
The Sage partner company we use have been very reluctant to help : they only showed me how they retrieve data using the Sage Evolution Explorer interface, or another interface called "Sage intelligence reporting". I have asked multiple times for technical documentation, or means to connect Power BI to that datasource and intelligible queries I can run (I can connect PBI to the SQL Server but don't know which tables/functions to query).
I have seen online that Sage is offering a 'starter' Power BI reporting called the 'Customers' Power BI template (Sage 200 Customers Report.pbit)', and asked our Sage integrator partners to retrieve it, but they answered me with "the Power BI report for customers report template that you displayed during the last meeting is only available in the UK region, and that report is not available in our Business Partner Platform region" (Nigeria).
I do not know what to do anymore, except from running a Profiler on that SQL Server db and slowly capture the queries that are run on the db, which could take weeks.... Please help
Here's what I need :
- Any existing means/example of connecting Power BI to the Sage 200 Evolution SQL Server db to retrieve data about SaleOrders (Inventory and customers dimensions too if possible)
- Any technical documentation on the SQL Server database (description of the important tables / columns, how to join, etc.).
Many thanks in advance to whoever can point me in the right direction