[Openroad-users] Sage line 50

[Neil.Warnock at luminary.co.uk]

Hi Gareth, 
 
I worked on a project some time ago that extracted data from SAGE and
found that read-only access was dead easy via ODBC. Dunno if there is an
API for read/write too.  If you want tips on using ODBC from OpenROAD
see pres:-
http://www.iua.org.uk/conference/Autumn2005/NeilWarnock_1005.pdf
 
Assuming it's on windows (does Sage run on unix/linux?) I'd put a few
AppServer SCPs on the windows machine which wrap and hide the ODBC stuff
and expose them as a service to your OpenROAD clients.
 
You will laugh / cry / head-butt your desk repeatedly when you see the
data model... It didn't quite make it to 1NF !

Neil Warnock 
Luminary Solutions 
Tel: +44 (0)845 371 4090 
Mob: +44 (0)771 265 0291  
Email: Neil.Warnock at luminary.co.uk 

For more information on Luminary go to http://www.luminary.co.uk
<http://www.luminary.co.uk/>  
Luminary Solutions Limited Registered in England No 4854134 VAT Reg No.
829 3166 13 
Registered Office: 16/17 Pavilion Business Park, Royds Hall Road, Leeds
LS12 6AJ 

 

  _____  

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of
gareth.2.edwards at bt.com
Sent: 04 June 2007 16:50
To: openroad-users at peerlessit.com
Subject: [Openroad-users] Sage line 50


Win XP
ORd 2006
 
Hi All,
 
A project has come up which requires interfacing with Sage Line 50. I've
never used Sage before and apparently you need to be a business
developer to have access to the Sage tables.
 
Just wandered if anyone has any experience on doing this and could make
comment on how easy/difficult it is.

Cheers, 
Gareth Edwards 

BT Global Services 
tel: +44 (0)131 345 4671 
email: gareth.2.edwards at bt.com <mailto:daryn.piper at bt.com> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20070604/7f5432d3/attachment.html