Connect to ODBC Compatible Databases (using the DBI Interface)


[Up] [Top]

Documentation for package ‘odbc’ version 1.6.1

Help Pages

databricks Helper for Connecting to Databricks via ODBC
DatabricksOdbcDriver-class Helper for Connecting to Databricks via ODBC
dbAppendTable-method Convenience functions for reading/writing DBMS tables
dbConnect Connect to a database via an ODBC driver
dbConnect-method Helper for Connecting to Databricks via ODBC
dbConnect-method Connect to a database via an ODBC driver
dbConnect-method Helper for Connecting to Redshift via ODBC
dbConnect-method Helper for connecting to Snowflake via ODBC
dbExistsTableForWrite-method Connecting to Snowflake via ODBC
DBI-tables Convenience functions for reading/writing DBMS tables
dbListTables-method List remote tables and fields for an ODBC connection
dbWriteTable-method Convenience functions for reading/writing DBMS tables
isTempTable Helper method used to determine if a table identifier is that of a temporary table.
isTempTable-method Helper method used to determine if a table identifier is that of a temporary table.
odbc Connect to a database via an ODBC driver
odbcConnectionColumns_-method Connecting to Snowflake via ODBC
odbcDataType Return the corresponding ODBC data type for an R object
odbcDataType-method Return the corresponding ODBC data type for an R object
odbcEditDrivers List locations of ODBC configuration files
odbcEditSystemDSN List locations of ODBC configuration files
odbcEditUserDSN List locations of ODBC configuration files
odbcListColumns List columns in an object.
odbcListConfig List locations of ODBC configuration files
odbcListDataSources List Configured Data Source Names
odbcListDrivers List Configured ODBC Drivers
odbcListObjects List objects in a connection.
odbcListObjectTypes Return the object hierarchy supported by a connection.
odbcPreviewObject Preview the data in an object.
odbcSetTransactionIsolationLevel Set the Transaction Isolation Level for a Connection
quote_value Quote special character when connecting
redshift Helper for Connecting to Redshift via ODBC
RedshiftOdbcDriver-class Helper for Connecting to Redshift via ODBC
snowflake Helper for connecting to Snowflake via ODBC
SnowflakeOdbcDriver-class Helper for connecting to Snowflake via ODBC
sqlCreateTable-method Convenience functions for reading/writing DBMS tables