If you have tried to use Windows authentication in the database connection details for your Oracle EPM Integration Agent on-premises data source you may have come across these errors:
Error: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user
So, how DO you use a Windows username and password with an EPM Integration Agent target?
You need to add the mssql-jdbc_auth-9.2.0.x64.dll to your JRE\bin and JRE\lib folder. This is the library used by the MS SQL jdbc driver for Windows authentication.
You should be able to find the library in the .zip file you downloaded containing the MS SQL jdbc driver (sqljdbc_184.108.40.206_enu.zip\sqljdbc_9.2\enu\auth\x64).
Restart the agent and it should now be ready to use Windows authentication. But WAIT, there's one additional step...
You'll need to add an additional parameter to your jdbc connection string to let the driver know that you are using Windows authentication and not native MS SQL authentication:
Et voilà! The EPM Agent will now login to your MS SQL Server database using a Windows user account for authentication.
Happy integrating :)