MOODLE and Other Database

scacchicgardenΛογισμικό & κατασκευή λογ/κού

13 Δεκ 2013 (πριν από 3 χρόνια και 7 μήνες)

74 εμφανίσεις

MOODLE and Other Database
Integration

ผศ
.
—¦
.
Á—nœ¡Š¬r

­»—£´„—¸



้ช่วยอธิการบดีฝ่ายวิชาการ

และ



้อ านวยการส านักนวัตกรรมการเรียนการสอน

มหาวิทยาลัยขอนแก่น

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

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)

Various Database Use


MySQL


MS SQL


Oracle


Generic ODBC


FoxPro


PostgreSQL


LDAP


IMAP


RADIUS

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


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

KKU
OpenLDAP

Server

Student Information System

Authentication Mechanism

KKU LDAP Server (Faculties)

External Database (Students)

Synchronisation

and Mapping

Enrolment Methods

External Database Enrolment

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

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)


oci8 Extension for PHP

How to:
http://e
-
learning.kku.ac.th/mediawiki/index.php/Admin_Tips:Oracle_and_Ubuntu_Connection

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.

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!

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

Large Site Configuration

Institute of Learning and Teaching
Innovation


IT Center Building

Khon

Kaen

University

Khon

Kaen
,
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/