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? 

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