4.2.1 Create a Database Profile

Create a database profile to define connection parameters, such as the type of database engine, supported capabilities, connection URL, user credentials, and secure wallet options.

Prerequisites

To create a database profile that you can use later to generate vector embeddings, you must select embedding generation as a capability. Ensure that an Oracle Database is already configured with an embedding generation LLM model installed in the database. For information about importing and configuring embedding models in Oracle Database, see Generate Vector Embeddings in Oracle AI Vector Search User's Guide. Later, you can select this database profile while creating a new LLM Definition with OracleDB selected as the LLM model provider.

1. Open the navigation menu and click Connectors.
2. Click Database.

   The Database profile list page opens. All the database profiles that you have defined are displayed in a table.

3. Click .
   The New Database Profile dialog box appears.
4. Enter the following information.
   • Name: Enter a unique, descriptive name for your database profile. The name can be up to 128-characters long. Use only letters, numbers, underscores (_), and hyphens (-). Spaces and other special characters are not supported. This helps distinguish it from other profiles, especially if you manage multiple database connections.

   • Description: Optional. Add details describing the purpose or scope of this database profile, such as which application, workflow, or environment it serves.

   • Engine: Select the database engine that you want to use. Select ORACLE to use Oracle Database or POSTGRES to use PostgreSQL database.

   • Username: Enter the username required to authenticate and connect to the database.

   • Password: Enter the password for the specified database user name. Click the eye icon to show/hide the value if needed. Ensure you use strong credentials and handle them securely.

   • URL: Provide the full JDBC connection URL to the database. This typically includes the protocol, hostname, port, and database service identifier. For example, jdbc:oracle:thin:@host:port/service for an Oracle Database.

   • Max Connection Pool Size: Configure the maximum number of parallel database connections that MicroTx Workflows can create using this database profile.
5. Enter the following additional configuration information if you select ORACLE as the Database Engine.
   • Capabilities: Specifies the supported features for the database profile. Select one or more of the following values based on your use case.
     • RELATIONAL: Indicates support for traditional relational database operations, such as SQL queries and transactions.
     • VECTOR: Indicates the database profile can be used for vector-based operations, such as similarity searches or AI/ML vector storage and retrieval.
     • EMBEDDING_GENERATION: Indicates that the database profile is used to generate vector embeddings.

   • Wallet File (optional): Search and upload the Oracle Wallet file if your database connection requires it. The wallet file contains encrypted credentials and security details for secure authentication.

   • Wallet Password: Enter the wallet password if you are using an Oracle Wallet for secure credential storage. Click the eye icon to show/hide the value if needed. This is used for decrypting wallet files and securing connections.

6. Click Test to ensure that you can establish a connection with the provided details.
   If there are any issues, an error message is displayed. Note down the error message so that you can troubleshoot the issue, and then click Close.
7. Click Submit to create the new database profile and save your configuration.

You can use the new database profile for secure connections within workflows, tasks, and agents.