ETLUtils: Utility Functions to Execute Standard Extract/Transform/Load Operations (using Package 'ff') on Large Data

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.

Version: 1.5
Depends: ff (≥ 4.0.0)
Imports: bit (≥ 4.0.0)
Suggests: RSQLite, zoo, DBI, RODBC, RJDBC
Published: 2020-08-03
DOI: 10.32614/CRAN.package.ETLUtils
Author: Jan Wijffels
Maintainer: Jan Wijffels <jwijffels at bnosac.be>
License: GPL-2
URL: https://github.com/jwijffels/ETLUtils
NeedsCompilation: no
Materials: README NEWS
CRAN checks: ETLUtils results

Documentation:

Reference manual: ETLUtils.pdf

Downloads:

Package source: ETLUtils_1.5.tar.gz
Windows binaries: r-devel: ETLUtils_1.5.zip, r-release: ETLUtils_1.5.zip, r-oldrel: ETLUtils_1.5.zip
macOS binaries: r-release (arm64): ETLUtils_1.5.tgz, r-oldrel (arm64): ETLUtils_1.5.tgz, r-release (x86_64): ETLUtils_1.5.tgz, r-oldrel (x86_64): ETLUtils_1.5.tgz
Old sources: ETLUtils archive

Linking:

Please use the canonical form https://CRAN.R-project.org/package=ETLUtils to link to this page.