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

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

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 ?

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