Forum Discussion
Connecting to Xero data from Desktop application?
Kudo KingpinHi raldred,
My company (www.managility.co) specialises in professional business intelligence solutions for Xero. The Acterys Connector for Xero enable you to access your Xero data with Power Desktop.
As opposed to direct access via the API that has a variety of problems (API call limitations, single entity access/ no consolidation, performance, limited refresh) Acterys creates (and automatically refreshes) a proper Azure SQL data model with all relationships and dimension tables as well as financial DAX calculations that is fully editable, supports Direct Query and write back for forecasting and planning requirements.
If you have further questions please feel free to contact me.
Martin
Planning with Power BI? -> www.Acterys.com
Helper IIIHi,
Does clearjelly transfer all data to excel then excel is connected to Power Bi desktop? Or does ClearJelly have a direct connection with Power BI.
Cheers
Elizabeth
- karaoan
Hi Elizabeth,
Acterys (formerly Clear Jelly) maintains a copy of your Xero data as a cloud based data model optimized for analytics with all relationships and relevant financial measures. This model gets automatically updated or manually refreshed by the user when new data is available in Xero.As opposed to direct access via the API that has a variety of problems (API call limitations, single entity access/ no consolidation, performance, limited refresh) Acterys creates (and automatically refreshes) a proper Azure SQL data model with all relationships and dimension tables as well as financial DAX calculations that is fully editable, supports Direct Query and write back for forecasting and planning requirements.
Quickbooks (a system that Acterys supports as well - an alternative to Xero) attempts that with a Power BI connector to their system but because of the above mentioned limitations it just doesn't work (extremely slow refresh etc.) . I am happy to take opinions here but I really think there is no alternative to having a proper data model approach for financial applications. In Acterys that only takes a click and avoids paying expensive consultants to build a model for them that typically takes extensive time and investment.
Martin- ElizabethTachji
Hey Martin,
I hope you are looking forward to the New Year and had a fabulous Christmas.
Thank you for the information below. I will give Clear Jelly a test.
Re lost of control of what the users will see...What do you mean by this because I am under the impression that what the user will see depends on permission scopes set-up. For example one permission scope is only to see dashboards the user has access to. I can also turn off ability to export data to excel.
Cheers
Elizabeth Tachjian
- karaoan
Hi Elizabeth,
What I mean by loss of control: you don't want users run reports on a "live" accounting system where transactions could be incomplete, not approved etc. (not to mention issues when you need to setup granular access (e.g.. users x can only access account y with tracking code z) which is likely very difficult/impossible with access through standard accounting system API's ) You want to be able to make results available for this particular point in time/ time range for which the data is approved for viewing in addition as database is used that supports RLS (row level security) you have then also the option to define access to lowest granularity.