Best practice forum (Archived)

HR Import Question

 
John Unnever
HR Import Question
by John Unnever - Tuesday, 21 July 2015, 9:44 AM
Group Partners

Is there a way to connect to a different database other than MySQL?  The drop down menu only option is MySQL.  Currently we have an oracle database that we'd like to connect it to.

John Unnever
Re: HR Import Question
by John Unnever - Tuesday, 21 July 2015, 12:54 PM
Group Partners

Here is a screen shot of the page with the drop down menu i'm referring to.


Galin Vassilev
Re: HR Import Question
by Galin Vassilev - Tuesday, 21 July 2015, 1:10 PM
 

Hello,

I would check to see what drivers are available with your php installation on that server first. Under the server phpinfo page there should be a driver for Oracle. If not than one will have to be installed on the server where you are running this. Instructions for that would be operating system specific, but here is a place I would start.

http://www.oracle.com/technetwork/articles/dsl/technote-php-instant-12c-2088811.html

Cheers.

Easter Island / Rapa Nui
Re: HR Import Question
by Russell England - Tuesday, 21 July 2015, 11:48 PM
 

As Galin mentioned, you will need the Oracle driver installed on the same server as Totara. There are some instructions here - https://docs.moodle.org/27/en/Installing_Oracle_for_PHP

In addition, I had to make some minor changes to the core code in Totara sync, mainly in the form validation I think. I will have a look for them later and forward them.