Versions Compared

Old Version 3

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user Pallavee Dutta (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Applies to: Image Removed (tick) Kyvos Enterprise   Image RemovedKyvos Cloud (Managed Services (tick) Kyvos Cloud (SaaS on AWS)   Image Removed (tick) Kyvos Azure AWS MarketplaceImage Removed

(tick) Kyvos AWS Marketplace  Image RemovedKyvos Azure Marketplace   (tick) Kyvos GCP Marketplace (tick) Kyvos Single Node Installation (Kyvos SNI)   Image RemovedKyvos Free (Limited offering for AWS

...

Kyvos supports Oracle RDS as a source data connection for reading data from the Oracle RDS data warehouse.

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

If using Oracle RDS, and upgrading from Kyvos 2022.3 to a later version, ensure that you remove the 'ojdbc8.jar' from the kyvos.connection.classpath.common.jar property. The property is displayed on the Connection screen when you click the you click the Properties link and search for the kyvos.connection.classpath.common.jar property. 

Prerequisites

Oracle RDS Server and Kyvos running in the same VPC

Once the Oracle RDS is created, navigate to the security group attached to Oracle RDS and add an inbound rule on port 1521 to connect RDS to kyvos instances.

Refer to the below image for adding an inbound rule.Image Removed

...

Oracle RDS Server and Kyvos running in different VPC

Refer to the Amazon documentation to learn how to create a peering connection and accept the connection between the two VPC networks.

Perform the following steps for route tables of both the subnets (subnet of RDS and subnet of BI server of non-RDS Deployment)

  1. Go to the subnet, and click on Route tables.

  2. Click Edit routes.

  3. Add route.

  4. Provide CIDR range of other VPC in destination and peering connection in the target.

  5. Save route tables.

  6. After the entry in route tables, open the security group of Oracle DB RDS.

  7. Add an inbound rule with Custom TCP on port 45421 for the IP of the BI server (BI server of the secondary deployment in which we will manually configure Oracle DB RDS).

Refer to the below screenshot

For every BI node, you need to add an inbound rule.

Image Removed

...

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

To connect to RDS from the Kyvos Manager instance manually, use the same method but put the IP of Kyvos Manager.

Oracle RDS Version and Configuration

...

Creating Oracle RDS connection

To set up an Oracle RDS connection, perform the following steps.

  1. From the Toolbox, click Setup, then Connections.

  2. From the Actions menu ( ⋮) click Add Connection.

  3. On the Connections page, enter details as:

Parameter/Field

Comments/Description

Name

Provide a name for theconnection.

Category

Select the Warehouse option.
There may be more than one warehouse connection.

Provider

For Provider, select Oracle.

Driver Class

Provide the class as oracle.jdbc.OracleDriver

URL

Enter the connection URL for the RDS database in jdbc:oracle:thin:@localhost:port:orcl format.
Where jdbc is the API, Oracle is the database, thin is the driver, localhost is the server name on which oracle is running.
For example, jdbc:oracle:thin:@kyv-oracle.ctdjrop1241x.us-east-1.rds.amazonaws.com:6875:orcl

...

User Name and Password

...

Provide your Oracle RDS server credentials.

  1. Click the Test button from the top left to validate the connection settings.

  2. If the connection is valid, click the Save button.

  3. Go to the newly created connection and click Connection Properties.

  4. Click the Save You can now use the RDS connection to explore data.

...

  1. Image Added