+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Hello and SIMS data via Web Services in Technical; Hello I've just joined - I don't know why it's taken so long! I taught ICT and some Maths for ...
  1. #1

    Join Date
    Mar 2009
    Location
    York
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Hello and SIMS data via Web Services

    Hello

    I've just joined - I don't know why it's taken so long!

    I taught ICT and some Maths for 26 years and left the profession last year (early retirement - I was neither pushed nor did I fall off the end!)

    I have been doing a little work for a few schools and I have developed an externally hosted web application for one. We now need to be able to interrogate the SIMS data.

    I know that SIMS is based on SQL Server 2005 (of which I have some experience) and that SQL Server 2005 has Native XML Web Services (or at least the full version does - not Express).

    I am interested to know first of all if there is anything about a SIMS installation that prevents using the Web Services capability of SQL Server 2005 and, secondly, whether anyone has successfully done such a thing.

    Glad to be here.

    Thank you.

  2. #2
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    there is nothing to stop you using the SQL server web service, not sure how you would go able using it.

    SIMS.net does have a web service but it read only for a pre-defined set of results.

    i have gone with using view as it was easy to implement.

  3. #3

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,622
    Thank Post
    1,240
    Thanked 777 Times in 674 Posts
    Rep Power
    235
    Quote Originally Posted by martyj View Post
    We now need to be able to interrogate the SIMS data. I know that SIMS is based on SQL Server 2005 (of which I have some experience) and that SQL Server 2005 has Native XML Web Services (or at least the full version does - not Express).
    I wrote my own small web server that uses SIMS' CommandReporter tool to extract data from SIMS. I figured that way all the data comes from where SIMS expects it to (no hauling it straight out of the database) and people with SQL Express are fine, too.

    --
    David Hicks

  4. #4
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    Sounds interesting, but I'd be careful as there is some agreement that schools cannot access their SIMS database directly (although you may get around it via "views").

  5. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,639
    Thank Post
    514
    Thanked 2,443 Times in 1,891 Posts
    Blog Entries
    24
    Rep Power
    831
    Accessing SIMS.net data has been discussed on the site quite a lot.

    There are a few options

    1. Use commandreporter
    2. Use the Business Objects, but if you aren't directly employed by the school then you would need to purchase a developers license which is somewhere in the region of 5k the last I heard.
    3. Break the school's license agreement and access the SQL data directly. This is not advisable!

  6. #6
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    33
    Generally accessing SIMS data direct from the database is frowned upon by Capita unless you contact them and become a partner () etc.

    Their main reason for not supporting it is that the schema is subject to regular changes and they don't want people constantly having to fix their secondary applications. Your best bet is the CommandReporter dhicks mentioned. It can be scheduled to periodically extract (but not insert) data using any report you have set up within SIMS. Exports to XML iirc.

SHARE:
+ Post New Thread

Similar Threads

  1. Programatic data extraction from SIMS.net Data Base
    By NetworkGeezer in forum MIS Systems
    Replies: 108
    Last Post: 16th February 2010, 09:22 PM
  2. Datacable or Excel Data Services?
    By harvy28 in forum Hardware
    Replies: 2
    Last Post: 28th April 2008, 11:32 AM
  3. Replies: 8
    Last Post: 23rd April 2008, 10:33 PM
  4. Web spying for Terminal services
    By zag in forum Windows
    Replies: 6
    Last Post: 23rd April 2008, 03:39 PM
  5. terminal services and symantec web security
    By Uraken in forum Thin Client and Virtual Machines
    Replies: 0
    Last Post: 14th February 2007, 10:27 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •