Description Usage Arguments Details
Connect to a Teradata ODBC compatible database
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | ## S4 method for signature 'TeradataOdbcDriver'
dbConnect(
drv,
dsn = NULL,
...,
timezone = "UTC",
encoding = "UTF-8",
bigint = c("integer64", "integer", "numeric", "character"),
driver = NULL,
server = NULL,
DBCName = NULL,
database = "",
uid = NULL,
pwd = NULL,
charset = "ASCII",
tmode = c("ANSI", "TERA"),
dbms.name = NULL,
.connection_string = NULL
)
|
drv |
an object that inherits from DBIDriver, or an existing DBIConnection object (in order to clone an existing connection). |
dsn |
The Data Source Name. |
... |
Additional ODBC keywords, these will be joined with the other arguments to form the final connection string. |
timezone |
The Server time zone. Useful if the database has an internal
timezone that is not 'UTC'. If the database is in your local timezone set
to |
encoding |
Alias of |
bigint |
The R type that |
driver |
The ODBC driver name. |
server |
Alias of |
DBCName |
The server hostname. |
database |
The database on the server. |
uid |
The user identifier. |
pwd |
The password to use. |
charset |
Character Set. |
tmode |
TMODE. |
dbms.name |
The database management system name. This should normally
be queried automatically by the ODBC driver. This name is used as the class
name for the OdbcConnect object returned from |
.connection_string |
A complete connection string, useful if you are copy pasting it from another source. If this argument is used any additional arguments will be appended to this string. |
The connection string keywords are driver dependent. The parameters documented here are common, but some drivers may not accept them. Please see the specific driver documentation for allowed parameters, https://www.connectionstrings.com is also a useful resource of example connection strings for a variety of databases.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.