All functions

assertTempEmulationSchemaSet()

Assert the temp emulation schema is set

computeDataHash()

Compute hash of data

connect

connect

createConnectionDetails

createConnectionDetails

createDbiConnectionDetails()

Create DBI connection details

createZipFile()

Compress files and/or folders into a single zip file

DatabaseConnectorDriver()

Create a DatabaseConnectorDriver object

dateAdd()

Add an interval to a date

dateDiff()

Compute difference between dates

dateFromParts()

Construct a date from parts

day()

Extract the day from a date

dbConnect(<DatabaseConnectorDriver>)

Create a connection to a DBMS

dbGetInfo(<DatabaseConnectorDriver>)

Get DBMS metadata

dbms()

Get the database platform from a connection

dbUnloadDriver(<DatabaseConnectorDriver>)

Load and unload database drivers

disconnect()

Disconnect from the server

downloadJdbcDrivers()

Download DatabaseConnector JDBC Jar files

dropEmulatedTempTables()

Drop all emulated temp tables.

eoMonth()

Return the end of the month

executeSql()

Execute SQL code

existsTable()

Does the table exist?

extractQueryTimes()

Extract query times from a ParallelLogger log file

getAvailableJavaHeapSpace()

Get available Java heap space

getTableNames()

List all tables in a database schema.

inDatabaseSchema()

Refer to a table in a database schema

insertTable()

Insert a table on the server

isSqlReservedWord()

Test a character vector of SQL names for SQL reserved words

jdbcDrivers

How to download and use JDBC drivers for the various data platforms.

lowLevelExecuteSql()

Execute SQL code

lowLevelQuerySql()

Low level function for retrieving data to a data frame

lowLevelQuerySqlToAndromeda()

Low level function for retrieving data to a local Andromeda object

month()

Extract the month from a date

querySql()

Retrieve data to a data.frame

querySqlToAndromeda()

Retrieves data to a local Andromeda object

renderTranslateExecuteSql()

Render, translate, execute SQL code

renderTranslateQueryApplyBatched()

Render, translate, and perform process to batches of data.

renderTranslateQuerySql()

Render, translate, and query to data.frame

renderTranslateQuerySqlToAndromeda()

Render, translate, and query to local Andromeda

requiresTempEmulation()

Does the DBMS require temp table emulation?

show(<DatabaseConnectorDriver>)

Show an Object

year()

Extract the year from a date