Does Oracle Discoverer 11g work with Oracle Database 19c?

The compatibility of older tools like Discoverer 11g with the security and network changes introduced in Oracle Database 19c is problematic. The error ‘No matching authentication protocol’ strongly suggests that the older client libraries or authentication methods used by Discoverer 11.1.1.7 are no longer compatible or enabled by default in your 19c database instance.

This lack of compatibility emphasizes the urgency of finding a reliable replacement. Blitz Report is positioned as the primary Oracle Discoverer replacement, offering fully automated migration features to quickly convert your existing reports, thereby eliminating dependencies on deprecated tools and ensuring continuous reporting capabilities.

The automated migration feature allows for the importing of worksheets directly into Blitz Report, handling the underlying SQL and metadata derived from Discoverer’s business areas/folders. Once imported, the report relies on standard EBS/database connections, bypassing the problematic Discoverer 11g authentication stack entirely.

Yes, Blitz Report supports accessing external data sources. Provided you configure Oracle Heterogeneous Services and ODBC connections, Blitz Report can connect Oracle E-Business Suite to external databases like Vertica or MySQL via database links, supporting your complex data requirements.

You can use the Blitz Report functionality developed for DBAs to run custom queries utilizing AD_PATCH.IS_PATCH_APPLIED directly from EBS forms, providing quick verification of patch status related to any compatibility fixes.

Yes, the Blitz Report software is completely free to use for your first 30 reports. This also usually includes a guided installation session with the team.