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.
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?
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!
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: