Sage 50 link with Quantrix

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
1.29K 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

Answered question
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.

0

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

Answered question
0

Sage 50 is the accounting package for small businesses.

Answered question
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

Answered question
0

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

Answered question