Oracle
Introduction
Hasura enables you to connect to Oracle databases to automatically build a GraphQL API based on your database schema.
At present, our Oracle integration is available in Hasura Cloud and Docker environments, where you can run Hasura GraphQL Engine and connect the Oracle GraphQL Data Connector to it. For more information on GraphQL Data Connectors check out our blog post on the topic.
To get started with Oracle:
- In Hasura Cloud, check out our Getting Started with Oracle in Hasura Cloud guide
- In a Docker environment, check out our Getting Started with Docker guide
- Hasura GraphQL Engine
v2.24.0
onwards - Hasura supports most databases with standard implementations of Oracle 18.0 and higher including Amazon RDS.
Hasura currently supports queries, mutations (INSERT, UPDATE, DELETE), table relationships, remote relationships and permissions on Oracle.
Note that Hasura doesn't yet support the ability to modify the database schema for Oracle, so the database you connect to should already contain tables and data. You should also ideally have access to it outside of Hasura to modify the schema.
Feature Support
{' '}
Feature | Oracle |
Remote Relationships | ✅ |
Views | ✅ |
Default Values | ✅ |
Queries
{' '}
Feature | Oracle |
Simple | ✅ |
Nested Object | ✅ |
Aggregation | ✅ |
Filter / Search | ✅ |
Sort | ✅ |
Distinct | ✅ |
Paginate | ✅ |
Multiple Arguments | ✅ |
Multiple Queries | ✅ |
Variables / Aliases / Fragments | ✅ |
Mutations
{' '}
Feature | Oracle |
Insert | ✅ |
Upsert | ✅ |
Update | ✅ |
Delete | ✅ |
Multiple per Request | ✅ |
Subscriptions
{' '}
Feature | Oracle |
Value of Field | ❌ |
Updates to Rows | ❌ |
Value of Derived Field | ❌ |
Streaming Subscriptions | ❌ |
Event Triggers
{' '}
Feature | Oracle |
INSERT | ❌ |
UPDATE | ❌ |
DELETE | ❌ |
MANUAL | ❌ |