similar to: R and 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 odbc* Could you

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

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", uid="theuid", pwd="thepass") ***

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

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 works fine, except for

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.

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

Hi, I am hoping to use the RODBC package to write a dataframe to an Excel .xlsx file. The dataframe contains at least one field with character elements that exceed 255 bytes, which appears to be the cell width limit in Excel. Below is example code and the warning message received: library(RODBC) d <-

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 version deleted]]

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 barplot and i want to

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

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

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

Hola Javier, si no estoy entendiendo mal, lo q deseo hacer no se trata de configurar los parametros SQL, sino solo de colocar un vector en el argumento VarTypes de la funcion sqlSave. El manual especifica esa opcion, pero no da ningun ejemplo de como usarla. *varTypes an optional named character vector giving the DBMSs datatypes to be used for* *some (or all) of the columns if a table is to be

Buen dia Javier, muchas gracias por tu ayuda y el script compartido. Me va a servir como ayuda para seguir aprendiendo sobre RODBC pero no encuentro una solucion para este problema puntual de poder definir el tipo y ancho de las variables, q segun creo se hace con el argumento varTypes. Si alguien tien algun ejemplo donde haya usado la SqlSave y VarTypes, me sera de gran ayuda. Abrazo a todos

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 ??

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

Dear List, Apologies in advance for non bloggers for the spam on the slightly off topic. This is an invitation to all R language bloggers to help spread the world at a forum where leading authors come?together. Current only 1 R blogger is there- David Smith, from Revolution Computing. There are many from SAS (Jason Burke,Gary Conkins) ,one from SPSS (Jon Peck) and others from SAP,Aster Data

======================================================================= Special Report May 31, 2005 http://www.DMReview.com Special Report is an extension of DMReview magazine online. ======================================================================= Industry Standards Can Help Pave the Road to Compliance by Brian Sennett Service-oriented architectures can aid in