dbCanConnect: dbCanConnect()

In kineticadb/RKinetica: Kinetica DBI datasource

Description

Method allows to check if provided Kinetica Connection configuration could be used to connect to Kinetica DB instance successfully. It takes all the arguments of dbConnect signature, creates a connection and destroys it upon exit.

Usage

## S4 method for signature 'KineticaDriver'
dbCanConnect(drv, ...)

Arguments

drv	Kinetica driver object
...	Other arguments omitted in generic signature

See Also

Other KineticaDriver methods: dbConnect,KineticaDriver-method, dbDataType,KineticaDriver-method, dbGetInfo, dbIsValid, dbListConnections,KineticaDriver-method, dbUnloadDriver,KineticaDriver-method, show,KineticaDriver-method

Examples

## Not run: 
# If you have a Kinetica DB instance running in local docker image,
# the minimum set of parameters to connect is url
dbCanConnect(Kinetica(), url = "http://localhost:9191")
# TRUE
# You can also use host and port combination
dbCanConnect(Kinetica(), host = "127.0.0.1", port = 9191)
# TRUE
# Remote instances would also require username and password.
dbCanConnect(Kinetica(), host = "127.0.0.1", port = 9191,
    username = "username", password = "Pa$$w0rd")
# TRUE
# You can obscure username and password values by calling RStudio secure dialogue box:
dbCanConnect(Kinetica(), host = "127.0.0.1", port = 9191,
             username = rstudioapi::askForPassword("Kinetica DB user"),
             password = rstudioapi::askForPassword("Kinetica DB password"))
# TRUE

## End(Not run)

kineticadb/RKinetica documentation built on Sept. 29, 2020, 5:38 p.m.