Does anyone have experience in linking into Sage Accounts (line50, Sage50 etc) with Servoy? There is an ODBC driver but I have been unable to find a JDBC driver. Mainly interested in reading data from Sage and using the Sage import routines to post data back.
Thanks.
Hi Richard
How bizarre - I have posted a question on this in the last 24 hours
http://forum.servoy.com/viewtopic.php?f=22&t=16888
We must keep each other up to date on how things progress here
Cheers
Harry
Hi Harry,
Missed your post, but judging by the response I guess that not much experience about. Maybe this is a refelction of the takeup of Servoy in the UK?
Hi Richard
Certainly not with Sage at least
That said, I know of several Access Accounts users floating around and there may be other accounts packages here and there
There is a good spread of developers in the UK consisting of independents and in-house teams
That said, there is always room for more and perhaps you are a good example of this
Cheers and keep you posted on any advance with Sage
Harry
To access ODBC (system) resources, you could always try to use Sun’s (sorry Oracle’s) JDBC-ODBC bridge, see http://download.oracle.com/javase/1.3/d … e.doc.html
It is part of Java, so no need to install a jar in your drivers folder, just set your DB driver class to sun.jdbc.odbc.JdbcOdbcDriver and your URL to
jdbc:odbc:[;=]*
Not guaranteed to work (depending on what the ODBC driver itself provides), but worth a shot…
Just be aware that this JDBC-ODBC bridge was never implementen on the Mac. So you can do this only on Windows and Linux (when using the Sun/Oracle JVM).
Of course this only affects Servoy Server/Developer. Clients can still run on Mac and use the JDBC-ODBC connection on the server.
Hope this helps.
If you get this to work Harry/Richard very interested to know your experience. I have a couple clients both of whom want Sage integration and are suggesting very simple import/export right now ODBC would be a lot better.
Cheers
Thanks for the information. As far as I am aware Sage isn’t available on the MAC and for my part I just need a link from a Windows pc. About to download and try out the JDBC-ODBC and will report back on my findings.
Download ?
It’s baked into the JVM so you can simply use the driver settings Patrick provided and off you go .
Or were you talking about ODBC drivers to download.
Took me a while to work that out Still a newbie I’m afraid
I have been able to create an JDBC-ODBC connection, it retrieves all the table names with the correct columns. Servoy however complains because it cannot find the primary key. Pretty sure their is no way round this - but if anyone knows a way…
Have checked with Sage and they don’t have a JDBC driver. They have Sage Data Objects, which is an ActiveX control, which in conjunction with the COM plugin should give access to the data. It also allows you to write data back. I need to check but the for the customer to activate the control it used to be free. Sounds good? Well you need to join the Sage developer program to get access to the documentation for the princely sum of £1,500 per annum for Line 50 (or more depending on the accounts package you want to link into). If you only want to link into Instant Accounts then it is only £99 per annum. The data structures used to be the same for Instant and Line50, we have Instant accounts so if £99 will get us connected through the COM plugin.
Ah, yes, primary keys. That’s the one problem you will not be able to solve with this driver.