My Oracle Support Banner

ODBC JDBC Bridge with ODI 12c and JDK 1.8 for Microsoft Excel and Microsoft Access (Doc ID 2453429.1)

Last updated on MAY 08, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Goal

In older releases of Oracle Data Integrator (ODI), data could be loaded from Microsoft Excel or Microsoft Access using the ODBC-JDBC bridge built into Java and using the sun.jdbc.odbc.JdbcOdbcDriver driver.  However, Oracle removed the ODBC-JDBC bridge in Java 1.8.

Starting with version 12.2.1.0.0, ODI no longer supports Java releases earlier than Java 8.

How can ODI be used to load data that requires access to ODBC data sources such as Microsoft Excel or Microsoft Access?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.