[Openroad-users] Sage line 50

[Chris Clark]

This isn't a recommendation it is more of an anecdote....

Many, many years ago I was working on an an add-on tool for SAGE and 
didn't have an SDK (I don't think they even existed at that time). We 
also needed to make changes to the data and we ended up using the 
"import transactions" option (driven by a DOS command line tool) which 
was documented. The issue with going that route is that you are forced 
into batch replication, and the potential issues of time lag. Whether 
that is an issue or not depends on the data (we were working with sale 
inventory so it wasn't an issue as the add on tool could only sell 
things that physically existed in the store, the time lag was that the 
main SAGE repository thought things were in stock until the batch import 
job ran).

Chris


Neil.Warnock at luminary.co.uk wrote:
>  
> 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> 
>
>
>   
> ------------------------------------------------------------------------
>
> ________________________________________________________________
> OpenROAD-Users mailing list
>
> You can maintain your subscription here:
> http://www.peerlessit.com/mailman/listinfo/openroad-users
>
> To unsubscribe click on this link
> mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
>
> To subscribe click on this link
> mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe