SIMS Business objects or commandline reporting #592
Not sure where to post this but will do it here.
We currently have card exchange connected to our SIMS.net database, this is an MIS system from Capita which stores all our data on staff and students including their photos. This is where we pull the information from to create ID cards for staff.
The link is currently direct to the back end SQL database, however CAPITA do not support this.
I was wondering if your system can or possibly in the future use either the SIMS.net business objects, or their commandline reporting tool?
The reporting tool extracts a report from SIMS.net in either CSV or XML format and is read only. The business objects are dll files which give you read and write access to the database without access to the underlying database to protect for changes to the database structure.
SIMS Business objects or commandline reporting #593
If CardExchange needs to access the data via other mechanisms than a database connection, we need to build a synchronization mechanism that copies the data to an intermediate database and connect CardExchange to that database. Unfortunately, some system providers, instead of using all security possibilities a database engine offers, opt for this kind of restrictions. We all know that SQL Server can perfectly protect against unauthorized actions by using user authorizations. Changing the database structure with CardExchange is not even possible and also within CardExchange there are a lot of securityoptions.
Senior Software Engineer
"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)