We have been using SI5 for around two years and found it invaluable.
To streamline some of our data entry retrieval we would like to automate some tasks.
I.E. updating exchange calendars when scheduling changes. Currently if a change is made to a work orders schedule the invitations will need to be resent to the respective people and they will need to accept them and delete the old ones. this task should be relatively easy to automate either through parsing the database or some sort of api.
My questions are where do get the relevent table names / database overview / database access from. I havnt worked with sql for a few years and am looking for a push in the right direction. If there is am api for these sort of tasks then even better where do i get this info.