Oracle

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:

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.

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

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.

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.