how to download sdk

Question

i am trying to integrate sage 500 with my application , but i am unable to find from where i can download sage 500 sdk ....can any one help me out ? 
 
 thank you

LouDavis · Accepted Answer

Well the creation of records through a web service would be possible using some of the existing Data Migration routines that Sage currently has. For example one particular routine you can look at for an example is the customer creation process which is spARapiCustomerIns. You'll see it requires staging table to be populated first before calling the stored procedure. You'll also need to connect to the database using a valid Sage 500 user account. For any transactions that Sage does not provide a Data Migration routine for ( Example: PO Receipt of Invoice), it is possible one of the current development partners such as E2bTek or RKL may have what you need. 
 
In regards to querying the data, as dbColes pointed out you can use the existing views that BIE uses. Now as to modifying existing records, you have to be cautious of what you are doing as it can cause possible issues that will not be supported by Sage if the data becomes corrupted. The SDK Course Sage use to have for 500 covered this topic to include referential integrity, surrogate keys, and logical locking. This and a good working knowledge of 500 and its database schema are a necessity when modifying existing records in Sage 500 when not using one of its APIs. 
 
I am not sure if Sage makes the course Material available for the SDK class since as far as I know they do not teach it anymore. I would contact Sage University to see if the course is available or if they can provide the course material to review before embarking on this project. 
 
If none of that is available, then I would do what DBColes recommended and work with your partner or contact a Sage 500 developing partner to design/create the web services for you to ensure that everything is done correctly.

Sage 500

how to download sdk

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING