The SDK is only available for purchase separately and I'm not sure it's even sold anymore. However I integrate with MAS 500 in a wide variety of ways and do not use the SDK for that. If you tell us what you want to do maybe we can help you.

i would like to access their sales and invoice table to get the details is there any way i can achieve that


thank you :)

First are you looking only to query data from the 500 database or are you also thinking of creating/modifying records? Also, what type of program are you looking to build (i.e. client that works within Sage 500 session, interface to another system, retrieve data for a website/web service, etc.)?

First are you looking only to query data from the 500 database or are you also thinking of creating/modifying records? Also, what type of program are you looking to build (i.e. client that works within Sage 500 session, interface to another system, retrieve data for a website/web service, etc.)?

we are trying to creating /modifying records as well as make changes in queries, we are trying build a website and few web services as well for few screens ..

thank you

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.