how to download sdk

SOLVED

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

  • 0
    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.
  • 0
    The SDK is available for sale. Depending on what module(s) you are using and what screens you want to integratee to will determine what you need to purchase. Also, you do have access to the database without purchasing the SDK. Just be aware, that we cannot support modifications you make to the application.
    Have you talked to your partner about what you are trying to achieve?
    Good luck,
    Darrick
  • 0 in reply to JohnHanrahan
    i would like to access their sales and invoice table to get the details is there any way i can achieve that


    thank you :)
  • 0 in reply to seshasai
    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.)?
  • 0 in reply to seshasai
    Depending on what data you want to look at, you can likely find what you are looking for in the BIE views. For example, if you go to Sales Order - Insights - Explore - Sales Order Lines, that BIE view uses the view vdvSalesOrderLine, which can been seen by clicking on File - Properties for that view.
  • 0 in reply to LouDavis
    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
  • 0 in reply to seshasai
    verified 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.