Skip to main content

Integrating with Relational Database in Orkes Conductor

To effectively manage and optimize your workflows in Orkes Conductor, it's essential to integrate your Conductor cluster with a relational database management system (RDBMS).

The choice of database depends on your specific use case, such as transaction processing, analytical querying, or data warehousing. It also depends on the functionalities you require, including indexing, partitioning, and replication, as well as the specific data management tasks you intend to perform, such as data integrity, concurrency control, and recovery.

This guide will provide the steps for integrating relational database providers with Orkes Conductor.

Steps to integrate with Relational Database

Orkes Conductor supports integration with the Postgres database, and you need to have the following parameters ready: database username, password, and URL.

Now, let’s integrate Postgres database with Orkes Conductor.

  1. Navigate to Integrations from the left menu on your Orkes Conductor console.
  2. Click +New integration button from the top-right of your window.
  3. Under the RDBMS section, choose Relational Database.
  4. Click +Add and provide the following parameters:

Create Relational Database Integration

ParameterDescription
Integration nameProvide a name for the integration.
Database TypeChoose the type of database to integrate. Currently supports Postgres.
Database UserProvide the database username.
Database PasswordProvide the password associated with the username.
Database URLProvide the database URL.

Note: To use this integration for JDBC tasks, ensure that you provide the JDBC connection string in the format: jdbc:database://url/databaseName.
DescriptionProvide a description of your integration.
  1. You can toggle-on the Active button to activate the integration instantly.
  2. Click Save.

Adding Relational Database tables to integration

You have now integrated your Conductor console with the Postgres database. The next step is to integrate with the specific tables.

To add a new table to the database integration:

  1. Navigate to the integrations page and click the '+' button next to the integration created.

Create Relational Database Integration Table from Listed Integrations

  1. Click +New Table.
  2. Provide the table name and an optional description.

Create Relational Database Integration Table

  1. Toggle-on the Active button to enable the table immediately.
  2. Click Save.

RBAC - Governance on who can use Integrations

The integration with the required database is now ready. Next, we should determine the access control to these databases. The permission can be granted to applications/groups within the Orkes Conductor console.

To provide explicit permission to Groups:

  1. Navigate to Access Control > Groups from the left menu on your Orkes Conductor console.
  2. Create a new group or choose an existing group.
  3. Under the Permissions section, click +Add Permission.
  4. Under the Integrations tab, select the required integrations with the required permissions.

Add Permissions for Integrations

  1. Click Add Permissions. This ensures that all the group members can access these integrations in their workflows.

Similarly, you can also provide permissions to applications.

note

Once the integration is set up and the required access is granted, the integration can be utilized for JDBC tasks within Orkes Conductor.