Other packages > Find by keyword >

DatabaseConnector  

Connecting to Various Database Platforms
View on CRAN: Click here


Download and install DatabaseConnector package within the R console
Install from CRAN:
install.packages("DatabaseConnector")

Install from Github:
library("remotes")
install_github("cran/DatabaseConnector")

Install by package version:
library("remotes")
install_version("DatabaseConnector", "7.1.0")



Attach the package and use:
library("DatabaseConnector")
Maintained by
Martijn Schuemie
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2018-05-24
Latest Update: 2025-01-30
Description:
An R 'DataBase Interface' ('DBI') compatible interface to various database platforms ('PostgreSQL', 'Oracle', 'Microsoft SQL Server', 'Amazon Redshift', 'Microsoft Parallel Database Warehouse', 'IBM Netezza', 'Apache Impala', 'Google BigQuery', 'Snowflake', 'Spark', and 'SQLite'). Also includes support for fetching data as 'Andromeda' objects. Uses either 'Java Database Connectivity' ('JDBC') or other 'DBI' drivers to connect to databases.
How to cite:
Martijn Schuemie (2018). DatabaseConnector: Connecting to Various Database Platforms. R package version 7.1.0, https://cran.r-project.org/web/packages/DatabaseConnector. Accessed 05 Aug. 2026.
Previous versions and publish date:
2.1.2 (2018-05-24 14:39), 2.1.3 (2018-06-28 13:35), 2.1.4 (2018-08-21 22:10), 2.2.0 (2018-10-01 10:10), 2.2.1 (2018-11-25 07:20), 2.3.0 (2019-02-21 16:20), 2.4.1 (2019-07-18 13:18), 2.4.2 (2020-01-15 13:30), 3.0.0 (2020-06-06 07:20), 4.0.0 (2021-03-02 11:00), 4.0.2 (2021-04-15 08:00), 5.0.0 (2021-11-18 10:10), 5.0.2 (2022-02-11 10:30), 5.0.3 (2022-06-08 16:00), 5.0.4 (2022-06-28 15:40), 5.1.0 (2022-09-23 13:40), 6.0.0 (2023-01-30 12:20), 6.1.0 (2023-03-16 00:30), 6.2.0 (2023-04-13 14:00), 6.2.1 (2023-05-10 14:10), 6.2.2 (2023-06-23 12:10), 6.2.3 (2023-06-30 00:40), 6.2.4 (2023-09-07 11:20), 6.3.0 (2023-11-08 15:20), 6.3.1 (2023-11-28 14:50), 6.3.2 (2023-12-11 15:30), 6.3.3 (2025-01-16 04:20), 6.4.0 (2025-01-30 14:00), 7.0.0 (2025-09-23 11:40), 7.1.0 (2026-01-09 10:31), (2026-07-09 08:02)
Other packages that cited DatabaseConnector R package
View DatabaseConnector citation profile
Other R packages that DatabaseConnector depends, imports, suggests or enhances
Complete documentation for DatabaseConnector
Functions, R codes and Examples using the DatabaseConnector R package
Some associated functions: DatabaseConnector-package . DatabaseConnectorConnection-class . DatabaseConnectorDbiConnection-class . DatabaseConnectorDbiResult-class . DatabaseConnectorDriver-class . DatabaseConnectorDriver . DatabaseConnectorJdbcConnection-class . DatabaseConnectorJdbcResult-class . Microsoft-SQL-Server-class . assertTempEmulationSchemaSet . computeDataHash . connect . createConnectionDetails . createDbiConnectionDetails . createZipFile . dateAdd . dateDiff . dateFromParts . day . dbConnect-DatabaseConnectorDriver-method . dbGetInfo-DatabaseConnectorDriver-method . dbUnloadDriver-DatabaseConnectorDriver-method . dbms . disconnect . downloadJdbcDrivers . dropEmulatedTempTables . eoMonth . executeSql . existsTable . extractQueryTimes . getAvailableJavaHeapSpace . getTableNames . inDatabaseSchema . insertTable . isSqlReservedWord . jdbcDrivers . lowLevelExecuteSql . lowLevelQuerySql . lowLevelQuerySqlToAndromeda . month . querySql . querySqlToAndromeda . renderTranslateExecuteSql . renderTranslateQueryApplyBatched . renderTranslateQuerySql . renderTranslateQuerySqlToAndromeda . requiresTempEmulation . show-DatabaseConnectorDriver-method . year . 
Some associated R codes: Andromeda.R . BulkLoad.R . Compression.R . Connect.R . CtasHack.R . DBI.R . DataHash.R . DatabaseConnector.R . DbiDateFunctions.R . Drivers.R . HelperFunctions.R . InsertTable.R . ListTables.R . RStudio.R . Sql.R .  Full DatabaseConnector package functions and examples
Downloads during the last 30 days

Today's Hot Picks in Authors and Packages

dcov  
A Fast Implementation of Distance Covariance
Efficient methods for computing distance covariance and relevant statistics. See Sz ...
Download / Learn more Package Citations See dependency  
noisyr  
Noise Quantification in High Throughput Sequencing Output
Quantifies and removes technical noise from high-throughput sequencing data. Two approaches are use ...
Download / Learn more Package Citations See dependency  
quickcode  
Quick and Essential 'R' Tricks for Better Scripts
The NOT functions, 'R' tricks and a compilation of some simple quick plus often used 'R' codes to im ...
Download / Learn more Package Citations See dependency  
dhReg  
Dynamic Harmonic Regression
Building and forecasting time series data with multiple seasonality using Dynamic Harmonic Regressio ...
Download / Learn more Package Citations See dependency  
kernelPSI  
Post-Selection Inference for Nonlinear Variable Selection
Different post-selection inference strategies for kernelselection as described in kernelPSI a Post-S ...
Download / Learn more Package Citations See dependency  

28,083

R Packages

239,283

Dependencies

74,457

Author Associations

28,084

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA