Best practice forum (Archived)

HR Import Question

 
John Unnever
HR Import Question
par John Unnever, Tuesday 21 July 2015, 09:44
Groupe 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
par John Unnever, Tuesday 21 July 2015, 12:54
Groupe Partners

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


? ?
Re: HR Import Question
par ? ?, Tuesday 21 July 2015, 13:10
 

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
par Russell England, Tuesday 21 July 2015, 23:48
 

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.