Skip to main content
Kinetic Community

Oracle Adapter

Overview

The Oracle Adapter provides access into the Oracle SQL Server database. It is an extension of the Generic Database Bridge, and has been customized to simplify the deployment and implement Oracle specific features.

Installation

Note: Check to ensure that this adapter isn't already installed into your bridgehub as part of the base installation before undertaking the installation tasks.

  • Download the kinetic-bridges-adapter-database-adapter.jar file and it's dependencies here
  • Put all of the downloaded files into the WEB-INF/lib folder for your kinetic-bridgehub installation
  • Restart the tomcat that your kinetic-bridgehub installation is located in
  • This adapter also requires that kinetic-bridgehub-adapter-database version 1.0.1 or higher be installed.

Setup

Configuration Values

Name Description
Username Oracle user
Password Oracle password
Server Server location
Port Server port
Service Name Oracle service name

Example Configuration

Name Value
Username SqlUser
Password SqlPassword
Server matrix.kineticdata.com
Port 1521
Service Name XE

Structures, Fields, and Queries

Structures

Structure maps to a Table name in the currently connected database

Fields

Fields map to the field names in the currently connected database and table

Queries

Queries map to the language of the currently connected database type

Changelog

v1.0.1 (2017-11-14)

  • Added support for returning CLOB fields

v1.0.0 (2016-07-08)

  • Initial Version