ODI 14.1.2.0.0 Reverse Engineering Issue with Apache Cassandra 5.0.8
Environment
Oracle Data Integrator (ODI): 14.1.2.0.0
Apache Cassandra: 5.0.8
JDBC Driver: WebLogic bundled Cassandra JDBC driver (default driver available with ODI 14c)
Reverse Engineering Mode: Local Agent
Issue Description
I am trying to integrate Apache Cassandra 5.0.8 with Oracle Data Integrator (ODI) 14.1.2.0.0.
I have completed all the required ODI Topology configurations, including:
Creating the Cassandra Data Server
Configuring the Physical Architecture
Configuring the Logical Architecture
Mapping the Context
Testing the JDBC connection successfully
The JDBC connection test completes successfully, confirming that ODI can connect to the Cassandra database.
Next, I created a new Model and attempted to perform Reverse Engineering using the Local Agent. The reverse engineering process completes without reporting any errors. However, none of the existing Cassandra tables are imported into the ODI Model.