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:
Zero-infrastructure data access for non-JVM languages. Single JAR file that exposes Oracle Fusion via Arrow Flight SQL protocol and HTTP REST API—perfect when you can't use JDBC directly.
Perfect for: Python/R Data Scientists, JavaScript/Go/Rust developers, DevOps shell scripts, non-JVM ETL tools
Export Formats: CSV, JSON, Excel, Parquet, Hive-partitioned
AI-powered SQL development for Oracle Fusion. Model Context Protocol (MCP) server that integrates with Claude AI for intelligent query assistance.
More advanced than ChatGPT assistant since it uses Claude's reasoning models, while OpenAI restricts advanced reasoning models for custom GPTs.
Instant metadata assistance via ChatGPT. Custom GPT trained as an Oracle Fusion Metadata Companion (OFMCP).
Note: OpenAI currently restricts custom GPTs from using advanced reasoning models, so the Claude MCP Server provides more sophisticated analysis.
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 two AI companions: (1) Claude MCP Server - integrates with Claude AI for metadata-aware SQL development with advanced reasoning capabilities, and (2) ChatGPT Assistant - a custom GPT for exploring Oracle Fusion metadata and getting query templates. The Claude MCP Server is more advanced because it uses Claude's reasoning models. Both are 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.