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:
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
Last updated 6 months agofrom:a52272675d. Checks:OK: 1 NOTE: 1. Indexed: no.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Nov 03 2024 |
| R-4.5-linux-x86_64 | NOTE | Nov 03 2024 |
Exports:databricksdbAppendTabledbBegindbBinddbClearResultdbColumnInfodbCommitdbConnectdbDataTypedbDisconnectdbExecutedbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsValiddbListFieldsdbListTablesdbQuoteIdentifierdbQuoteStringdbRemoveTabledbRollbackdbSendQuerydbSendStatementdbWriteTableisTempTableodbcodbcConnectionActionsodbcConnectionColumnsodbcConnectionIconodbcDataTypeodbcListColumnsodbcListConfigodbcListDataSourcesodbcListDriversodbcListObjectsodbcListObjectTypesodbcPreviewObjectodbcSetTransactionIsolationLevelquote_valueshowsnowflakesqlCreateTablesqlData
Dependencies:bitbit64blobcliDBIgluehmslifecyclepkgconfigRcpprlangvctrs
Benchmarks
Rendered frombenchmarks.Rmdusingknitr::rmarkdownon Nov 03 2024.Last update: 2023-12-16
Started: 2023-12-16
Developing odbc
Rendered fromdevelop.Rmdusingknitr::rmarkdownon Nov 03 2024.Last update: 2024-06-06
Started: 2023-12-16
Installing and Configuring Drivers
Rendered fromsetup.Rmdusingknitr::rmarkdownon Nov 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 |
