---
title: Automatically build APIs from your Oracle database using DreamFactory
description: DreamFactory will save you and your company hundreds of hours by auto-generating an API automatically for every major SQL database, including Oracle.
image: https://blog.dreamfactory.com/hubfs/Imported_Blog_Media/Screenshot_2016-07-12_10_53_39.png
---

[![DreamFactory logo](https://cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/68d51994d3678214b54acb60_dreamfactory-navbar-logo.svg)](https://www.dreamfactory.com/)

 Products & Services

[AI Data Gateway](https://www.dreamfactory.com/ai-data-gateway/overview)

[Overview Why DreamFactory exists](https://www.dreamfactory.com/ai-data-gateway/overview) [Data Gov, Comp, Security Policy enforcement at the API layer](https://www.dreamfactory.com/ai-data-gateway/ai-data-governance) [Standard API Layer One contract for every backend](https://www.dreamfactory.com/ai-data-gateway/standard-api-layer) [API Gateway Functionality Routing, auth, rate limits, observability](https://www.dreamfactory.com/ai-data-gateway/api-gateway-functionality) [Deployment & Integration Self-hosted, cloud, hybrid](https://www.dreamfactory.com/ai-data-gateway/on-premise-deployment-and-integration) [Developer Productivity Auto-generated, never hand-coded](https://www.dreamfactory.com/ai-data-gateway/ai-development-accelerated) [AI App Architectures Patterns for RAG, agents, MCP](https://www.dreamfactory.com/ai-data-gateway/enterprise-ai-architectures)

AI Data Models

[AIOpenAI](https://www.dreamfactory.com/use-cases/openai) [GGoogle Gemini](https://www.dreamfactory.com/use-cases/google-gemini) [CAnthropic Claude](https://www.dreamfactory.com/use-cases/anthropic-claude-landing) [LMeta Llama](https://www.dreamfactory.com/use-cases/meta-llama) [MMistral AI](https://www.dreamfactory.com/use-cases/mistral) [CoCohere](https://www.dreamfactory.com/use-cases/cohere)

Services and support

[Quickstart Service Packages Expert-led Quickstarts to production](https://www.dreamfactory.com/services-and-support/quickstart-services-packages)

API Management

[Generate & Manage REST APIs From any database, in seconds](https://www.dreamfactory.com/api-management/generate-rest-apis) [Features Security, scripting, self-hosted & more](https://www.dreamfactory.com/api-management/features) [API Generation The complete guide to auto-generated APIs](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) [API Management Concepts, tools, and best practises](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools?_gl=1*jl0njh*_gcl_au*MjQzMjgwMTc3LjE3ODIzMjI3MzY)

 Use Cases

AI Use Cases

[AI Data Access Secure, governed reads for your LLMs](https://www.dreamfactory.com/use-cases/ai-data-access) [MCP Server Drop-in Model Context Protocol](https://www.dreamfactory.com/use-cases/mcp-server) [Legacy Modernization Wrap mainframes with REST](https://www.dreamfactory.com/use-cases/legacy-modernization) [Data Governance Audit every call, enforce every policy](https://www.dreamfactory.com/use-cases/data-governance)

[Customer Case Studies](https://www.dreamfactory.com/case-studies)

[Energy Modernization](https://www.dreamfactory.com/case-studies/energy-snowflake-modernization) [Government Modernization](https://www.dreamfactory.com/case-studies/government-mainframe-oracle-modernization) [Government Business Intelligence](https://www.dreamfactory.com/case-studies/government-sql-server-bi-analyst-queries) [Manufacturing Modernization](https://www.dreamfactory.com/case-studies/steel-manufacturing-sap-erp-modernization) [Financial Services Investor Portal](https://www.dreamfactory.com/case-studies/financial-services-sql-server-investor-portal) [Non-Profit Partner Data Sharing](https://www.dreamfactory.com/case-studies/non-profit-sql-server-partner-data-sharing) [Professional Services Exec Dashboards](https://www.dreamfactory.com/case-studies/professional-services-erp-dashboards) [Education HR and External Data Sharing](https://www.dreamfactory.com/case-studies/education-student-hr-sql-server-mysql-external-data-sharing)

 Industries

Industries

#### [Healthcare HIPAA-grade APIs across EHR, claims, and labs.](https://www.dreamfactory.com/use-cases/healthcare)

#### [Financial Services Portfolios, partners, and portals on one layer.](https://www.dreamfactory.com/use-cases/financial-services)

#### [Government Modernize mainframes without re-platforming.](https://www.dreamfactory.com/use-cases/government)

#### [Manufacturing SAP, MES, and shop-floor data, governed.](https://www.dreamfactory.com/use-cases/manufacturing)

#### [Spotlight How enterprises run on DreamFactory From healthcare to energy to finance — governance baked into every endpoint. Browse case studies →](https://www.dreamfactory.com/case-studies)

 Connectors

SQL Database

[SQL SQL Server](https://www.dreamfactory.com/connectors/sql-server) [OR Oracle](https://www.dreamfactory.com/connectors/oracle) [PG PostgreSQL](https://www.dreamfactory.com/connectors/postgresql) [My MySQL](https://www.dreamfactory.com/connectors/mysql)

NoSQL & Docs

[Dy DynamoDB](https://www.dreamfactory.com/connectors/dynamodb) [Do DocumentDB](https://www.dreamfactory.com/connectors/azure-documentdb) [Mo MongoDB](https://www.dreamfactory.com/connectors/mongodb) [Cb CouchDB](https://www.dreamfactory.com/connectors/couch-db)

Cloud Warehouses

[S3 S3](https://www.dreamfactory.com/connectors/amazon-s3) [Ab Azureblob](https://www.dreamfactory.com/connectors/azure-blob) [FS FTP/SFTP](https://www.dreamfactory.com/connectors/ftp-sftp) [LS Local Storage](https://www.dreamfactory.com/connectors/local-storage)

C & SaaS

[Sf Salesforce](https://www.dreamfactory.com/connectors/salesforce) [API REST / SOAP](https://www.dreamfactory.com/connectors/soap-to-rest)

[See all 30+ connectors](https://www.dreamfactory.com/connectors)

[Blog](https://blog.dreamfactory.com/)

[FREE 30 Minute Demo](https://www.dreamfactory.com/demo)

[![DreamFactory logo](https://cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/68d51994d3678214b54acb60_dreamfactory-navbar-logo.svg)](https://www.dreamfactory.com/)

![hamburger](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/menu-hamburger.svg) ![close](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/close-menu.svg)

 Back to main menu

 Products & Services

 Use Cases

 Industries

 Connectors

[Blog](https://blog.dreamfactory.com/)

[FREE 30 Minute Demo](https://www.dreamfactory.com/demo)

[AI Data Gateway](https://www.dreamfactory.com/ai-data-gateway/overview)

[Overview Why DreamFactory exists](https://www.dreamfactory.com/ai-data-gateway/overview) [Data Gov, Comp, Security Policy enforcement at the API layer](https://www.dreamfactory.com/ai-data-gateway/ai-data-governance) [Standard API Layer One contract for every backend](https://www.dreamfactory.com/ai-data-gateway/standard-api-layer) [API Gateway Functionality Routing, auth, rate limits, observability](https://www.dreamfactory.com/ai-data-gateway/api-gateway-functionality) [Deployment & Integration Self-hosted, cloud, hybrid](https://www.dreamfactory.com/ai-data-gateway/on-premise-deployment-and-integration) [Developer Productivity Auto-generated, never hand-coded](https://www.dreamfactory.com/ai-data-gateway/ai-development-accelerated) [AI App Architectures Patterns for RAG, agents, MCP](https://www.dreamfactory.com/ai-data-gateway/enterprise-ai-architectures)

AI Data Models

[AIOpenAI](https://www.dreamfactory.com/use-cases/openai) [GGoogle Gemini](https://www.dreamfactory.com/use-cases/google-gemini) [CAnthropic Claude](https://www.dreamfactory.com/use-cases/anthropic-claude-landing) [LMeta Llama](https://www.dreamfactory.com/use-cases/meta-llama) [MMistral AI](https://www.dreamfactory.com/use-cases/mistral) [CoCohere](https://www.dreamfactory.com/use-cases/cohere)

Services and support

[Quickstart Service Packages Expert-led Quickstarts to production](https://www.dreamfactory.com/services-and-support/quickstart-services-packages)

AI Data Models

[Generate & Manage REST APIs From any database, in seconds](https://www.dreamfactory.com/api-management/generate-rest-apis) [Features Security, scripting, self-hosted & more](https://www.dreamfactory.com/api-management/features) [API Generation The complete guide to auto-generated APIs](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) [API Management Concepts, tools, and best practises](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools?_gl=1*jl0njh*_gcl_au*MjQzMjgwMTc3LjE3ODIzMjI3MzY)

AI Use Cases

[AI Data Access Secure, governed reads for your LLMs](https://www.dreamfactory.com/use-cases/ai-data-access) [MCP Server Drop-in Model Context Protocol](https://www.dreamfactory.com/use-cases/mcp-server) [Legacy Modernization Wrap mainframes with REST](https://www.dreamfactory.com/use-cases/legacy-modernization) [Data Governance Audit every call, enforce every policy](https://www.dreamfactory.com/use-cases/data-governance)

[Customer Case Studies](https://www.dreamfactory.com/case-studies)

[Energy Modernization](https://www.dreamfactory.com/case-studies/energy-snowflake-modernization) [Government Modernization](https://www.dreamfactory.com/case-studies/government-mainframe-oracle-modernization) [Government Business Intelligence](https://www.dreamfactory.com/case-studies/government-sql-server-bi-analyst-queries) [Manufacturing Modernization](https://www.dreamfactory.com/case-studies/steel-manufacturing-sap-erp-modernization) [Financial Services Investor Portal](https://www.dreamfactory.com/case-studies/financial-services-sql-server-investor-portal) [Non-Profit Partner Data Sharing](https://www.dreamfactory.com/case-studies/non-profit-sql-server-partner-data-sharing) [Professional Services Exec Dashboards](https://www.dreamfactory.com/case-studies/professional-services-erp-dashboards) [Education HR and External Data Sharing](https://www.dreamfactory.com/case-studies/education-student-hr-sql-server-mysql-external-data-sharing)

Industries

#### [Healthcare HIPAA-grade APIs across EHR, claims, and labs.](https://www.dreamfactory.com/use-cases/healthcare)

#### [Financial Services Portfolios, partners, and portals on one layer.](https://www.dreamfactory.com/use-cases/financial-services)

#### [Government Modernize mainframes without re-platforming.](https://www.dreamfactory.com/use-cases/government)

#### [Manufacturing SAP, MES, and shop-floor data, governed.](https://www.dreamfactory.com/use-cases/manufacturing)

SQL Database

[SQL SQL Server](https://www.dreamfactory.com/connectors/sql-server) [OR Oracle](https://www.dreamfactory.com/connectors/oracle) [PG PostgreSQL](https://www.dreamfactory.com/connectors/postgresql) [My MySQL](https://www.dreamfactory.com/connectors/mysql)

NoSQL & Docs

[Dy DynamoDB](https://www.dreamfactory.com/connectors/dynamodb) [Do DocumentDB](https://www.dreamfactory.com/connectors/azure-documentdb) [Mo MongoDB](https://www.dreamfactory.com/connectors/mongodb) [Cb CouchDB](https://www.dreamfactory.com/connectors/couch-db)

Cloud Warehouses

[S3 S3](https://www.dreamfactory.com/connectors/amazon-s3) [Ab Azureblob](https://www.dreamfactory.com/connectors/azure-blob) [FS FTP/SFTP](https://www.dreamfactory.com/connectors/ftp-sftp) [LS Local Storage](https://www.dreamfactory.com/connectors/local-storage)

C & SaaS

[Sf Salesforce](https://www.dreamfactory.com/connectors/salesforce) [API REST / SOAP](https://www.dreamfactory.com/connectors/soap-to-rest)

[See all 30+ connectors](https://www.dreamfactory.com/connectors)

[![back arrow](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/orange-arrow.svg) Blog](https://blog.dreamfactory.com/)

# Automatically build APIs from your Oracle database using DreamFactory

 by Terence Bennett

![calendar icon](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/calendar-icon.svg) January 5, 2026

Table of contents

RECOMMENDED ARTICLES

- [A Complete Guide to API Generation](https://blog.dreamfactory.com/a-complete-guide-to-api-generation)
- [10 Best API Management Tools](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools)
- [Creating a Microsoft SQL Server API in Less Than 5 minutes with DreamFactory](https://blog.dreamfactory.com/creating-a-microsoft-sql-server-api-in-less-than-5-minutes-with-dreamfactory)
- [Hasura vs. DreamFactory: A Comprehensive Comparison](https://blog.dreamfactory.com/hasura-vs-dreamfactory)
- [Build A Snowflake REST API in Less Than 5 Minutes](https://blog.dreamfactory.com/generate-a-snowflake-rest-api-in-less-than-5-minutes)

DreamFactory will save you and your company hundreds of hours by auto-generating an API automatically for [every major SQL database](https://www.dreamfactory.com/hub/categories/databases/), including Oracle. In this tutorial, we’re going to walk through the process of connecting DreamFactory to your [Oracle](https://www.dreamfactory.com/hub/integrations/oracle/) database, review the features [automatically built](https://blog.dreamfactory.com/everything-you-know-about-rest-apis-is-wrong/) into DreamFactory that’ll help you manage and customize your API, and go over scripting support and security features.

View the full webinar here if you prefer a [video format](https://www.youtube.com/watch?v=uYeGL1_OAKA).

Oracle database support is a feature of DreamFactory’s Silver package — you can [request a demo here](https://www.dreamfactory.com/demo).

Read more about [instant API creation with Oracle.](https://blog.dreamfactory.com/instant-api-tutorial-for-oracle-databases/)

## Connecting your Oracle database to DreamFactory

For this tutorial, we’re going to make use of the free hosted version of DreamFactory. Make sure you have an Oracle database with some data in it to start, then sign up for a [free 14 day hosted trial](https://genie.dreamfactory.com/).

Once you’re in the DreamFactory dashboard, go to *Services* > *Create* and enter the credentials for your Oracle database. DreamFactory will automatically generate an API from your database, leaving the data in place.

![Screenshot_2016-07-12_10.53.39.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-12_10_53_39.png?width=1024&name=Screenshot_2016-07-12_10_53_39.png)

*Connect your DreamFactory account to your Oracle database.*

*![Screenshot_2016-07-12_12.01.54.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-12_12_01_54.png?width=1024&name=Screenshot_2016-07-12_12_01_54.png)*

*After you choose Oracle, database fields will pop in below.*

![Screenshot_2016-07-12_12.02.05.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-12_12_02_05.png?width=745&height=433&name=Screenshot_2016-07-12_12_02_05.png)

*Configuration fields are available in the Config tab after choosing “Oracle” under the Info tab.*

![Screenshot_2016-07-12_12.38.20.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-12_12_38_20.png?width=745&height=432&name=Screenshot_2016-07-12_12_38_20.png)

*Your new Oracle service will show up under Manage after saving.*

## Overview of DreamFactory’s API automation features

### Your API, documented with Swagger

DreamFactory will automatically introspect your database to know what schema is available — no need to do any additional coding or configuration.

Let’s check out the schema first. From your dashboard, click *Schema* and then select your Oracle server. Here, you can see the list of tables associated with your database.

![Screenshot_2016-07-12_11.41.03.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-12_11_41_03.png?width=745&height=440&name=Screenshot_2016-07-12_11_41_03.png)

*Choosing your Oracle database from the Schema tab*

![Screenshot_2016-07-12_11.41.59.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-12_11_41_59.png?width=745&height=314&name=Screenshot_2016-07-12_11_41_59.png)

*Viewing the list of tables available in DreamFactory from your Oracle server*

Note that you can add alias for your database — for example, you’d want to do this if your database is long or complex, or you don’t want to expose the table name for security reasons.

DreamFactory also automatically figures out the foreign key relationships within your database defined by default, which you can see at the bottom of the page:

![Screenshot_2016-07-12_11.43.08.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-12_11_43_08.png?width=745&height=429&name=Screenshot_2016-07-12_11_43_08.png)

*Foreign key relationships are automatically found and shown.*

Next, let’s check out [API, documented](https://www.dreamfactory.com/features/api-documentation/) with [Swagger](https://blog.dreamfactory.com/why-we-like-swagger-for-api-docs/). Click on *API Docs*, then click on *Oracle* to see all the operations available generated for you in DreamFactory with Swagger.

![Screenshot_2016-07-11_12.57.52.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-11_12_57_52.png?width=745&height=359&name=Screenshot_2016-07-11_12_57_52.png)

*Live API documentation within DreamFactory*

DreamFactory gives you all the functionality you’d expect and want with an API, such as schema operations for creating, deleting, and updating tables, data operations like updating and deleting individual records, and more.

If you update or change your Oracle database, you don’t need to write any additional code to bring the tables in — you just need to clear your service cache and DreamFactory will automatically import new information about your database.

### Testing your DreamFactory-powered API

The structure of your API is very SQL-like, and you can alter the fields and results by changing the offset, adding limits, setting up ordering, and more — all automatically offered by DreamFactory.

You can try out the API calls directly from this documentation. Below, we’re requesting the “contact” table under *GET /oracle/\_schema/{table\_name}* by adding “contact” to the *table\_name* input box and clicking the “Try it now” button at the bottom.

![Screenshot_2016-07-13_08.49.17.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-13_08_49_17.png?width=745&height=442&name=Screenshot_2016-07-13_08_49_17.png)

*Click the “Try it out!” button at the bottom to test API calls and see API responses.*

![Screenshot_2016-07-13_08.50.36.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-13_08_50_36.png?width=745&height=448&name=Screenshot_2016-07-13_08_50_36.png)

*The response is returned as JSON directly within the documentation.*

The information is returned as JSON and can be filtered in many ways such as requesting only 10 records at a time). You can also pull in related data — in the related box, add “\*”  (without quotes) and click the “Try it now” button again. DreamFactory will bring back your data, this time including foreign key relationships as well.

![Screenshot_2016-07-13_08.54.48.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-13_08_54_48.png?width=745&height=447&name=Screenshot_2016-07-13_08_54_48.png)

*After putting in \* in the related field, the response now includes related data.*

Above, we’re filtering for *last\_name=Huang*, which’ll bring back only records with that last name. This is a great way to test out your new API without having to go to the command line.

### Virtual foreign key relationships using DreamFactory’s DataMesh

What if you don’t have an established foreign key relationship, but still have a logical relationship? For example, CRM data in one database, and order information in another. [DreamFactory’s DataMesh](https://www.dreamfactory.com/resources/video/how-use-data-mesh-virtual-foreign-keys) feature can automatically associate relationships between two tables, regardless of database type.

To demonstrate this, we’re going to head to the Schema tab on on DreamFactory dashboard, and pick our table. Then, choose “Virtual Foreign Key” and “Foreign Reference Service” in our list of relationships.

![Screenshot_2016-07-13_08.59.08.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-13_08_59_08.png?width=745&height=380&name=Screenshot_2016-07-13_08_59_08.png)

*Under Schema, choose your database and table, click your primary key, and you can specify Virtual Foreign Key and Foreign Reference Service to tie information together with DreamFactory’s DataMesh.*

Then we can choose the reference service and the appropriate table, and DreamFactory will automatically query both databases to pull in information.

Back in the API Docs area, we can test the connection by clicking the “Try it now!” button. In the JSON results seen below, we can see that it’s pulling in information from the other database. No need to write any additional code!

![Screenshot_2016-07-13_09.00.47.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-13_09_00_47.png?width=745&height=395&name=Screenshot_2016-07-13_09_00_47.png)

*Inspecting the documentation, we can see that MySQL’s information is automatically related.*

## Adding custom scripting with pre- and post-process scripts

DreamFactory also allows you to add pre- and post-process scripts in multiple programming languages, including JavaScript using V8Js, Node.js, PHP, and Python.

![Screenshot_2016-07-13_09.03.00.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-13_09_03_00.png?width=745&height=386&name=Screenshot_2016-07-13_09_03_00.png)

*This post-process scripts sets up a call to Amazon’s SNS service.*

For example, with pre-process scripts you can add additional validation checks. Leverage post-process scripts to set up external API calls to services like Amazon SNS to notify you via text-message of new API requests to your service. DreamFactory scripting support adds flexible ways to connect with different services, increasing the power of your automatically built API.

## Security features

API security is critical and DreamFactory offers a strong set of options to lock down access to your data, including extensive user management.

On a basic level, DreamFactory supports roles and you can limit access to your APIs with those roles. You can choose to limit access to particular tables, or limit operations that the role has access to (such as GET or POST), limit access to only the API or only via scripts, and more.

![Screenshot_2016-07-13_09.05.09.png](https://blog.dreamfactory.com/hs-fs/hubfs/Imported_Blog_Media/Screenshot_2016-07-13_09_05_09.png?width=745&height=449&name=Screenshot_2016-07-13_09_05_09.png)

*Setting up allowed access under the Roles screen.*

You can even add advanced filters, such as only allowing owners to view data, as seen above. All of these options can be changed on the fly through the DreamFactory configuration.

## All this and more through DreamFactory’s automatic API generation for Oracle

As you can see, DreamFactory provides a complete and effective suite of tools to add an API to Oracle databases, saving you and your company hundreds of hours that you would spend coding these features otherwise.

For more information about DreamFactory, please see our [main website](https://dreamfactory.com), [our documentation](https://wiki.dreamfactory.com), and [user guide](https://guide.dreamfactory.com). We also have [more video walkthroughs available here](https://wiki.dreamfactorycom/DreamFactory/Videos).

---

[**Watch the full video: Instant APIs for Oracle Databases**](https://www.dreamfactory.com/videos/oracle-database-apis)

TAGS: [JSON,](https://blog.dreamfactory.com/tag/json) [API Management,](https://blog.dreamfactory.com/tag/api-management-2) [Services,](https://blog.dreamfactory.com/tag/services) [Oracle,](https://blog.dreamfactory.com/tag/oracle) [SQL,](https://blog.dreamfactory.com/tag/sql) [security,](https://blog.dreamfactory.com/tag/security) [REST,](https://blog.dreamfactory.com/tag/rest) [Swagger,](https://blog.dreamfactory.com/tag/swagger) [DreamFactory,](https://blog.dreamfactory.com/tag/dreamfactory) [API Automation,](https://blog.dreamfactory.com/tag/api-automation) [Data Sources,](https://blog.dreamfactory.com/tag/data-sources) [API Design,](https://blog.dreamfactory.com/tag/api-design) [SOAP,](https://blog.dreamfactory.com/tag/soap) [Database,](https://blog.dreamfactory.com/tag/database) [API](https://blog.dreamfactory.com/tag/api)

![Terence Bennett](https://blog.dreamfactory.com/hs-fs/hubfs/1624046620145.jpg?width=100&height=100&name=1624046620145.jpg)

Terence Bennett

Terence Bennett, CEO of DreamFactory, has a wealth of experience in government IT systems and Google Cloud. His impressive background includes being a former U.S. Navy Intelligence Officer and a former member of Google's Red Team. Prior to becoming CEO, he served as COO at DreamFactory Software.

 Stay Connected with   
 The Connector Newsletter!

 Subscribe to stay up-to-date with DreamFactory's latest product updates, API best practices, and tech humor in your inbox.

[![Dreamfactory Logo](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/Megamenu-logo.svg)](https://www.dreamfactory.com/)

[Call Sales +1 (415) 993-5877](tel:+14159935877)

Open – Mon–Fri 9–5 PT

[FREE 30 Minute Demo](https://www.dreamfactory.com/demo)

#### Follow us

- [GitHub](https://github.com/dreamfactorysoftware/dreamfactory)
- [Facebook](https://www.facebook.com/dfsoftwareinc/)
- [X (Twitter)](https://twitter.com/dfsoftwareinc)
- [LinkedIn](https://www.linkedin.com/company/dreamfactory-software)
- [YouTube](https://www.youtube.com/c/dreamfactorysoftware)

### Features

[Features](https://www.dreamfactory.com/features) [Self hosted](https://www.dreamfactory.com/features#self) [API Generation](https://www.dreamfactory.com/features#api) [Security](https://www.dreamfactory.com/features#secure) [Customization](https://www.dreamfactory.com/features#custom) [Pricing](https://www.dreamfactory.com/pricing)

### Installers

[Linux](https://www.dreamfactory.com/features#installer) [Docker](https://www.dreamfactory.com/features#installer) [Kubernetes](https://www.dreamfactory.com/features#installer)

### API Resources

[Documentation](https://docs.dreamfactory.com/) [Case Studies](https://www.dreamfactory.com/stories) [White Papers](https://www.dreamfactory.com/resources/whitepapers) [Academy](https://www.dreamfactory.com/academy) [API Calculator](https://calculator.dreamfactory.com) [Open Source](https://github.com/dreamfactorysoftware)

### Company

[Blog](https://blog.dreamfactory.com/) [Hub](https://www.dreamfactory.com/hub) [About us](https://www.dreamfactory.com/about) [Partners](https://www.dreamfactory.com/partners) [Support](https://www.dreamfactory.com/support) [Connectors](https://www.dreamfactory.com/connectors) [Contact Us](https://www.dreamfactory.com/demo)

 © 2025 DreamFactory. All rights reserved.

[Terms of Use](https://www.dreamfactory.com/terms-of-use) [Privacy Policy](https://www.dreamfactory.com/privacy-policy) [LLMs](https://www.dreamfactory.com/llms.txt)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Terence Bennett",
    "url" : "https://blog.dreamfactory.com/author/terencebennett"
  },
  "dateModified" : "2024-06-28T11:16:37.983Z",
  "datePublished" : "2026-01-06T00:00:00.000Z",
  "headline" : "Automatically build APIs from your Oracle database using DreamFactory",
  "image" : [ "https://blog.dreamfactory.com/hubfs/Imported_Blog_Media/Screenshot_2016-07-12_10_53_39.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.dreamfactory.com/automatically-build-apis-from-your-oracle-database-using-dreamfactory",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.dreamfactory.com/hubfs/DreamFactory%20-%20Orange%20-%20Transparent-1.png"
    }
  }
}
```