Share your ideas for improving. Vote on ideas and discuss them with the MYOB product development team.

Product Ideas

Integration: ODBC Driver for AccountRight

Partner

13Posts

3Kudos

0Solutions

13 Posts
Partner
Australia

I've installed AccountRight 2012, but there is no ODBC software that accompanies the installation.  I use ODBC heavily to extract data into Excel, Access etc for additonal mining and reporting.  Hence, I will not upgrade until this functionality is available.  My apologies if this has been answered previously.

 

"ODBC Driver for AccountRight 2012"

 

 

Current Status: Done
Last Changed: August 2013

We are happy to say that our API is now available for developers. You can find out more here: http://developer.myob.com/

14 Comments
Rael
Trusted Partner
286 Posts
Trusted Partner

Raff,

A working ODBC driver does not exist for AR 2011/2012. Given the raft of reported bugs ( > 40) the last time I looked, and the apparent lack of prioritisation in addressing the issues, I would think we're at least 6 months away from a reliable version for the 2011/2012 product.

 

Sidenote: the AR 19.7 "compliance" update has also made some changes to the ODBC driver, so you may notice some issues in this area as well. MYOB have not acknowledged what they have changed, but some add-on developers have experienced issues. I think they relate to the write back functionality though, not data read.

 

Tread carefully, and only update/upgrade where necessary.

Mike_James
Ultimate Partner
5,839 Posts
Ultimate Partner

Re changes to ODBC 19.7 affecting write-back messages: now acknowledged here

Rael
Trusted Partner
286 Posts
Trusted Partner

Mike,

Acknowledgement seems to be to Developer partners only. What about everyone else? I stopped being a developer partner over 12 months ago.

Clive
Ultimate Partner
3,343 Posts
Ultimate Partner

Hi Mike

 

I think that is in the Developer only boards - MYOB is not letting anyone else know that they have stuffed up yet again.

 

Regards

Clive Williams

easybusiness
Valued Cover User
320 Posts
Valued Cover User

The timeline for the ODBC driver was to have the major issues fixed by the end of May then the less major issues sorted by the end of June and another batch fixed by the end of July.

 

However none of the proposed fixes have been released to this date, the latest announcement a week or two ago was that a new timeline will be released soon outlining when these fixes will occur. Currently the lack of an ODBC driver is preventing client who a lot of people who use 3rd party solutions from upgrading.

Clive
Ultimate Partner
3,343 Posts
Ultimate Partner

Hi Graeme

 


@easybusiness wrote:

The timeline for the ODBC driver was to have the major issues fixed by the end of May then the less major issues sorted by the end of June and another batch fixed by the end of July.

 

However none of the proposed fixes have been released to this date, the latest announcement a week or two ago was that a new timeline will be released soon outlining when these fixes will occur. Currently the lack of an ODBC driver is preventing client who a lot of people who use 3rd party solutions from upgrading.


Not only does the lack of a usable driver preventing existing users of 3rd party solutions & M-Powered services from upgrading (given the disaster of the 2011 release they are probably happy about that) but it has prevented developers from offering their solutions to the users of 2011/12.  I have spoken to a few developers and it looks like the Developer Conference will be fairly lively. 

 

Regards

Clive Williams

Matthew_W
MYOB Staff
2,173 Posts
MYOB Staff

Hi Raff,

 

It is true that at this stage there are no ODBC options for our 2012 and 2011 products, we are planning on introducing these features but there is still no time frame for when this will happen. Once there is a time frame in place it will be released to our Developers and then to our clients after that.

 

You are certainly able to continue to use version 19 so you do not lose your ODBC options until we add this functionality to our new range, we will be supporting version 10 through at least this Financial Year with the latest update 19.7.

easybusiness
Valued Cover User
320 Posts
Valued Cover User

I guess version 19 will need to be supported until the new AccountRights have working ODBC. Otherwise there would be lots of clients stuck between a rock and a hard place between getting compliance updates from MYOB and wanting the keep using their 3rd party software.

Mark_Smith
26 Posts
Former Staff
Thanks for your suggestion, Raff. We understand the ODBC situation presents a challenge for some businesses. This is something we’re working on and we’ll update this post once the roadmap is ready to share.
easybusiness
Valued Cover User
320 Posts
Valued Cover User

Hi

 

This is what MYOB has recently stated about ODBC

 

"The Developer Partner Team would like to advise that MYOB has decided to develop an API for AccountRight 2012 and AccountRight Live. This means that work to resolve issues with the ODBC for AccountRight 2011/12 and AccountRight Live will cease and the resources dedicated to the API. The ODBC for AccountRight 2011 will not be supported by MYOB and therefore we advise Developers not to use it. The ODBC for AccountRight V19 and earlier will continue to be supported well into the future.

 

You will shortly receive another email from MYOB inviting you to a series of webinars, including one covering the API. The API webinar will explain why we are moving down the API path as well as a high level overview of the API including delivery timelines, noting this is the same API presentation from the recent state Developer Sessions.

 

Developers will also soon receive a survey via email that will cover a broad range of topics, including what they view as their priority areas for the API. This feedback will help us finalise the development plan for the API, so be sure to have your say.

 

The Developer Partner Team will be going to significant lengths to ensure that Developers receive the necessary support as we transition to the API so please keep an eye out for future communications and ensure you update your contact details with us should they change.

 

We appreciate this represents a change in direction, but one that we believe better positions all of us for the future."

 

So pretty much early next year we will hopefully have an API to access the new MYOB products.