02-02-2012 08:42 PM
Our IT is developing the 3rd party database to interface with SAGE ACT 2012. They need some basic information on how to access SAGE backend database and would appreciate if somebody could kindly give some advice:
1. How to access SAGE back end database: User Name and password if there are any, such as "sa" which is default administrator user name or other db user name with admin rights / reading rights at least.
( PS. "User Name" memtioned here does not mean SAGE Application User Name, it means SQL server Database User Name)
2. We have added some customized fields into SAGE, we would like to know the relationship between SAGE customer end screen filed and Sql Server Datafield if possible.
We would appreciate very very much, if somebody could help us a little bit, thanks!!!
02-02-2012 09:00 PM
02-02-2012 09:29 PM
Thanks for your quick reply and kind help Mike, really apprciate it!
We have added in some customized fields into 2012 Premium. Our IT found that the SDK has more than 400 data tables which makes it really difficult for them to find the position of the fields in the 400 data tables where they want to pull data out of SAGE.
Do you have any suggestions on this? Thanks again in advance, this will really help us a lot!
02-03-2012 08:09 PM