03-03-2017 11:30 AM - edited 03-03-2017 11:34 AM
I went into the "manage dabase drivers" opion in RapidMiner Studio and I created an entry for Teradata. I then went into "manage database connections" and I created an entry to connect to a Teradata database. I tested by pressing the "Test" button and it told me "Connection OK". I then went into the repository tab and I tried to expand my teradata connection, but all I get is a "Pending..." under the connection tree item. Any ideas on how to troubleshoot this? My connection string looks like this: jdbc:teradata://MY_SERVER/LOGMECH=LDAP. See attachment for what I mean by "Pending".
Solved! Go to Solution.
03-07-2017 06:53 PM
The issue is with the TerraData driver. The way we treat TerraData causes problems with the database repository view. On the other hand, all of the database operators still work and the connection is fine. I.E. you can use the read database operator and pull in the data from the TerraData database connection even though the repository view gives you an error.
03-03-2017 12:36 PM
I just turned off "Evaluate SQL meta data" in "settings / preferences / user interface / miscellaneous": see attachment. Still have the same problem.
03-03-2017 12:38 PM
OK, now I get a message in the log. It states:
Mar 3, 2017 11:37:08 AM SEVERE: could not create repository action: class com.rapidminer.repository.gui.actions.StoreProcessAction
I'm not sure if this is in response to my attempt to connect to Teradata.
03-07-2017 12:11 PM
OK, after waiting a long time, the oracle connection worked, but it gave me several messages such as:
Mar 7, 2017 10:57:01 AM WARNING: Failed to fetch column meta data for table <SCHEMA.TABLE_NAME goes here>: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
Someone earlier in this thread suggested that I turn off meta data fetching. Can someone tell me where exactly that is done? I attached an image where I think it should be done.