Connecting Power BI (via SQL Server Analysis Services) to an Apps10 Oracle database fails with 'ORA-28040: No matching authentication protocol' — what's causing this, and how is it generally resolved?

All FAQ questions / Integrations and APIs

Answer

This is a well-known, generic Oracle connectivity issue, not something specific to IFS — it happens when the Oracle client library being used (by SSAS/Power BI's Oracle connector) doesn't support the minimum authentication protocol version the database server is configured to require (Oracle databases increasingly enforce stronger authentication protocols by default). The general fix is adjusting the ALLOWED_LOGON_VERSION_SERVER (and/or ALLOWED_LOGON_VERSION_CLIENT) parameter in the database's sqlnet.ora file to permit the older/weaker authentication version your specific Oracle client actually supports, or alternatively upgrading the Oracle client library used by SSAS/Power BI's Oracle connector to a version that supports the newer required protocol — the Power BI/Oracle-connectivity community has documented this exact error and fix extensively, since it affects any BI tool connecting to a modern, securely-configured Oracle database, not just IFS specifically.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Integrations and APIs questions