RSQLServer: SQL Server R Database Interface (DBI) and dplyr SQL Backend

Utilises The jTDS Project's JDBC 3.0 SQL Server driver to extend the RJDBC classes and DBI methods. It defines a SQLServerDriver, SQLServerConnection & SQLServerRsult S4 classes as extensions of the RJDBC equivalent classes with most DBI methods being thin extensions of the methods defined by RJDBC classes. However, the dbConnect interface is more convenient, and the data reading and writing capabilities found in RJDBC's fetch and dbWriteTable methods have been refined. The package also implements a SQL backend to the dplyr package.

AuthorImanuel Costigan [aut, cre], The jTDS Project (for MSSQL Server driver) [aut], Simon Urbanek [ctb], Hadley Wickham [ctb], Romain Francois [ctb], RStudio [cph], The Legion Of The Bouncy Castle [cph, ctb]
Date of publication2016-03-22 20:08:08
MaintainerImanuel Costigan <i.costigan@me.com>
LicenseGPL-2
Version0.2.0
https://github.com/imanuelcostigan/RSQLServer

View on CRAN

Functions

dbColumnInfo,SQLServerResult-method Man page
dbColumnInfo,SQLServerResult-method Man page
dbConnect,SQLServerDriver-method Man page
dbConnect,SQLServerDriver-method Man page
dbDataType,SQLServerConnection-method Man page
dbDataType,SQLServerConnection-method Man page
dbExistsTable,SQLServerConnection-method Man page
dbExistsTable,SQLServerConnection-method Man page
dbFetch,SQLServerResult,numeric-method Man page
dbFetch,SQLServerResult,numeric-method Man page
dbGetInfo,SQLServerConnection-method Man page
dbGetInfo,SQLServerConnection-method Man page
dbGetInfo,SQLServerDriver-method Man page
dbGetInfo,SQLServerDriver-method Man page
dbGetInfo,SQLServerResult-method Man page
dbGetInfo,SQLServerResult-method Man page
dbHasCompleted,SQLServerResult-method Man page
dbHasCompleted,SQLServerResult-method Man page
dbIsValid,SQLServerConnection-method Man page
dbIsValid,SQLServerConnection-method Man page
dbIsValid,SQLServerResult-method Man page
dbIsValid,SQLServerResult-method Man page
dbListTables,SQLServerConnection-method Man page
dbListTables,SQLServerConnection-method Man page
dbSendQuery,SQLServerConnection,character-method Man page
dbSendQuery,SQLServerConnection,character-method Man page
dbSendUpdate,SQLServerConnection,character-method Man page
dbSendUpdate,SQLServerConnection,character-method Man page
dbWriteTable,SQLServerConnection-method Man page
dbWriteTable,SQLServerConnection-method Man page
fetch,SQLServerResult,numeric-method Man page
fetch,SQLServerResult,numeric-method Man page
get_server_details Man page
get_server_details Man page
have_test_server Man page
have_test_server Man page
intersect Man page
intersect Man page
intersect.tbl_sqlserver Man page
intersect.tbl_sqlserver Man page
RSQLServer Man page
RSQLServer Man page
RSQLServer-package Man page
RSQLServer-package Man page
setdiff Man page
setdiff Man page
setdiff.tbl_sqlserver Man page
setdiff.tbl_sqlserver Man page
setops Man page
setops Man page
show,SQLServerConnection-method Man page
show,SQLServerConnection-method Man page
show,SQLServerDriver-method Man page
show,SQLServerDriver-method Man page
SQLServer Man page
SQLServer Man page
SQLServerConnection-class Man page
SQLServerConnection-class Man page
SQLServerDriver-class Man page
SQLServerDriver-class Man page
SQLServerResult-class Man page
SQLServerResult-class Man page
src_sqlserver Man page
src_sqlserver Man page

Files

RSQLServer
RSQLServer/inst
RSQLServer/inst/java
RSQLServer/inst/java/jtds-1.2.8.jar
RSQLServer/inst/extdata
RSQLServer/inst/extdata/sql.yaml
RSQLServer/tests
RSQLServer/tests/testthat.R
RSQLServer/tests/testthat
RSQLServer/tests/testthat/test-rsqlserver.R
RSQLServer/NAMESPACE
RSQLServer/NEWS.md
RSQLServer/R
RSQLServer/R/dbi-shims.R
RSQLServer/R/Utils.R
RSQLServer/R/onLoad.R
RSQLServer/R/dbi-classes.R
RSQLServer/R/dplyr.R
RSQLServer/R/RSQLServer.R
RSQLServer/R/jdbc-methods.R
RSQLServer/R/sql-backends.R
RSQLServer/R/dbi-methods.R
RSQLServer/R/sql-methods.R
RSQLServer/R/dplyr-imports.R
RSQLServer/README.md
RSQLServer/MD5
RSQLServer/java
RSQLServer/java/jTDS1.2.8
RSQLServer/java/jTDS1.2.8/src
RSQLServer/java/jTDS1.2.8/src/main
RSQLServer/java/jTDS1.2.8/src/main/net
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/ssl
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/ssl/Ssl.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/ssl/SocketFactories.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/ssl/TdsTlsOutputStream.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/ssl/SocketFactoriesSUN.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/ssl/TdsTlsSocket.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/ssl/TdsTlsInputStream.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/README.SSL
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/MSCursorResultSet.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/cache
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/cache/SimpleLRUCache.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/cache/StatementCache.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/cache/SQLCacheKey.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/cache/ProcedureCache.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/ConnectionJDBC3.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/JtdsPreparedStatement.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/TdsCore.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/NtlmAuth.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/TypeInfo.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/MSSqlServerInfo.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/RequestStream.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/SavepointImpl.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/ConnectionJDBC2.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/CachedResultSet.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/Messages.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/ClobImpl.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/UniqueIdentifier.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/SharedSocket.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/ProcEntry.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/JtdsResultSet.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/SharedLocalNamedPipe.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/JtdsStatement.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/ResponseStream.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/XASupport.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/ParamInfo.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/CharsetInfo.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/DateTime.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/ColInfo.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/Semaphore.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/DefaultProperties.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/SQLParser.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/BlobImpl.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/SharedNamedPipe.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/Driver.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/JtdsResultSetMetaData.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/SQLDiagnostic.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/ProtocolException.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/Charsets.properties
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/Messages.properties
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/TdsData.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/Support.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/JtdsDatabaseMetaData.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/JtdsCallableStatement.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbc/ParameterMetaDataImpl.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/README.SSO
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/README
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbcx
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbcx/JtdsDataSource.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbcx/PooledConnection.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbcx/JtdsXAConnection.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbcx/JtdsXid.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbcx/JtdsXAResource.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbcx/proxy
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbcx/proxy/ConnectionProxy.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbcx/proxy/PreparedStatementProxy.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbcx/proxy/StatementProxy.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbcx/proxy/CallableStatementProxy.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/jdbcx/JtdsObjectFactory.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/README.XA
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/util
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/util/Logger.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/util/DESEngine.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/util/MD4Digest.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/util/TimerThread.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/util/MD5Digest.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/util/SSPIJNIClient.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/util/GeneralDigest.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/util/BlobBuffer.java
RSQLServer/java/jTDS1.2.8/src/main/net/sourceforge/jtds/LICENSE
RSQLServer/java/jTDS1.2.8/README.SSL
RSQLServer/java/jTDS1.2.8/README.SSO
RSQLServer/java/jTDS1.2.8/README
RSQLServer/java/jTDS1.2.8/README.XA
RSQLServer/java/jTDS1.2.8/LICENSE
RSQLServer/DESCRIPTION
RSQLServer/man
RSQLServer/man/get_server_details.Rd RSQLServer/man/SQLServerResult-class.Rd RSQLServer/man/have_test_server.Rd RSQLServer/man/setops.Rd RSQLServer/man/SQLServer.Rd RSQLServer/man/src_sqlserver.Rd RSQLServer/man/SQLServerDriver-class.Rd RSQLServer/man/SQLServerConnection-class.Rd RSQLServer/man/RSQLServer.Rd

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.