Package: odbc 1.5.0
odbc: Connect to ODBC Compatible Databases (using the DBI Interface)
A DBI-compatible interface to ODBC databases.
Authors:
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')) |
Bug tracker:https://github.com/r-dbi/odbc/issues
Pkgdown:https://odbc.r-dbi.org
Last updated 6 months agofrom:a52272675d. Checks:OK: 1 NOTE: 1. Indexed: no.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Dec 03 2024 |
R-4.5-linux-x86_64 | NOTE | Dec 03 2024 |
Exports:databricksdbAppendTabledbBegindbBinddbClearResultdbColumnInfodbCommitdbConnectdbDataTypedbDisconnectdbExecutedbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsValiddbListFieldsdbListTablesdbQuoteIdentifierdbQuoteStringdbRemoveTabledbRollbackdbSendQuerydbSendStatementdbWriteTableisTempTableodbcodbcConnectionActionsodbcConnectionColumnsodbcConnectionIconodbcDataTypeodbcListColumnsodbcListConfigodbcListDataSourcesodbcListDriversodbcListObjectsodbcListObjectTypesodbcPreviewObjectodbcSetTransactionIsolationLevelquote_valueshowsnowflakesqlCreateTablesqlData
Dependencies:bitbit64blobcliDBIgluehmslifecyclepkgconfigRcpprlangvctrs
Benchmarks
Rendered frombenchmarks.Rmd
usingknitr::rmarkdown
on Dec 03 2024.Last update: 2023-12-16
Started: 2023-12-16
Developing odbc
Rendered fromdevelop.Rmd
usingknitr::rmarkdown
on Dec 03 2024.Last update: 2024-06-06
Started: 2023-12-16
Installing and Configuring Drivers
Rendered fromsetup.Rmd
usingknitr::rmarkdown
on Dec 03 2024.Last update: 2024-06-06
Started: 2023-12-16
Readme and manuals
Help Manual
Help page | Topics |
---|---|
Helper for Connecting to Databricks via ODBC | databricks DatabricksOdbcDriver-class dbConnect,DatabricksOdbcDriver-method |
Convenience functions for reading/writing DBMS tables | dbAppendTable,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 connection | dbListTables,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 driver | dbConnect dbConnect,OdbcDriver-method odbc |
Connecting to Snowflake via ODBC | dbExistsTableForWrite,Snowflake,character-method odbcConnectionColumns_,Snowflake,character-method |
Return the corresponding ODBC data type for an R object | odbcDataType 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 files | odbcListConfig |
List Configured Data Source Names | odbcListDataSources |
List Configured ODBC Drivers | odbcListDrivers |
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 Connection | odbcSetTransactionIsolationLevel |
Quote special character when connecting | quote_value |
Helper for connecting to Snowflake via ODBC | dbConnect,Snowflake-method snowflake |