Need to import Data from Teradata or SAS into RapidMiner
ram_nit05
New Altair Community Member
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
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
Tagged:
0
Answers
-
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
0 -
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.
0