Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Applies to:Kyvos Enterprise  Kyvos Cloud (Managed Services on AWS)  Kyvos Azure Marketplace

Kyvos AWS Marketplace  Kyvos Single Node Installation (Kyvos SNI)  Kyvos Free (Limited offering for AWS

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

Info

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 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.

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.

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 the connection.

    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.

  4. Click the Test button from the top left to validate the connection settings.
  5. If the connection is valid, click the Save button.
  6. Go to the newly created connection and click Connection Properties.
  7. Click the Save You can now use the RDS connection to explore data.


  • No labels

Copyright Kyvos, Inc. All rights reserved.