prepareConnection: Prepares connection to RDBS via ODBC

In datrProfile: Column Profile for Tables and Datasets

Description

prepareConnection list connection details needed to connecto to a RDBS using ODBC

Usage

prepareConnection(db.vendor, odbc.driver = odbc::odbc(),
  db.host = NULL, db.name = NULL, db.encoding = "", dsn = NULL,
  user = NULL, passwd = NULL)

Arguments

db.vendor	Database vendor (teradata, sqlserver)
odbc.driver	ODBC driver used to connect to database
db.host	Database hostname
db.name	Database name
db.encoding	Database encoding
dsn	Data source name
user	Username to connect to database
passwd	Password to connect to database

Examples

conn.info <- prepareConnection(db.vendor = "teradata",
   dsn = "ODBC_MYDB", user = "myuser", passwd = "mypasswd")

datrProfile documentation built on Aug. 2, 2019, 5:05 p.m.