[Deploying Sakai] SIS Integration

Paul Gibbs pgibbsjr at hotmail.com
Wed Sep 9 18:39:07 PDT 2009

Thanks for everyone's response--and for your note here, John. I read through the CM API today and then through everything in Confluence dealing with Sakora. The Sakora tool looks helpful--provided I can get it working without burning myself. :)

I guess the first thing I need to do is get Sakora running and then deal with LDAP afterward.

I'll try to remember to get back to everyone to let you know what I ended up doing and how it went.


-----Original Message-----
From: production-bounces at collab.sakaiproject.org [mailto:production-bounces at collab.sakaiproject.org] On Behalf Of John A. Lewis
Sent: Wednesday, September 09, 2009 8:02 PM
To: production at collab.sakaiproject.org
Subject: Re: [Deploying Sakai] SIS Integration


As others have mentioned, one good option would be to implement the
Course Management API to directly connect to your SIS database.  That
combined with LDAP for authentication/user directory information should
work as long as have a way to connect the users in the SIS to the users
in LDAP.

Another emerging option you might want to know about:  There is a Sakai
module called Sakora (see http://confluence.sakaiproject.org//x/BAACAg)
that does standards based (IMS LISv2) integration directly with SIS
systems.  Only Peoplesoft Campus Solutions supports this so far, but
others should be rolling out support soon.  To make Sakora more widely
useful right now, we've also just finished a flat-file adapter for
Sakora that synchronizes SIS data out of a set of flat-file extracts
from an SIS database.  You can get more information on that here:

Hope that helps!

John Lewis
Chief Software Architect
Unicon, Inc.
jlewis at unicon.net

Paul Gibbs wrote:
> It just occurred to me that someone might want to know a little bit
> more information.
> Our SIS is stored on a SQL Server database. We would like to have
> Sakai automatically set up students, profs, academic years, courses,
> course offerings, and class rosters using the SQL database. That way,
> if we add a student or drop a student from a class using our SIS,
> Sakai will reflect that change. Regarding user authentication—our
> database has user IDs and passwords, but we can’t access the passwords
> outside of the proprietary software. My thought was to add a custom
> record to our SIS to store their Active Directory user account, and
> then authenticate on LDAP and have Sakai retrieve the student
> information associated in the SQL database with that AD account. (Hope
> that makes sense!)
> I would still like to be able to create one-off users and project
> sites, however, in addition to managing courses using the integration.
> However, I’m willing to let that go if necessary.
> Paul
> *From:* [hidden email]
> <http://n2.nabble.com/user/SendEmail.jtp?type=node&node=3611390&i=0>
> [mailto:[hidden email]
> <http://n2.nabble.com/user/SendEmail.jtp?type=node&node=3611390&i=1>]
> *On Behalf Of *Paul Gibbs
> *Sent:* Wednesday, September 09, 2009 10:27 AM
> *To:* [hidden email]
> <http://n2.nabble.com/user/SendEmail.jtp?type=node&node=3611390&i=2>
> *Subject:* [Deploying Sakai] SIS Integration
> Does anyone have any documentation on setting up an SIS with the
> course management service other than this:
> http://confluence.sakaiproject.org/display/DOC/Sakai+Admin+Guide+-+Course+Integration?
> I found this:
> http://confluence.sakaiproject.org/display/SAKDEV/Course+Management+Integration,
> but that was written for 2.4.x. Is this still valid?
> Thanks,
> Paul Gibbs
> CBTS / Lansdale, Pennsylvania
production mailing list
production at collab.sakaiproject.org

TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

More information about the production mailing list