Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Can we use oracle as external database while using docker image of rapidminer server

anuradha

Can we use oracle as external database while using docker image of rapidminer server? if yes then how?

Find more posts tagged with

AI Studio

Accepted answers

All comments

sgenzer

hi @anuradha I am by no means the expert in this but I would say yes - I see no reason why not . I would start by learning how to create and manage database connections on RM Server: https://docs.rapidminer.com/latest/server/use/connections/

Scott

anuradha

sgenzer, the command i used to start rapid miner server using docker image is

docker run \
-e DBTYPE=oracle
-e DBHOST=<ip.address.of.host>
-e DBSCHEMA=<db-name>
-e DBUSER=<user-name>
-e DBPASS=<password>
-v </PATH/TO/RAPIDMINER/HOME>: persistent-rapidminer-home \
-p 8080:8080 \
rapidminer/rapidminer-server:9.1.0

when i use DBTYPE as oracle it is giving 'Invalid DBTYPE' error i have also tried using 'oracle','orcl','Oracle'
but when i start a postgresql server and pass DBTYPE as 'pgsql' it is working fine,
what is expected in DBTYPE for oracle database ?

sgenzer

hi @anuradha ah ok I did not quite realize you were literally starting the RM server from a Docker image, rather than using a Job Agent inside RM Server to create a Docker image.

You are beyond my knowledgebase (and the server folks are on vacation) but perhaps this will help. Server is really a headless Studio under the hood, so I created a bogus Oracle connection in Studio and pulled the metadata JSON:

����{
  "name" : "foo",
  "type" : "jdbc_connectors:jdbc",
  "description" : "",
  "tags" : [ ],
  "id" : "c061131b-a386-4b80-ab2f-52eebaffb03b",
  "valueProviders" : [ ],
  "keys" : [ {
    "group" : "jdbc_driver",
    "parameters" : [ {
      "name" : "urlprefix",
      "encrypted" : false,
      "enabled" : true,
      "value" : "jdbc:oracle:thin:@",
      "injectorName" : null
    }, {
      "name" : "dbseparator",
      "encrypted" : false,
      "enabled" : true,
      "value" : ":",
      "injectorName" : null
    }, {
      "name" : "driver_class",
      "encrypted" : false,
      "enabled" : true,
      "value" : "oracle.jdbc.OracleDriver",
      "injectorName" : null
    } ]
  }, {
    "group" : "db_config",
    "parameters" : [ {
      "name" : "host",
      "encrypted" : false,
      "enabled" : true,
      "value" : "localhost",
      "injectorName" : null
    }, {
      "name" : "port",
      "encrypted" : false,
      "enabled" : true,
      "value" : "1521",
      "injectorName" : null
    }, {
      "name" : "database",
      "encrypted" : false,
      "enabled" : true,
      "value" : null,
      "injectorName" : null
    }, {
      "name" : "URL",
      "encrypted" : false,
      "enabled" : true,
      "value" : "%{jdbc_driver.urlprefix}%{host}:%{port}%{jdbc_driver.dbseparator}%{database}",
      "injectorName" : null
    }, {
      "name" : "manual_url",
      "encrypted" : false,
      "enabled" : false,
      "value" : null,
      "injectorName" : null
    } ]
  }, {
    "group" : "credentials",
    "parameters" : [ {
      "name" : "user",
      "encrypted" : false,
      "enabled" : true,
      "value" : "fooUser",
      "injectorName" : null
    }, {
      "name" : "password",
      "encrypted" : true,
      "enabled" : true,
      "value" : "5m4+DbBWUsc=",
      "injectorName" : null
    } ]
  }, {
    "group" : "jdbc_advanced",
    "parameters" : [ {
      "name" : "autocommit",
      "encrypted" : false,
      "enabled" : true,
      "value" : "true",
      "injectorName" : null
    } ]
  } ],
  "placeholders" : [ ]
}

Is there something here that may help?

Scott