Provides functions to facilitate the use of the 'ff' package in interaction with big data in 'SQL' databases (e.g. in 'Oracle', 'MySQL', 'PostgreSQL', 'Hive') by allowing easy importing directly into 'ffdf' objects using 'DBI', 'RODBC' and 'RJDBC'. Also contains some basic utility functions to do fast left outer join merging based on 'match', factorisation of data and a basic function for re-coding vectors.

Documentation

Manual: ETLUtils.pdf
Vignette: None available.

Maintainer: Jan Wijffels <jwijffels at bnosac.be>

Author(s): Jan Wijffels

Install package and any missing dependencies by running this line in your R console:

install.packages("ETLUtils")

Depends ff(>=2.2-13)
Imports bit(>=1.1-12)
Suggests RSQLite, zoo, DBI, RODBC, RJDBC
Enhances
Linking to
Reverse
depends
Reverse
imports
Reverse
suggests
Reverse
enhances
Reverse
linking to

Package ETLUtils
Materials
URL https://github.com/jwijffels/ETLUtils http://www.bnosac.be
Task Views
Version 1.3
Published 2015-05-18
License GPL-2
BugReports
SystemRequirements
NeedsCompilation no
Citation
CRAN checks ETLUtils check results
Package source ETLUtils_1.3.tar.gz