By Timo Selvaraj
Accessing an organization’s financial and accounting data for analysis and visualizations can be quite challenging due to the variations of stored data, complexities and the customizations required. Combining financial, accounting and CRM data can be quite complex but provide insightful value add due to the ability to visualize them together.
SearchBlox provides the ability to directly query data from the following systems:
– Exact Online
– Microsoft Dynamics GP
You can write SQL against these data sources with statements like:
SELECT * FROM Accounts
SELECT * FROM TradingAccounts
SELECT * FROM Customer
Using these SQL queries the data can be retrieved for visualizations in real-time. This data can be combined with external sources like sales or marketing data for a complete picture of the organization without the hassle.
Read our recent Blog posts