SIMS <--> SQL DB relationship schema
I know this topic has been covered ad nauseum, but I'm building a web gateway that extracts information from SIMS's SQL Server database; but I don't want to go through SIMS to get it. That means no SIMS SDK or anything of that kind. I don't see the need for those extra levels of abstraction. I just want to connect directly to the database, run some queries, then do whatever I want with the information.
I've already had some success, and the project is going pretty well. Our LEA has given us its full support.
Now, we only want to pull data from the database - there will be no writing back to it. Capita are aware of our intentions, and their response was:
"We donít support the schema as that implies direct connection to the database. We would rather the school use IMS or the Command reporter."
So, they would rather we do things their way - but why wouldn't they? From what my LEA has told me, much of the talk on here about Capita rescinding their SIMS support if we circumvent their software is just so much scaremongering.
Anyway, regardless of the Capita issues, we've been given the go-ahead by the LEA to look into this.
It's going to happen.
So, I know a lot of folks have had some success in this area already (penfold_99, I believe, with Moodle integration; and the chaps at SalamanderSoft who did a lot of work for Twyneham, to name a couple); and I was wondering if anyone has managed to do any extensive mapping of the SIMS/SQL relationships, perhaps using the SQL Server Profiler or something similar to log the requests that SIMS is sending to the database.
We're really looking for people to collaborate with on this; and we would be massively appreciative to anyone who has already made substantial headway into mapping the relationships who might be willing to help. I know you're out there :)
Thanks in advance,