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

anuradhaanuradha Member Posts: 5 Contributor II
Can we use oracle as external database while using docker image of rapidminer server? if yes then how? 

Answers

  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
    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

  • anuradhaanuradha Member Posts: 5 Contributor II
    edited December 2019
    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 ?
  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
    edited December 2019
    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
Sign In or Register to comment.