search for: teradata

Hello All, I am very new to the R and i want to know how to connect to the teradata in R and import data from there. Currently I am using SAS to import data and i use the following syntax to connect to teradata. *Proc Sql; connect to odbc (dsn=teradata username = '**********' password = '*********'); create table dorm.bkg_tables as select * from connection to odb...

Hello, Does anyone know a way to connect from R on Linux box to TeraData server? I can use ODBC connection on Windows box, but with amount of data I need (and prefer) to use large Linux box. Thanks, Vadim

Hi. I have had this URL passed to me in order to obtain the necessary driver to connect my R application to our Teradata warehouse, however, the URL does not seem to exist anymore, my internet explorer browser fails to connect for some reason. http://downloads.teradata.com/download/applications/teradata-r/1.0 Is there an alternative site or location for obtaining the necessary driver? Thanks WHP [[alternative...

Hi all, I am trying to connect Teradata with R using Windows. Due I need to install any specific package or what? I am bit clue-less. Can someone help. Regards, Saj _________________________________________________________________ [[alternative HTML version deleted]]

Hi, I'm trying to connect to a Teradata database via RODBC on a Linux 64 machine (Red Hat Enterprise Linux 5). The ODBC driver is properly configured and queries sent via unixODBC's isql tool work properly. However, this is what happens when I try to connect via RODBC: > library(RODBC) > conn = odbcConnect("thedsn",...

We are new to R and evaluating if we can use it for a project we need to do. We have read that R is not well suited to handle very large data sets. Assuming we have the data prepped and stored in an RDBMS (Oracle, Teradata, SQL Server), what can R reasonably handle from a volume perspective? Are there some guidelines on memory/machine sizing based on data volume? We need to be able to handle Millions of Rows from several sources. Any advice is much appreciated. Thanks. [[alternative HTML version deleted]]

Hi, I am working on an old Unix system, UNIX SVR4 MP-RAS, running a Teradata database. Due to the age of the system (notably the C compiler, which won't handle v3 source code), I have built Samba 2.2.12 I want to use this to share Unix directories out to XP clients as network drives, for read-write access, keeping the file ownership as strict unix users. This all wo...

Hi , I have created .R file which connects to Teradata database and then does some manipulation and produces the output graph. How to create executable for .R file? Thanks Pariksheet -- View this message in context: http://r.789695.n4.nabble.com/How-to-create-R-executable-tp3790883p3790883.html Sent from the R help mailing list archive at Nabble.com...

I imported data from teradata to R data frames.Now i want to export this data to .xlsx file ( not .xls since it doesn't support large data set). I have tried dataframes2xls package but it needs python/perl which I don't have on my computer. Could any one help me resolve this issue. Thanks Sumit [[alternative HTML...

sorry for asking again and again my Requirement: i am connecting to teradata database and i am accessing tables and table data also, i need generate graphs using that data and also i need to forecast the results. for example i have a table xyz Store Year Revenue abc 2010 $557889 def 2010 $697356 i want to draw a bar...

Hi all, This is Steven with Manning Publications. I wanted to announce the launch of a new R book: R in Action by Rob Kabacoff. Rob was recently interviewed for this piece on Teradata about the growth of R into new fields and the future of R. The book gives thorough coverage of the R environment with dozens of practical examples of its uses. We're doing a one day 50% off deal on the book using the code "twtr1014". The deal is exclusive to the Manning site. T...

MY REQUIREMENT: I have a database and i want to connect to the database through R Project and using the tables from the database i need to generate the reports. can anyone plese tell me whether this is possible with R project or not. Thanks in advance Chinna. -- View this message in context: http://n4.nabble.com/Generating-reports-from-database-tp1564238p1564238.html Sent from the R help

A new package is now available on CRAN - pmml. PMML is the Predictive Modelling Markup Language, and is accepted by a number of large database and data warehouse systems (IBM DB2 and NCR Teradata) for deployment of models as SQL. The current package is an "early release" in that it is very basic (and primarily supports the Rattle package). But it is a start! It currently supports rpart classification trees and kmeans clusters. Contributions of support for other models are welcom...

...de: arules, hclust, kmeans, ksvm, lm (and glm), nnet, rpart, and rsf. PMML consumers include Information Builders' C code generator (for deployment of R generated models within Web Focus on all of their supported platforms), Zementis' scoring engine or cloud computing application (ADAPA), Teradata's Warehouse Miner and IBM's DB2. A key update is the incorporation of a framework for dealing with data transformations. This is ongoing work. The pmml package is regularly updated and intermediate releases (between the more stable CRAN releases) are always available using: install.pac...

...de: arules, hclust, kmeans, ksvm, lm (and glm), nnet, rpart, and rsf. PMML consumers include Information Builders' C code generator (for deployment of R generated models within Web Focus on all of their supported platforms), Zementis' scoring engine or cloud computing application (ADAPA), Teradata's Warehouse Miner and IBM's DB2. A key update is the incorporation of a framework for dealing with data transformations. This is ongoing work. The pmml package is regularly updated and intermediate releases (between the more stable CRAN releases) are always available using: install.pac...

Folks, I found free-nx in the repositories and tried to install/use it I could not figure out how to get it working. I tried following directions on the wiki But I still could not get it working Feel free to contact me at stephen.bovy at teradata.com I am currenly using the official ns server on sles 11 sp3 Is their any direction on how to install free nx on sles ??

Hello, i see packages referencing using ODBC access to databases via R, are there any packages that use JDBC to submit SQL to a database and return into a data frame? -zubin

...Collective?is the Data-Driven Enterprise Community. Discuss business intelligence, data mining, data warehousing, enterprise data, e-gov, data integration, CRM, predictive analytics, risk management, and anything else data-related! It is a moderated site ,editorially independent but sponsored from Teradata. If you have a blog already, join?smartdatacollective.com?as a member and featured blogger (which, I hasten to add, involves no additional work on your part.) We can set up an RSS feed link to your existing blog so your posts automatically become part of the?SmartData Collectivecontent flow with n...

Hola, Me gustaría obtener las reglas que genero con un árbol de decicisión creado con party. Algo parecido a lo que realiza esta función con rpart http://www.togaware.com/datamining/survivor/Convert_Tree.html la idea es disponer de esas reglas en un fichero de texto. En general si alguien sabe de algún paquete que permita obtener el código que genera la puntuación, el "score" para un

...s will spend $232B on "big data" over the next 5 years: http://bit.ly/SL40B6 A time-series boxplot of DW-NOMINATE scores show how the US Republican Party has drifted to the right since 1975: http://bit.ly/SL40B8 TIBCO launches a proprietary run-time version of the R language engine, and Teradata's new Big Data appliance integrates R: http://bit.ly/SL40B7 A report on a speech from Coursera's cofounder (Coursera has a course on R): http://bit.ly/SL3YJs The stargazer package creates regression tables in LaTeX suitable for inclusion in many journals: http://bit.ly/SL3YJt A recent Ba...