Skip to main content
Feedback

OP Database with RAG - Partner connector

info

Partner connectors developed by our Tech Partners and published on the Boomi platform provide seamless integration solutions for customers. Customers will initiate support for these connectors through the Boomi Support Portal, where tickets will be triaged to the respective partner. The partner or their designated third party is responsible for ongoing support, including troubleshooting, bug fixes, and resolving related issues.

The OP Database with RAG — Partner Connector allows you to process or retrieve data from any JDBC-supported database using Database drivers. It enables you to Insert, Get, Update, Upsert, Delete, and Execute Stored procedures on the data available in the database.

note

The documentation for this connector is provided by a partner.

Connector configuration

To configure the connector, set up the following two components:

  • Connection: The connection contains all connection settings.

  • Operation: Represents an action used to interact with the provider.

Prerequisites

The connector requires the following:

  • Database connection information, including server host/IP address and port, user name, and password. The user name and password configured on the database must have sufficient permissions to access the objects required by the integration scenario. For more information, see your database documentation.

  • A database and tables. The Database connector does not create tables or other objects.

  • An installed and configured JDBC driver if using the custom database type.

  • Runtime running with Java 8 or Java 11

Supported Editions

The connector supports any JDBC-compliant or ODBC-compliant database (tested with PostgreSQL, MySQL, Microsoft SQL Server, Oracle, MariaDB, IBM DB2, SAP HANA database).

Please note that while the connector offers comprehensive functionality with these databases, there may be limitations with certain databases or drivers. For example, the MongoDB JDBC driver has limited support, typically allowing only select statements in the cloud environment.

Runtime cloud uses high-level Java security policies, meaning some JDBC drivers may not work.

Tracked Properties

This connector includes the following predefined tracked properties:

  • SQL Rows Affected (sqlRowsAffected): Tracks the number of rows affected by the SQL operation.
  • SQL Query (sqlQuery): Records the SQL query executed by the connector.
  • Batch Number (batchNumber): Tracks the batch number associated with the operation.
  • Transaction User Id (transactionUserId): The user provided transaction identifier.
  • Transaction Internal Id (transactionInternalId): Records the internal identifier for the transaction.
  • Transaction Status (transactionStatus): Logs the status of the transaction.

See the topic Adding tracked fields to a connector operation to learn how to add a custom tracked field.

On this Page