Package: odbc 1.5.0

Hadley Wickham

odbc: Connect to ODBC Compatible Databases (using the DBI Interface)

A DBI-compatible interface to ODBC databases.

Authors:Jim Hester [aut], Hadley Wickham [aut, cre], Oliver Gjoneski [aut], lexicalunit [cph], Google Inc. [cph], Posit Software, PBC [cph, fnd]

odbc_1.5.0.tar.gz
odbc_1.5.0.tar.gz(r-4.5-noble)odbc_1.5.0.tar.gz(r-4.4-noble)
odbc.pdf |odbc.html✨
odbc/json (API)
NEWS

# Install 'odbc' in R:
install.packages('odbc', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/r-dbi/odbc/issues

Uses libs:
  • unixodbc– ODBC Driver Manager library for Unix
  • c++– GNU Standard C++ Library v3

10.46 score 20 packages 5.0k scripts 80k downloads 2 mentions 48 exports 12 dependencies

Last updated 5 months agofrom:a52272675d. Checks:OK: 1 NOTE: 1. Indexed: no.

TargetResultDate
Doc / VignettesOKOct 04 2024
R-4.5-linux-x86_64NOTEOct 04 2024

Exports:databricksdbAppendTabledbBegindbBinddbClearResultdbColumnInfodbCommitdbConnectdbDataTypedbDisconnectdbExecutedbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsValiddbListFieldsdbListTablesdbQuoteIdentifierdbQuoteStringdbRemoveTabledbRollbackdbSendQuerydbSendStatementdbWriteTableisTempTableodbcodbcConnectionActionsodbcConnectionColumnsodbcConnectionIconodbcDataTypeodbcListColumnsodbcListConfigodbcListDataSourcesodbcListDriversodbcListObjectsodbcListObjectTypesodbcPreviewObjectodbcSetTransactionIsolationLevelquote_valueshowsnowflakesqlCreateTablesqlData

Dependencies:bitbit64blobcliDBIgluehmslifecyclepkgconfigRcpprlangvctrs

Benchmarks

Rendered frombenchmarks.Rmdusingknitr::rmarkdownon Oct 04 2024.

Last update: 2023-12-16
Started: 2023-12-16

Developing odbc

Rendered fromdevelop.Rmdusingknitr::rmarkdownon Oct 04 2024.

Last update: 2024-06-06
Started: 2023-12-16

Installing and Configuring Drivers

Rendered fromsetup.Rmdusingknitr::rmarkdownon Oct 04 2024.

Last update: 2024-06-06
Started: 2023-12-16

Readme and manuals

Help Manual

Help pageTopics
Helper for Connecting to Databricks via ODBCdatabricks DatabricksOdbcDriver-class dbConnect,DatabricksOdbcDriver-method
Convenience functions for reading/writing DBMS tablesdbAppendTable,OdbcConnection-method DBI-tables dbWriteTable,OdbcConnection,character,data.frame-method dbWriteTable,OdbcConnection,Id,data.frame-method dbWriteTable,OdbcConnection,SQL,data.frame-method sqlCreateTable,OdbcConnection-method
List remote tables and fields for an ODBC connectiondbListTables,OdbcConnection-method
Helper method used to determine if a table identifier is that of a temporary table.isTempTable isTempTable,OdbcConnection,Id-method isTempTable,OdbcConnection,SQL-method
Connect to a database via an ODBC driverdbConnect dbConnect,OdbcDriver-method odbc
Connecting to Snowflake via ODBCdbExistsTableForWrite,Snowflake,character-method odbcConnectionColumns_,Snowflake,character-method
Return the corresponding ODBC data type for an R objectodbcDataType odbcDataType,ACCESS-method odbcDataType,ANY-method odbcDataType,BigQuery-method odbcDataType,Hive-method odbcDataType,Impala-method odbcDataType,Microsoft SQL Server-method odbcDataType,MySQL-method odbcDataType,Oracle-method odbcDataType,PostgreSQL-method odbcDataType,Redshift-method odbcDataType,Snowflake-method odbcDataType,Spark SQL-method odbcDataType,SQLite-method odbcDataType,Teradata-method odbcDataType,Vertica Database-method
List columns in an object.odbcListColumns
List locations of ODBC configuration filesodbcListConfig
List Configured Data Source NamesodbcListDataSources
List Configured ODBC DriversodbcListDrivers
List objects in a connection.odbcListObjects
Return the object hierarchy supported by a connection.odbcListObjectTypes
Preview the data in an object.odbcPreviewObject
Set the Transaction Isolation Level for a ConnectionodbcSetTransactionIsolationLevel
Quote special character when connectingquote_value
Helper for connecting to Snowflake via ODBCdbConnect,Snowflake-method snowflake