-
Oracle and in-database processing
Hello, Is anyone aware of an alternative on executing a visual query as in-database processing on Oracle? Found this In-Database Processing extension (marketplace.rapidminer.com/UpdateServer/faces/product_details.xhtml?productId=rmx_in_database_processing), but seems it only supports Google BigQuery (via OAuth 2),…
-
Execute SQL Operator - Calling Oracle Stored Procedure - Invalid SQL Statement
Trying to call an Oracle stored procedure using the Execute SQL operator and gettingDatabase error occurred: ORA-00900: invalid SQL statement. The SP I'm trying to call is located within the schema that I've configured the connection for.I can execute the SP successfully while connected via SQL Developer. I've…
-
Can i force RapidMiner to use Oracle database column settings
Hello, I am writing some results on an Oracle database but the table we have in the database must have the "Number" datatype and certain size for VARCHAR. RapidMiner, on the other hand, is changing the datatype from "Number" to "Float" and the size of the VARCHAR to smaller sizes. Is there a way I can force it not to…
-
Oracle Database Connection
Hi All, I am trying to connect to a oracle database via "Read Database" operator. However it works if I run it locally in the studio, but on running it on the RM server I am getting the below error. I have tried two methods in define connection 1) Repository 2) url . Both doesn't seem to work on the RM server. I have…
-
How to push data from RapidMiner to Oracle Eloqua using Eloqua RESTful service
I have got a chance to pushing data from RapidMiner to Oracle Eloqua. Eloqua has RESTful API to put data into it. What are the ways to call Eloqua RESTful services from RapidMiner?
-
Import Data from oracle sql developer into Rapidminer and some Values are nor missing marked with ?
Hello all, I have a problem with my imported data from the database oracle sql developer: Some data is now missing and is marked with a "?" How can I get the original data instead of the question mark? Thanks
-
RapidMiner Studio 8.2 connection with Oracle 12c issue
Hi all, I have issue connecting RapidMiner Studio 8.2 with Oracle Database 12c. I have fill in the required info in the Manage Database Connection. The error show IO Error: The Network Adapter could not establish the connection. Anyone can help why I am getting this error?. Thanks in advance. azizzul
-
"Connecting to Oracle DB from python script in Execute Python operator"
Hello everyone, I am trying to connect to my local Oracle DB from python script in Rapidminer. It's throwing "Database Error" when I execute the process. I have executed the same python file from my terminal and it works but it doesn't work inside Rapidminer. This is the xml file: <?xml version="1.0" encoding="UTF-8"?>…
-
Unable to read large table from oracle database - is there a table size limit?
Hello I was able to connect to oracle database and view list of tables in rapidminer studio. However when I am trying to view the content of one table which has around 5M rows (by double clicking on table name) nothing happens. I have also tried using Read Database operator and it takes ages, nothing happens. Even after…
-
Overriding advanced connection settings prevents Oracle DB connection from being saved
Hello all, In order to connect to my Oracle DB here, I need to override the variables v$session.terminal and v$session.machine in the "Advanced Connection Properties" of my Oracle JDBC connection. Having previously saved the database connection, I noticed that after doing so and exiting RapidMiner, the connection was gone,…
-
Issue connecting to Oracle database
Hello everyone. I'm having a problem connecting to an Oracle database. I am using RapidMiner 5.3 which allows for Oracle connections. I have added the jdbc_properties.xml file to the user/.RapidMiner5 folder. This jdbc_properties.xml contains the following: <?xml version="1.0" encoding="UTF-8"?> <drivers> <driver…
-
New to RapidMiner, Oracle large volume of data?
Hi, new Rapidminer user here. I'm trying to get data out of an Oracle table. Can't get it to run...perhaps the example set is too large or I'm doing something wrong. I need to get the transactions from recent years. After filtering for the years I need, I have 16 million records left (is this S/M/L for Rapidminer?). What's…
-
Stream Database Error with Oracle
Hi all, while trying to stream data from an Oracle DB I get the following error message: ORA-00904: "RM_INDEX": invalid identifier. (details below) The underlying table doesn't have a column named RM_INDEX. I guess this is a RapidMiner-generated column which would be used as PK and index as described in the operator…
-
Process fails. oracle/xdb/xmltype error
Hello community, Fairly new to RapidMiner. As I started to test a few simple queries against our Oracle 12c database using the "Read Database" operator, I'm getting an error on just one of the tables. I'm running RM 7.2.1 on a mac. Any ideas would be greatly appreciated. Thanks, Jose
-
data import from oracle and sql
Hi all, Is it possible to use Rapidminer studio to import data from oracle and sql to hive?
-
"Lead and lag oracle functionality"
I need to implement oracle Lead and Lag functions. Basically I want to check the values in the previous and next row and use them in if else statements. Anyone has ideas for doing the same. Help is greatly appreciated. Thanks
-
"Error after upgrade from Oracle 11g to Oracle 12c"
Hello, I am using Rapidanalytics, version 5.3 (Open Source). After upgrading the underlying database from Oracle 11g to Oracle 12c, I get this error message:10:19:47,438 ERROR [STDERR] 20809 [Thread-8] WARN org.hibernate.dialect.resolver.StandardDialectResolver - unknown Oracle major version [12] 10:19:47,439 ERROR…
-
Cannot load facttable (Oracle)
Hello I have RapidMiner Studio connected to a Oracle datawarehouse. Now RapidMiner can see the tables and I can open all tables in the repository except my facttable (wich has over 9 million records). When I click it nothing happens. When I look in the rapidminer-studio log I get the following: Mar 31, 2015 8:51:49 AM…
-
connecting to oracle with other separator
Hello rapid-i Team, i used the RA for a long time with oracle db. But today the oracle system changed. Now I need to re-configurate the RA like my RM. In RM I need to change the "Schema separator" from ' : ' to ' / '. --> Connection established Than I connected with admin to my RA and to change the separator there too. But…
-
[solved] connecting to a oracle database
Hi there, after finally reaching a oracle database (after getting a new driver), there is still a problem with connecting: When I want to connect this error pops up: "Listener refused the connection with the following error: ora-12504, TNS:listener was not given the SID in CONNECT_DATA" Do you know, where I have to enter…
-
Issue with oracle connecitivity
Hi, I have connected RapidMiner with oracle 9i database. I have successfully tested the connection. But when I use 'Read Database' operator then it does not populate the available table list in the window. I tried to write the SQL manually and its working. Can anyone please tell me why the lisyt of tables are not getting…
-
"MOVED: Read Database Oracle Issue"
This topic has been moved to Problems and Support. [iurl]http://rapid-i.com/rapidforum/index.php?topic=4890.0[/iurl]
-
"Read Database Oracle Issue"
Hi All, I am new to RapidMiner. I am trying to user the Read Database control with Oracle database. Since Oracle driver is not available in Rapid Miner 5.2.001. I downloaded the Oracle driver from the Oracle site and updated the C:\Program Files\Rapid-I\RapidMiner5\resources\com\rapidminer\resources\jdbc_properties.xml…
-
"Driver for connecting to Oracle Database"
Hi Community, I am using RapidMiner-5 64 bit, Windows server 2003 (64 bit) as OS, JDK 1.6 java version, Oracle 11g for Database. My problem is I am unable to connect to Database with RM. I tried with ojdbc14.jar and ojdbc6.jar, but no use. Please give me solution, which drivers I have to use. Thank you Yours Anki
-
"Oracle JDBC"
Got Oracle JDBC thin to work. Oracle has changed the package.class name of its driver from jdbc.oracle.driver.OracleDriver to jdbc.oracle.OracleDriver, but RapidMiner5 is still looking for the old reference. The wiki needs an update (forum account != wiki account?): http://rapid-i.com/wiki/index.php?title=JDBC_Drivers…