MOODLE and Other Database Integration

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/inde
x.php/Admin_TipsOracle_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 Khon Kaen University Khon Kaen,
40002 THAILAND Tel/Fax. [phone] e-mail
ilti_at_kku.ac.th Web http//ilti.kku.ac.th/ MOODLE
http//e-learning.kku.ac.th/