{"Package":"odbc","Title":"Connect to ODBC Compatible Databases (using the DBI Interface)","Version":"1.6.1","Authors@R":"c(\nperson(\"Jim\", \"Hester\", role = \"aut\"),\nperson(\"Hadley\", \"Wickham\", , \"hadley@posit.co\", role = c(\"aut\", \"cre\")),\nperson(\"Oliver\", \"Gjoneski\", role = \"aut\"),\nperson(\"lexicalunit\", role = \"cph\",\ncomment = \"nanodbc library\"),\nperson(\"Google Inc.\", role = \"cph\",\ncomment = \"cctz library\"),\nperson(\"Posit Software, PBC\", role = c(\"cph\", \"fnd\"))\n)","Description":"A DBI-compatible interface to ODBC databases.","License":"MIT + file LICENSE","URL":"https://odbc.r-dbi.org, https://github.com/r-dbi/odbc,\nhttps://solutions.posit.co/connections/db/","BugReports":"https://github.com/r-dbi/odbc/issues","Depends":"R (>= 4.0.0)","Imports":"bit64, blob (>= 1.2.0), cli, DBI (>= 1.0.0), hms, lifecycle,\nmethods, Rcpp (>= 0.12.11), rlang (>= 1.1.0)","Suggests":"connectcreds, covr, DBItest, httr2, knitr, magrittr,\npaws.common, rmarkdown, RSQLite, testthat (>= 3.0.0), tibble,\nwithr","LinkingTo":"Rcpp","ByteCompile":"true","Config/Needs/check":"pkgbuild","Config/Needs/website":"tidyverse/tidytemplate","Config/testthat/edition":"3","Encoding":"UTF-8","RoxygenNote":"7.3.2","SystemRequirements":"GNU make, An ODBC3 driver manager and drivers.","Collate":"'RcppExports.R' 'aaa-odbc-data-type.R' 'connection-pane.R'\n'dbi-connection.R' 'odbc-connection.R' 'db.R' 'dbi-driver.R'\n'dbi-result.R' 'dbi-table.R' 'dbi.R' 'driver-access.R'\n'driver-bigquery.R' 'driver-databricks.R' 'driver-db2.R'\n'driver-hana.R' 'driver-hive.R' 'driver-impala.R'\n'driver-mysql.R' 'driver-netezza.R' 'driver-oracle.R'\n'driver-postgres.R' 'driver-redshift.R' 'driver-snowflake.R'\n'driver-spark.R' 'driver-sql-server.R' 'driver-sqlite.R'\n'driver-teradata.R' 'driver-vertica.R'\n'import-standalone-obj-type.R'\n'import-standalone-types-check.R' 'odbc-config.R'\n'odbc-data-sources.R' 'odbc-drivers.R' 'odbc-package.R'\n'odbc.R' 'utils.R' 'zzz.R'","VignetteBuilder":"knitr","NeedsCompilation":"yes","Packaged":"2025-03-26 20:22:27 UTC; hadleywickham","Author":"Jim Hester [aut],\nHadley Wickham [aut, cre],\nOliver Gjoneski [aut],\nlexicalunit [cph] (nanodbc library),\nGoogle Inc. [cph] (cctz library),\nPosit Software, PBC [cph, fnd]","Maintainer":"Hadley Wickham ","Repository":"CRAN","Date/Publication":"2025-03-27 12:10:02 UTC","repoType":"cran","tarballUrl":"ftp://cran.r-project.org/pub/R/src/contrib/odbc_1.6.1.tar.gz","jsonAuthors":[{"name":"Jim Hester","email":null,"maintainer":false},{"name":"Hadley Wickham","email":"hadley@posit.co","maintainer":true},{"name":"Oliver Gjoneski","email":null,"maintainer":false},{"name":"lexicalunit ","email":null,"maintainer":false},{"name":"Google Inc. ","email":null,"maintainer":false},{"name":"Posit Software, PBC ","email":null,"maintainer":false}],"readme":"\n\n\n# odbc $\"odbc$ \n\n\n\n[![Project Status: Active – The project has reached a stable, usable\nstate and is being actively\ndeveloped.](http://www.repostatus.org/badges/latest/active.svg)](https://www.repostatus.org/)\n[![CRAN_Status_Badge](http://www.r-pkg.org/badges/version/odbc)](https://cran.r-project.org/package=odbc)\n[![R-CMD-check](https://github.com/r-dbi/odbc/actions/workflows/R-CMD-check.yaml/badge.svg)](https://github.com/r-dbi/odbc/actions/workflows/R-CMD-check.yaml)\n[![Codecov test\ncoverage](https://codecov.io/gh/r-dbi/odbc/branch/main/graph/badge.svg)](https://app.codecov.io/gh/r-dbi/odbc?branch=main)\n\n\nThe goal of the odbc package is to provide a\n[DBI](https://dbi.r-dbi.org/)-compliant interface to\n[ODBC](https://learn.microsoft.com/en-us/sql/odbc/microsoft-open-database-connectivity-odbc)\ndrivers. This makes it easy to connect databases such as [SQL\nServer](https://www.microsoft.com/en-us/sql-server/), \nOracle,\n[Databricks](https://www.databricks.com/), and \nSnowflake.\n\nThe odbc package is an alternative to\n[RODBC](https://cran.r-project.org/package=RODBC) and\n[RODBCDBI](https://cran.r-project.org/package=RODBCDBI) packages, and is\ntypically much faster. See `vignette(\"benchmarks\")` to learn more.\n\n## Overview\n\nThe odbc package is one piece of the R interface to databases with\nsupport for ODBC:\n\n $\"A$ \n\nSupport for a given DBMS is provided by an **ODBC driver**, which\ndefines how to interact with that DBMS using the standardized syntax of\nODBC and SQL. Drivers can be downloaded from the DBMS vendor or, if\nyou’re a Posit customer, using the [professional\ndrivers](https://docs.posit.co/pro-drivers/).\n\nDrivers are managed by a **driver manager**, which is responsible for\nconfiguring driver locations, and optionally named **data sources** that\ndescribe how to connect to a specific database. Windows is bundled with\na driver manager, while MacOS and Linux require installation of\n[unixODBC](https://www.unixodbc.org/). Drivers often require some manual\nconfiguration; see `vignette(\"setup\")` for details.\n\nIn the **R interface**, the [DBI package](https://dbi.r-dbi.org/)\nprovides a front-end while odbc implements a back-end to communicate\nwith the driver manager. The odbc package is built on top of the\n[nanodbc](https://nanodbc.github.io/nanodbc/) C++ library. To interface\nwith DBMSs using R and odbc:\n\n $\"A$ \n\nYou might also use the [dbplyr package](https://dbplyr.tidyverse.org/)\nto automatically generate SQL from your dplyr code.\n\n## Installation\n\nInstall the latest release of odbc from CRAN with the following code:\n\n``` r\ninstall.packages(\"odbc\")\n```\n\nTo get a bug fix or to use a feature from the development version, you\ncan install the development version of odbc from GitHub:\n\n``` r\n# install.packages(\"pak\")\npak::pak(\"r-dbi/odbc\")\n```\n\n## Usage\n\nTo use odbc, begin by creating a database connection, which might look\nsomething like this:\n\n``` r\nlibrary(DBI)\n\ncon <- dbConnect(\n odbc::odbc(),\n driver = \"SQL Server\",\n server = \"my-server\",\n database = \"my-database\",\n uid = \"my-username\",\n pwd = rstudioapi::askForPassword(\"Database password\")\n)\n```\n\n(See `vignette(\"setup\")` for examples of connecting to a variety of\ndatabases.)\n\n`dbListTables()` is used for listing all existing tables in a database.\n\n``` r\ndbListTables(con)\n```\n\n`dbReadTable()` will read a full table into an R `data.frame()`.\n\n``` r\ndata <- dbReadTable(con, \"flights\")\n```\n\n`dbWriteTable()` will write an R `data.frame()` to an SQL table.\n\n``` r\ndbWriteTable(con, \"iris\", iris)\n```\n\n`dbGetQuery()` will submit a SQL query and fetch the results:\n\n``` r\ndf <- dbGetQuery(\n con,\n \"SELECT flight, tailnum, origin FROM flights ORDER BY origin\"\n)\n```\n\nIt is also possible to submit the query and fetch separately with\n`dbSendQuery()` and `dbFetch()`. This allows you to use the `n` argument\nto `dbFetch()` to iterate over results that would otherwise be too large\nto fit in memory.","jobInfo":{"package":"odbc","version":"1.6.1","parsingStatus":"success","parserVersion":2,"parsedAt":"2025-03-27T13:30:45+0000"}}

Description

Arguments