1 / 22

MOODLE and Other Database Integration

MOODLE and Other Database Integration. ผศ.ดร. เด่นพงษ์ สุดภักดี ผู้ช่วยอธิการบดีฝ่ายวิชาการ และ ผู้อำนวยการสำนักนวัตกรรมการเรียนการสอน มหาวิทยาลัยขอนแก่น. KPIs Monitoring. Student Centered Learning (Education Act.) Technology integrated learning Life Long Learning

cooper
Download Presentation

MOODLE and Other Database Integration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MOODLE and Other Database Integration ผศ.ดร. เด่นพงษ์ สุดภักดี ผู้ช่วยอธิการบดีฝ่ายวิชาการ และ ผู้อำนวยการสำนักนวัตกรรมการเรียนการสอน มหาวิทยาลัยขอนแก่น

  2. KPIs Monitoring • Student Centered Learning (Education Act.) • Technology integrated learning • Life Long Learning • Internal quality assurance KPIs monitoring • External quality assurance KPIs monitoring • University management monitoring • Learning achievement monitoring • University ranging

  3. Database Integration • Various existing information systems • Student Information System • Student Portfolio (AVS, Oracle) • Student Enrolment (AVS, Oracle) • Staff Information System • Mailing System (LDAP) • Personnel System (FoxPro) • e-Office (MS SQL) • Management Information System (Oracle)

  4. Various Database Use • MySQL • MS SQL • Oracle • Generic ODBC • FoxPro • PostgreSQL • LDAP • IMAP • RADIUS

  5. MOODLE Base Database • MOODLE database is recommended to be neither MySQL or PostgreSQL • There is no easy solution for using other database, so it is not recommended • Integrate by using connection tools that embedded in MOODLE • Authentication • Enrolment

  6. ADODB Connectivity • MOODLE runs on FreeBSD, Linux, Mac OS X, and Windows • MOODLE is compatible with a huge range of databases through ADODB (Active Data Objects Database) integration • ADODB supports MySQL, PostgreSQL, Interbase, Firebird, Informix, Oracle, MS SQL, Foxpro, Access, ADO, Sybase, FrontBase, DB2, SAP DB, SQLite, Netezza, LDAP, and generic ODBC, ODBTP

  7. KKU OpenLDAP Server

  8. Student Information System

  9. Authentication Mechanism

  10. KKU LDAP Server (Faculties)

  11. External Database (Students)

  12. Synchronisation and Mapping

  13. Enrolment Methods

  14. External Database Enrolment

  15. Database Enrolment Conditions • Course idnumber between two databases must be identical • Large database search may slowdown both MOODLE server and external database server • More than 250,000 records for KKU enrolment • Redundant external database server may needed

  16. Oracle Connection • ADODB with PHP and Oracle • Oracle instant client have to be installed in MOODLE server • PHP requires oci8 extension • OCI8 extension is the standard method for accessing Oracle 8i, 9i or 10g (and later) • Coding requires ADODB library (MOODLE is ADODB ready)

  17. oci8 Extension for PHP How to: http://e-learning.kku.ac.th/mediawiki/index.php/Admin_Tips:Oracle_and_Ubuntu_Connection

  18. MOODLE ADODB Library • Locate at lib/adodb/drivers • External database character set must be known for Thai (UTF-8 is the common one) • External database character set must be indentify in MOODLE configuration pages.

  19. External Database Setting • Create view table for ADODB read-only connection (user authentication needed) • Data mapping on required parameters • User field • Course field • Institution ICT policy in place • Personal connection between programmers speed up the connection!

  20. Recommended Server • Linux-based webserver running Apache. • PHP with PHP accelerator • Webserver and database server should sit on separate machines • For a large site, load-balance and MySQL cluster may be necessary

  21. Large Site Configuration

  22. Institute of Learning and Teaching Innovation IT Center Building KhonKaen University KhonKaen, 40002 THAILAND Tel/Fax. 0-4320-2899 e-mail: ilti@kku.ac.th Web: http://ilti.kku.ac.th/ MOODLE: http://e-learning.kku.ac.th/

More Related