File System Access data is retrieved from the File Reporter database using an SQL connection provided by a JDBC driver. Depending on the current configuration of Identity Governance, an additional JDBC driver file might be required in the Identity Governance Application Server class path.
If Identity Governance and File Reporter are configured for the same type of database (for example, both are configured for PostgreSQL), then no further configuration of JDBC drivers is required, and you can continue with configuration of the File System Access Collector.
However, if both systems are running with different database types (for example, Identity Governance is configured for PostgreSQL and File Reporter is configured for Microsoft SQL Server), then an additional JDBC driver might be required.
Identity Governance 3.5 runs with Java 8. Any additional JDBC drivers installed must be:
Compiled for Java 8
Built for the JDBC 4.2 specification
If Identity Governance is configured for Microsoft SQL Server, no other JDBC dependencies are needed.
To install the Microsoft SQL Server JDBC driver:
Download an appropriate driver from Microsoft.
For a list of supported drivers and databases, see https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-2016.
Generally, you should install the latest version that supports Java 8 with JDBC 4.2.
Extract the driver file from the archive, paying attention to find the one built for Java 8.
Copy the JDBC driver to the Identity Governance application server's lib folder.
For installations on Linux, this is in a folder such as /opt/netiq/idm/apps/tomcat/lib.
For installations on Windows, this is in a folder such as C:\netiq\idm\apps\tomcat\lib.
Restart the Identity Governance Tomcat service.
For example, with the Microsoft JDBC driver 7.0 archive sqljdbc_7.0.0.0_enu.tar.gz, copy the included file from sqljdbc_7.0/enu/mssql-jdbc-7.0.0.jre8.jar to the application folder listed above, then restart Tomcat.
If Identity Governance is configured for PostgreSQL, no other JDBC dependencies are needed.
To install the PostgreSQL JDBC driver:
Download an appropriate driver for PostgreSQL.
For a list of supported drivers see https://jdbc.postgresql.org/about/about.html and https://jdbc.postgresql.org/download.html.
Generally, you should install the latest version supports Java 8 with JDBC 4.2.
Copy the JDBC driver to the Identity Governance application server's lib folder.
For installations on Linux, this is in a folder such as /opt/netiq/idm/apps/tomcat/lib.
For installations on Windows, this is in a folder such as C:\netiq\idm\apps\tomcat\lib.
Restart the Identity Governance Tomcat service.
For example, download the PostgreSQL JDBC driver file postgresql-42.2.5.jar and copy it to the application folder listed above, then restart Tomcat.