In order for ColdFusion to authenticate via OAuth to check the nightly email from Impexium, a custom paid JDBC driver is necessary.
https://www.cdata.com/drivers/office365/jdbc/
https://cdn.cdata.com/help/CXH/jdbc/default.htm
When the Impexium Report Server nightly process completes (copying LIVE to RS) an email is sent to impexium-notifications@alta.org. To kickoff the nightly script, ColdFusion checks for this email before continuing.
This is all setup on the Hostek web1 server.
In the ColdFusion Administrator’s Datasources, there is an “Office365” connection which points to the JDBC driver’s JAR file and has a connection string.
http://172.16.1.2:8500/CFIDE/administrator/index.cfm
The JAR file along with a REQUIRED License file are found in C:\ColdFusion2021\cfusion\wwwroot\WEB-INF\lib
A Settings file, which contains the encrypted password, is found in C:\CDataOAuth
