LDN - Luminis Developer Network

Hello All,
Anybody who has done the Banner-Luminis-WebCT integration knows that its an extremely complicated process to get it done and get it done right the first time. So here is my blog on what we are going through:

Step 1: We analysed our current architecture and came to a conclusion that we need to redesign our entire Banner - luminis role definitions for the integration to work. Here is what i did:

In the process of reorganizing the banner role heirarchy - Previously we had a role called "student" in banner which represents all the students who are eligible to register (a mixture of undergraduate, graduate and law students) which was a quick fix for our registration module(we went live with it in april). We also have roles like gradstudent and lawstudent which were initially synchronized and they were synchronizing just fine. Now we are integrating with WebCT and webCT only needs a role called "student". It really doesn't care about what the student's level is etc., We also have Luminis where we have custom tabs published towards specific groups of students like undergraduate students, grad students, law students etc.,

So the re-org was to facilitate sending student information to WebCT as well as giving the fine-grained access to those students in luminis. So the intent was to have a global role called student which was defined as anybody who has a record in sgbstdn table. On top of that global role we defined 2 views called active student and inactive students. On top of that we defined roles like undergraduate_active, grad_active and law_active which mean that students in these roles are active undergraduate, active graduate and active law student.

If we were to synchronize these roles - previously a studnet who was undergraduate student would now have roles like "student, undergraduate_active". Previously who was a grad student willl have roles like "studnet, graduate studnet.. And previously who was a law student will have roles like "student, law student".

To achieve this, i created views called 'active students" and "inactive students" and couple of other views called "zuvstdn_active_UG, zuvstdn_active_grad, zuvstdn_active_law" and similarly "zuvstdn_inactive_UG, zuvstdn_inactive_grad, zuvstdn_inactive_law" and "student (to mean everybody in sgbstdn table)". I created these new roles gtvsqru form. I changed the sql to select distinct pidms from these views in gorrsql and ran the gurirol to populate the users with the above mentioned roles.

Shiva