Need to import Data from Teradata or SAS into RapidMiner

ram_nit05

Hi,

I need to import my analysis data from Teradata or SAS to perform Decision trees/Clustering with RapidMiner. However it seems that neither of the two formats are supported. Can somebody please help me with some workaround this problem?

The only way that seems possible to me is get the data into csv/txt format and then import-however my current data has millions of records and hundreds of columns and two import steps will end up taking a lot of time and effort.

Thanks in advance for your help,
Ramkumar

keith

You could try connecting to them through the DatabaseExampleSource, if you have either a JDBC driver or an ODBC driver (via the JDBC-ODBC bridge option for 'database_system')  for SAS or Teradata.

Teradata JDBC driver:  http://www.teradata.com/DownloadCenter/Forum149-1.aspx

SAS JDBC driver: http://www.sas.com/apps/demosdownloads/sasjdbc_PROD_9.1.3_sysdep.jsp?packageID=000355&;jmpflag=N
SAS ODBC driver: http://www.sas.com/apps/demosdownloads/odbcdriver_PROD_9.1.3_sysdep.jsp?packageID=000356&;jmpflag=N

Hope this helps,
Keith

siebertlj

I'm mainly a SAS user trying to use Rapidminer, but I've found that , exporting to .csv works fine, provided your labels, values etc. contains no commas.