Sage 50 link with Quantrix

7.13K viewsFormulas and Functions
0

Hi All,
I am new to quantrix (just learning through quantrix authority). Does anyone know how i would link quantrix to Sage 50? I would like to create a link so i can extract actuals by nominal from Sage.

Your help is very much appreciated.

Thank you

marcodelgreco Answered question June 19, 2018
0

Cheers Nicolao, unfortunately the Sage 50 database is a flat file DB so not compatible with the JDBC link.

marcodelgreco Answered question June 19, 2018
0

I think is necessary:

  1. install in Quantrix the JDBC driver (depending from DB: eg. Oracle, MS SQL, MySQL…)
  2. Set up a datalink through JDBC providing the appropriate access parameters
  3. If you intend to access from an external network, you may need a VPN connection.

what is the type of database used in the installation of Sage 50?
Unfortunately I do not know the Sage 50 Database tables, I think they are not the same as Sage X3
I apologize for the bad English

nicolao Answered question June 18, 2018
0

Sage 50 is the accounting package for small businesses.

marcodelgreco Answered question June 18, 2018
0

Hi what you mean for Sage 50? I’m consultant on Sage X3 (ex Adonix) is the same product?

nicolao Answered question June 18, 2018
0

Marcodeigreco,

Welcome to the world of Quantrix. Best business decision ever. I’m not familiar with Sage 50, but if you can export any of the data to csv then importing from csv into Quantrix is pretty straight forward. Here is a link to some videos from Quantrix Authority on Youtube that may be of help.

https://www.youtube.com/channel/UCQPG6S … ?query=csv

Should you need clarification please reply here or send me an email as listed in the end of the videos.

–Rich

0

Cheers Rich, I have emailed you more details.

Thank you once again.