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", "6.4.0")



Attach the package and use:
library("DatabaseConnector")
Maintained by
Martijn Schuemie
[Scholar Profile | Author Map]
First Published: 2018-05-24
Latest Update: 2023-12-11
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 6.4.0, https://cran.r-project.org/web/packages/DatabaseConnector. Accessed 06 May. 2025.
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)
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
04/0604/0704/0804/0904/1004/1104/1204/1304/1404/1504/1604/1704/1804/1904/2004/2104/2204/2304/2404/2504/2604/2704/2804/2904/3005/0105/0205/0305/04Downloads for DatabaseConnector20406080100120140160180200220TrendBars

Today's Hot Picks in Authors and Packages

HuraultMisc  
Guillem Hurault Functions' Library
Contains various functions for data analysis, notably helpers and diagnostics for Bayesian modelling ...
Download / Learn more Package Citations See dependency  
r2resize  
In-Text Resize for Images, Tables and Fancy Resize Containers in 'shiny', 'rmarkdown' and 'quarto' Documents
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency  
rotations  
Working with Rotation Data
Tools for working with rotational data, including simulation from the most commonly used distributi ...
Download / Learn more Package Citations See dependency  
netUtils  
A Collection of Tools for Network Analysis
Provides a collection of network analytic (convenience) functions which are missing in other standar ...
Download / Learn more Package Citations See dependency  
tashu  
Analysis and Prediction of Bicycle Rental Amount
Provides functions for analyzing citizens' bicycle usage pattern and predicting rental amount on spe ...
Download / Learn more Package Citations See dependency  
simfam  
Simulate and Model Family Pedigrees with Structured Founders
The focus is on simulating and modeling families with founders drawn from a structured population (f ...
Download / Learn more Package Citations See dependency  

24,205

R Packages

207,311

Dependencies

65,312

Author Associations

24,206

Publication Badges

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