flConnect: Creates either an ODBC connection or an JDBC connection and...

In Fuzzy-Logix/AdapteR: Converts R syntax to SQL to provide fast analytics using in-database C++ library DB Lytix.

Description

Creates either an ODBC connection or an JDBC connection and initializes the FL session tables.

Usage

flConnect(host = NULL, database = NULL, user = NULL, passwd = NULL,
  jdbc.jarsDir = NULL, jdbc.options = "", odbcSource = NULL,
  driverClass = NULL, temporary = TRUE, verbose = FALSE,
  tablePrefix = NULL, pkg = "dbc", ...)

Arguments

host
database
user
passwd
jdbc.jarsDir	if provided, class paths for jars to be loaded. If one element, a directory, all jar files in that directory will be loaded. If multiple elements, specific jar files, these will be loaded. Issues can occur unless you provide the fully qualified path.
jdbc.options
odbcSource
driverClass
temporary	TRUE if result tables are to be created as volatile tables
verbose	print debugging messages
...	include 'platform' here. Use TD for Teradata. platform is mandatory for odbc connection. 'TestDatabase' on which tests are to be run.
#"TMODE
CHARSET

Value

either an ODBC connection or an JDBC connection

Examples

connection <- flConnect("jdbc:teradata://xx.xxx.x.xxx",
                          "FL_TRAIN",
                         "UserName","PassWord",
                        c("C:/Users/xxx/terajdbc4.jar",
                            "C:/Users/xxx/tdgssconfig.jar"),
                        driverClass="com.teradata.jdbc.TeraDriver")
connection <- flConnect("jdbc:hive2://xx.xxx.x.xxx",
                         "dblytix",
                         "userName","Password",
                        c("C:/Users/xxx/hive-jdbc-1.2.1-standalone.jar",
                            "C:/Users/xxx/hadoop-common-2.6.0.jar"),
                        driverClass="org.apache.hive.jdbc.HiveDriver")
connection <- flConnect("jdbc:ncluster://xx.xxx.x.xxx","fuzzylogix",
                         "UserName","Password",
                        c("C:/Users/xxx/noarch-aster-jdbc-driver.jar",
                          "C:/Users/xxx/noarch-aster-adfs-client.jar"),
                        driverClass = "com.asterdata.ncluster.Driver")
connection <- flConnect(odbcSource="sourceName",database="FL_TRAIN",platform="TD")
connection <- flConnect(odbcSource="SorceName",database="fuzzylogix",platform="TDAster")

Fuzzy-Logix/AdapteR documentation built on May 6, 2019, 5:07 p.m.