Date: Mon, 5 Mar 2012 11:29:09 -0800
Reply-To: "Pardee, Roy" <pardee.r@GHC.ORG>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Pardee, Roy" <pardee.r@GHC.ORG>
Subject: Getting at teradata: ODBC or OLEDB?
Content-Type: text/plain; charset="us-ascii"
Hey All,
This is obscure, but I figure someone may have looked at this at some point.
I'm going to be moving data in & (mostly) out of a teradata db server with SAS. We have SAS/ACCESS for ODBC and OLEDB licensed (but *not* the native TD SAS/ACCESS module). I've got the ODBC driver installed & can connect that way, but I see that TD offers an OLEDB provider as well. Is there any reason to favor OLEDB over ODBC for connections from SAS?
Many thanks!
-Roy
Roy Pardee | DATA WRANGLER
Group Health Research Institute
PHONE 360-447-8773 | 206-287-2078
E-MAIL pardee.r@ghc.org
www.grouphealthresearch.org
GHC Confidentiality Statement
This message and any attached files might contain confidential information protected by federal and state law. The information is intended only for the use of the individual(s) or entities originally named as addressees. The improper disclosure of such information may be subject to civil or criminal penalties. If this message reached you in error, please contact the sender and destroy this message. Disclosing, copying, forwarding, or distributing the information by unauthorized individuals or entities is strictly prohibited by law.
|