Description Usage Arguments Value Examples
Creates either an ODBC connection or an JDBC connection and initializes the FL session tables.
1 2 3 4 |
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 |
either an ODBC connection or an JDBC connection
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | 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")
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.