Is there Oracle DB Support in Temporal Server?

Community Support
1

Hi Team,

We have a use case to persist the followings in Oracle DB:

  • Tasks: Tasks to be dispatched.
  • State of Workflow Executions:
    • Execution table: A capture of the mutable state of Workflow Executions.
    • History table: An append only log of Workflow Execution History Events.

Is it possible?

2

It is possible in theory, as Temporal has a well-defined API that a specific DB binding can implement. It already supports MySQL, PostgreSQL, SQLite, and Cassandra. So Oracle can be added by implementing this interface.

AFAIK no one has implemented the Oracle binding yet.

3

Hi. I’m looking for information to understand solution and estimate effort to implement Oracle or SQLServer new binding.
Could you share any reference to mentioned API DB binding documentation?

4

Hi, Is Oracle binding available now in April 2024? If not, any idea if it’s in future implementation list?

5

It is not in the roadmap.

6

What about now? Is Oracle considered in the road map yet? Thank you in advance!

7

Still not part of the roadmap.

8

Is Oracle part of the roadmap now?

9

No, as it is not an open source database. Temporal is open source so anyone can contribute and maintain such a binding

10

@maxim Can we have an alpha/beta integration implemented using a free tier Oracle Database XE or Oracle AI Database Free?

That would be a starting point for many companies that uses Oracle…

They are available as docker container:

  1. Oracle Database 26ai (23.26.1) Enterprise Edition and Free
  2. Oracle Database 21c (21.3.0) Express Edition (XE)