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.
Best practice forum (Archived)
HR Import Question
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.
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.