# Connecting to Various Database Platforms

## Documentation for package ‘DatabaseConnector’ version 6.2.0

- DESCRIPTION file.
- User guides, package vignettes and other documentation.

## Help Pages

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-method | Create a connection to a DBMS
dbGetInfo-method | Get DBMS metadata
dbms | Get the database platform from a connection
dbUnloadDriver-method | 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-method | Show an Object
year | Extract the year from a date