Can we use oracle as external database while using docker image of rapidminer server? if yes then how?
0
Answers
sgenzerAdministrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts: 2,959 Community Manager
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 ?
0
sgenzerAdministrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts: 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:
Answers
Scott
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 ?
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:
Is there something here that may help?
Scott