---
title: Oracle
description: Learn how to connect Oracle Database in Infoveave to query enterprise relational data for powerful analytics, dashboards, and reports.
---

import { Aside, Steps } from '@astrojs/starlight/components';
import { MediaPlayerComponent } from "../../../../../components/video-player";
import RunScript from "../../../../../components/RunScript.astro";

# Oracle

<MediaPlayerComponent
  video="oracle-connection.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 6,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 6,
    "end": 10,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 10,
    "end": 14,
    "text": "Select Oracle Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Database' section and click on the 'Oracle' option."
  },
  {
    "start": 14,
    "end": 34,
    "text": "Configure Oracle Connection Details",
    "description": "In the 'New Oracle Connection' dialog, enter the connection details. Type 'Oracle Connection' for the Name, 'localhost' for the Server, 'system' for the Username, your password in the Password field, 'FREE' for the Database, and 'SYSTEM' for the Schema. Ensure the Port is set to '1521'."
  },
  {
    "start": 34,
    "end": 36,
    "text": "Validate Oracle Connection",
    "description": "Click the 'Validate' button to verify that your entered Oracle connection details are correct and establish a successful connection."
  },
  {
    "start": 36,
    "end": 39,
    "text": "Save New Oracle Connection",
    "description": "After the connection validates successfully, click the 'Save' button to create and add the new Oracle connection to your list of connections."
  }
]
    }
  poster="/images/introduction-poster.png"
  posterText="Creating Oracle Connection"
  client:load
/>

Oracle connection helps you connect to an **Oracle database** and run queries directly from Infoveave.



## Adding an Oracle Connection

To create a new Oracle connection:
<Steps>
1. Go to the **Database** section.
2. Select **Oracle** from the available connectors.
3. Fill in the required connection details in the **New Oracle Connection** form.
</Steps>


## Connection Parameters

When setting up an Oracle connection, you need to provide the following details:

| Field      | Description |
|------------|-------------|
| **Name**   | A unique name to identify your connection. |
| **Port**   | Port number for Oracle (default is `1521`). |
| **Server** | The Oracle server endpoint. |
| **Username** | Your Oracle database username. |
| **Password** | The corresponding password for the username. |
| **Database** | The Oracle database you want to connect to. |
| **Schema** | The schema inside the database to be used (optional). |



## Steps to Validate and Save
<Steps>
1. After filling in the details, click **Validate** to verify the connection.  
2. If validation succeeds, click **Save** to store the connection.  
3. You can now use Oracle as a datasource in your Infoveave workspace.  
</Steps>


## Example Use Case

With an Oracle connection configured, you can:

- Query and manage enterprise relational data stored in Oracle.  
- Use Oracle SQL syntax for advanced data analysis.  
- Integrate Oracle data into Infoveave Infoboards for dashboards, reports, and insights.