Good day

Has anyone come accross a BI connection to sage one cloud data that is powerful and can extract gl transactions for example to excel. Inside of sage one you can run a ledger transaction report but as soon as its large it seems to not want to export to excel.

i tried sage intelligience excel addin which can give us TB and customer invoice type of data but not ledger transactions

If you know of a developer that have been able to connect to the cloud data even with the old alchemex traditional connector that would be first prize.


Views: 130

Replies to This Discussion

Hi Dawie.

I'm not aware of any tool like this and haven't seen the desktop Connector used in this way.

Sage Intelligence are looking to produce additional reports for the cloud.  Why not offer your suggestions?

Thanks Peter

I just want to know how much i will be able to get out of the data. From partner we could get ledgertransactions. From SAGE one we can not seem to get ledgertranscations, have to manually go into sage one and cannot export the whole GL for 1 year to excel for example, have to split it up into months or quarters. that is going to be a challenge!

Hi Dawie.

From a Sage Intelligence perspective, currently you won't be able to access transaction level detail.  This should however change in time.  You may also want to query this from a Sage One perspective on Sage City:


This Weeks Top Content 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service