Modern SQL Tool & Data Integration Platform for Oracle Fusion Cloud
Free JDBC driver for Oracle Fusion. Build data pipelines to AWS, Google Cloud, Azure, OCI using DBeaver—no ETL tool required.
OFJDBC is a free, open-source JDBC driver that transforms Oracle Fusion Cloud into a fully accessible data source. Unlike commercial query tools or OTBI's web interface, OFJDBC provides standard JDBC connectivity, enabling seamless integration with modern data platforms, BI tools, and cloud services.
When combined with DBeaver—the premier database-agnostic IDE—OFJDBC becomes a complete data integration platform. Extract data from Oracle Fusion, load it into AWS S3, Google Cloud Storage, Azure Blob Storage, or OCI Object Storage, query it with Athena, BigQuery, or OCI Data Lake, and visualize it in QuickSight, Looker, Power BI, or Oracle Analytics Cloud.
OFJDBC & DBeaver:
OFArrow (Arrow Flight SQL):
AI Companions:
Execute SQL queries directly against Oracle Fusion Cloud without creating OTBI reports. Get instant results for troubleshooting, analysis, and data exploration with DBeaver's intelligent autocomplete.
Build complete ETL pipelines from Oracle Fusion to AWS (S3, Athena, QuickSight), Google Cloud (BigQuery, Cloud Storage), Azure (Synapse, Blob Storage, Power BI), or OCI (Object Storage, Data Lake, Analytics Cloud).
Connect QuickSight, Power BI, Tableau, or Looker to Oracle Fusion data via cloud data warehouses (Athena, BigQuery, Synapse) populated by OFJDBC.
Seamlessly integrates with DBeaver, the premier free database IDE. Use professional-grade SQL tooling without any compatibility issues or limitations.
DBeaver caches Oracle Fusion metadata locally for instant autocomplete, unlike SQL Developer. Get real-time error detection, syntax highlighting, and intelligent table/column suggestions as you type.
Export query results to Parquet (partitioned), CSV, JSON, Excel, or load directly into DuckDB, PostgreSQL, MySQL, or cloud databases. Build data lakes without custom scripts.
OFJDBC is the open-source foundation—supporting both interactive use (DBeaver) and programmatic access (any JVM platform via standard JDBC). These free companion tools extend the ecosystem further:
Start chatting with your ERP. A specialized Retrieval-Augmented Generation (RAG) engine designed for LLMs (like Claude, Gemini, etc.).
It empowers your AI agent to retrieve schema context locally, validate intent via semantic parsing, and fetch live business data directly from Oracle Fusion Cloud.
OFJDBC works with any JDBC-compatible database tool. DBeaver is the recommended choice and provides the best experience—it's free, full-featured, and works perfectly with OFJDBC. Other JDBC clients like IntelliJ IDEA Database Tools, Eclipse Data Tools, and JetBrains DataGrip also work.
OFJDBC provides similar functionality to commercial tools but is free and open-source. It's perfect for consultants, small teams, or anyone who prefers using standard database tools like DBeaver.
OFJDBC is a standard JDBC driver, so it works programmatically in any JVM-based platform (Java, Scala, Kotlin, Groovy). This includes ETL tools like Apache Airflow (using JDBC operators), Talend, Pentaho, Apache NiFi, and any Java application. OFArrow is only needed for non-JVM languages (Python, R, JavaScript, Go, Rust) or when you prefer Arrow Flight SQL protocol over JDBC.
OFJDBC is a JDBC driver—works in DBeaver (interactive) and any JVM platform (programmatic). OFArrow is an Arrow Flight SQL server that wraps OFJDBC—needed for non-JVM languages or when you want REST API access. Both access the same Oracle Fusion data.
Yes! Apache Airflow has built-in JDBC support through operators like JdbcOperator and JdbcHook. You can use OFJDBC with Airflow to build ETL pipelines that extract data from Oracle Fusion. Alternatively, if you prefer Python-native code, use OFArrow with Airflow's PythonOperator and Arrow Flight SQL clients.
OFJDBC has an AI companion: Oracle Fusion RAG Engine (ofrag) - a specialized RAG engine that enables LLMs (like Claude, Gemini, etc.) to intelligently query and analyze Oracle Fusion data by providing local schema context and live execution capabilities. The RAG Engine performs semantic parsing and allows your AI agent to "chat" with your ERP data. It is free but closed source.
Yes. OFJDBC connects directly from your machine to Oracle Fusion Cloud using your credentials. No data passes through third-party servers, and the code is fully transparent on GitHub.