4D and Sage

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

4D and Sage

4D Tech mailing list
We've had a few enquiries from customers and prospects about interfacing
with Sage and I'd like to get an idea of how much work would be involved in
setting this up.
Basically we need to:
- Extract data into our 4D database
- Push data from 4D to Sage

Standard stuff I guess :)

We'll be using 4D v16.

I'm guessing this could be done via ODBC.

​What tools would be required? EG:
- 4D ODBC Pro?
- ​Sage developer account?

I'd be interested to receive quotes form 4D developers who have done this
on setting it up for us.

Pat Bensky

--
*************************************************
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: 4D and Sage

4D Tech mailing list
On Tue, Jun 13, 2017 at 1:17 PM, Pat Bensky via 4D_Tech <
[hidden email]> wrote:

> Basically we need to:
> - Extract data into our 4D database
> - Push data from 4D to Sage
>

I did export of accounting info from 4D based CRM system to Sage (German).
It is quite simple, export - import of plain text files.


--

Peter Bozek
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: 4D and Sage

4D Tech mailing list
In reply to this post by 4D Tech mailing list
Pat,

We have done 3 things with regards Sage Integration.  It is important to note these are all in relation to Sage Line 50.

Simple Export
This is just exporting invoices in a text format for import into Sage using their standard import function.

Integration via Transpose - http://www.red-it.co.uk/transpose <http://www.red-it.co.uk/transpose>
This is a middle ware application that will sit on the server with Sage and manage the communications via a selection of file based formats.  We have used this for many years but a while back the original developer sadly passed away and it was over a year before another company took up the product.  Thankfully it is supported well going forward.

Integration via Sagelink - http://www.eigergroup.co.uk/accounting/slink.html <http://www.eigergroup.co.uk/accounting/slink.html>
This is a similar solution to Transpose that we implemented for a client during the dark period where we could not get licenses or support for Transpose.

The 4th option I guess would be to become a Sage partner at a cost of £6.5K a year and write your own integration but not viable for most companies.

Maybe you could convince them to use Xero.  They have a great REST API which we have done a pretty full integration with.  We have not had a Sage integration request since we provided the Xero integration.

Regards,  Dougie
________________________________________________________

telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : [hidden email] <mailto:[hidden email]>  Web : http://www.telekinetix.com <http://www.telekinetix.com/>
________________________________________________________
 

**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: 4D and Sage

4D Tech mailing list
Hi Dougie,
Interesting ... we use Xero for our own business. Hadn't thought of
integrating with that, but seems like it would be an interesting idea.

Unfortunately lots of companies are deeply entrenched in Sage :)

Is it not possible to integrate via ODBC? For example a customer might want
to set up an automated process where once a day our database queries the
Sage db to get info on new/modified/deleted products, and updates the 4D
database.

Importing and exporting text is OK and that's what they currently do. But
they want something more automated.

Pat

On 13 June 2017 at 14:08, Douglas Cryer via 4D_Tech <[hidden email]>
wrote:

> Pat,
>
> We have done 3 things with regards Sage Integration.  It is important to
> note these are all in relation to Sage Line 50.
>
> Simple Export
> This is just exporting invoices in a text format for import into Sage
> using their standard import function.
>
> Integration via Transpose - http://www.red-it.co.uk/transpose <
> http://www.red-it.co.uk/transpose>
> This is a middle ware application that will sit on the server with Sage
> and manage the communications via a selection of file based formats.  We
> have used this for many years but a while back the original developer sadly
> passed away and it was over a year before another company took up the
> product.  Thankfully it is supported well going forward.
>
> Integration via Sagelink - http://www.eigergroup.co.uk/
> accounting/slink.html <http://www.eigergroup.co.uk/accounting/slink.html>
> This is a similar solution to Transpose that we implemented for a client
> during the dark period where we could not get licenses or support for
> Transpose.
>
> The 4th option I guess would be to become a Sage partner at a cost of
> £6.5K a year and write your own integration but not viable for most
> companies.
>
> Maybe you could convince them to use Xero.  They have a great REST API
> which we have done a pretty full integration with.  We have not had a Sage
> integration request since we provided the Xero integration.
>
> Regards,  Dougie
> ________________________________________________________
>
> telekinetix Limited- J. Douglas Cryer
> Phone : 01234 761759  Mobile : 07973 675 218
> 2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
> Email : [hidden email] <mailto:[hidden email]>  Web :
> http://www.telekinetix.com <http://www.telekinetix.com/>
> ________________________________________________________
>
>
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:[hidden email]
> **********************************************************************
>



--
*************************************************
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: 4D and Sage

4D Tech mailing list
I recently went through the process of trying to determine how to integrate with Sage since a client was looking to use them. Very difficult and expensive was the answer regarding automated integration.

I have looked at Xero previously because of their REST API but in accounting terms I don’t know how they compare to something like Sage.

It would be great to hear how others are using Xero. Seems like a good fit for 4D...

> On Jun 13, 2017, at 9:34 AM, Pat Bensky via 4D_Tech <[hidden email]> wrote:
>
> Hi Dougie,
> Interesting ... we use Xero for our own business. Hadn't thought of
> integrating with that, but seems like it would be an interesting idea.
>
> Unfortunately lots of companies are deeply entrenched in Sage :)
>
> Is it not possible to integrate via ODBC? For example a customer might want
> to set up an automated process where once a day our database queries the
> Sage db to get info on new/modified/deleted products, and updates the 4D
> database.
>
> Importing and exporting text is OK and that's what they currently do. But
> they want something more automated.
>
> Pat


Later,
Guy

--
Guy Algot, Solutions Specialist
Edmonton, Alberta
(780) 974-8538

hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
    -- Simon Slavin



**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: 4D and Sage

4D Tech mailing list
In reply to this post by 4D Tech mailing list
Pat,

Transpose is your best bet.  It does the automation and you can just
pickup and drop files.

Regards,  Dougie



**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: 4D and Sage

Paul Dennis
I had sage line 50 working ok with odbc. I was able to export data from sage into our 4D app. However this was for a one of conversion rather than ongoing integration.
Paul
Reply | Threaded
Open this post in threaded view
|

Re: 4D and Sage

4D Tech mailing list
In reply to this post by 4D Tech mailing list
Pat

I have code for this:..it uses the ODBC plug in but should be converted to just use SQL i think.



Nigel

> On 13 Jun 2017, at 12:17, Pat Bensky via 4D_Tech <[hidden email]> wrote:
>
> We've had a few enquiries from customers and prospects about interfacing
> with Sage and I'd like to get an idea of how much work would be involved in
> setting this up.
> Basically we need to:
> - Extract data into our 4D database
> - Push data from 4D to Sage
>
> Standard stuff I guess :)
>
> We'll be using 4D v16.
>
> I'm guessing this could be done via ODBC.
>
> ​What tools would be required? EG:
> - 4D ODBC Pro?
> - ​Sage developer account?
>
> I'd be interested to receive quotes form 4D developers who have done this
> on setting it up for us.
>
> Pat Bensky
>
> --
> *************************************************
> CatBase - The Database Publishing Solution
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *************************************************
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:[hidden email]
> **********************************************************************

**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: 4D and Sage

4D Tech mailing list
Nigel,
It would be cool to see that code :) No rush. This is not an urgent job.
Cheers
Pat

On 14 June 2017 at 08:55, Nigel Greenlee via 4D_Tech <[hidden email]>
wrote:

> Pat
>
> I have code for this:..it uses the ODBC plug in but should be converted to
> just use SQL i think.
>
>
>
> Nigel
> > On 13 Jun 2017, at 12:17, Pat Bensky via 4D_Tech <[hidden email]>
> wrote:
> >
> > We've had a few enquiries from customers and prospects about interfacing
> > with Sage and I'd like to get an idea of how much work would be involved
> in
> > setting this up.
> > Basically we need to:
> > - Extract data into our 4D database
> > - Push data from 4D to Sage
> >
> > Standard stuff I guess :)
> >
> > We'll be using 4D v16.
> >
> > I'm guessing this could be done via ODBC.
> >
> > ​What tools would be required? EG:
> > - 4D ODBC Pro?
> > - ​Sage developer account?
> >
> > I'd be interested to receive quotes form 4D developers who have done this
> > on setting it up for us.
> >
> > Pat Bensky
> >
> > --
> > *************************************************
> > CatBase - The Database Publishing Solution
> > tel: +44 (0) 207 118 7889
> > w: http://www.catbase.com
> > skype: pat.bensky
> > *************************************************
> > **********************************************************************
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: http://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:[hidden email]
> > **********************************************************************
>
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:[hidden email]
> **********************************************************************
>



--
*************************************************
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[hidden email]
**********************************************************************