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.
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.
Should you need clarification please reply here or send me an email as listed in the end of the videos.
Hi what you mean for Sage 50? I’m consultant on Sage X3 (ex Adonix) is the same product?
I think is necessary:
- install in Quantrix the JDBC driver (depending from DB: eg. Oracle, MS SQL, MySQL…)
- Set up a datalink through JDBC providing the appropriate access parameters
- 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
Cheers Nicolao, unfortunately the Sage 50 database is a flat file DB so not compatible with the JDBC link.