通过DBI和ODBC用R连接到Teradata
我使用Teradata助手连接到Teradata助手。连接参数由服务器地址和驱动程序(出于隐私原因更改服务器信息)组成，如下所示：
Name: my_teradata_connection
Teradata Server Info: 00.11.22.333
Data Source: Teradata Database ODBC Driver 16.20
UID: My_User_ID
PWD: My_PWD我试图使用DBI和odbc包使用R连接到Teradata.com。
con <- DBI::dbConnect(odbc::odbc(),
Driver = "[your driver's name]",
Host = "[your server's path]",
DBCName = "[IP Address or Alias]"
UID = rstudioapi::askForPassword("Database user"),
PWD = rstudioapi::askForPassword("Database password"))显然，Driver应该是Teradata Database ODBC Driver 16.20。但是，我们会说Teradata Server Info是00.11.22.333，我把它放在哪里呢？它应该填充Host还是DBCName参数？而无论哪一个没有人口，那里会有什么呢？
回答 1
Stack Overflow用户
发布于 2019-12-06 16:57:43
通常，在大多数DB中，包括ODBC连接服务器和主机在内，都是同义关键字，在这些关键字中，您不会同时看到两个关键字，而只能看到一个关键字(当然，例外情况除外)。具体来说，按照odbc 文档，dbConnect维护可选的server参数：
dbConnect(
drv,
dsn = NULL,
...,
timezone = "UTC",
timezone_out = "UTC",
encoding = "",
bigint = c("integer64", "integer", "numeric", "character"),
timeout = 10,
driver = NULL,
server = NULL,
database = NULL,
uid = NULL,
pwd = NULL,
dbms.name = NULL,
.connection_string = NULL
)但是，...表示特定于相应驱动程序的附加ODBC驱动程序关键字，这里是Terdata驱动程序。
. these =‘these 2’>额外的ODBC关键字，这些关键字将与其他参数连接起来，形成最终的连接字符串
从Teradata16.20 文档的ODBC驱动程序来看，Driver和DBCName是必需的关键字。在IP地址或别名指示下，DBCName似乎是服务器或主机的同义词。
DBCName =
<IP-addr-or-alias>
| Keyword/Synonym | Description |
|-------------------------------------------------------------|-----------------------------------------------------------------------------------------|
| Driver=<driver-path> | [Required] The full path to the ODBC Driver for Teradata shared objects… |
| Description=<data-source-desc> | [Optional] Descriptive text about the data source. |
| DBCName=<IP-addr-or-alias> | [Required] The IP address or FQDN (fully qualified domain name) of the Teradata server… |
| Username=<name> or UID=<name> | [Optional] The default username for logging onto a Teradata server system. |
| Password=<password> | [Optional] The password required for the default Username. |
| DefaultDatabase=<database-name> Or Database=<database-name> | [Optional] The default database associated with the specified data source… |
| UPTMode | Default = NOTSET… |因此，在R中，只使用DBCName。下面添加可选的Database关键字。
# KEYWORD APPROACH
con <- DBI::dbConnect(odbc::odbc(),
Driver = "Teradata Database ODBC Driver 16.20",
DBCName = "00.11.22.333",
Database = "myDatabase",
UID = rstudioapi::askForPassword("Database user"),
PWD = rstudioapi::askForPassword("Database password"))
# CONNECTION STRING APPROACH
con_str = "Driver={Teradata Database ODBC Driver 16.20};DBCName=00.11.22.333;Database=myDatabase;"
con <- DBI::dbConnect(odbc::odbc(),
.connection_string = con_str,
UID = rstudioapi::askForPassword("Database user"),
PWD = rstudioapi::askForPassword("Database password")https://stackoverflow.com/questions/59215184
复制相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号