[Openroad-users] Sage line 50

[gareth.2.edwards at bt.com]

Thanks Neil.
 
I'll definitely need read & write access to Sage. Been doing a little research and there is an SDK available with ActiveX. (£1500 + vat per year)
 
Oh, and i'm sure i've got plenty of head-butting ahead.
 
Hopefully my numbers will come up saturday and i can buy LuminarySolutions.exp. :o) What would i give for an export of your code! Brain-overload. Even those KIP/ad-hoc graphing excel charts. Good stuff! 
 
"We" are all playing catch-up...

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>  

 


________________________________

	From: openroad-users-bounces at peerlessit.com [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Neil.Warnock at luminary.co.uk
	Sent: Monday, June 04, 2007 5:56 PM
	To: openroad-users at peerlessit.com
	Subject: Re: [Openroad-users] Sage line 50
	
	
	 
	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/20070605/23bd3bf8/attachment.html