Package: ETLUtils 1.5

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.

Authors:Jan Wijffels

ETLUtils_1.5.tar.gz
ETLUtils_1.5.zip(r-4.5)ETLUtils_1.5.zip(r-4.4)ETLUtils_1.5.zip(r-4.3)
ETLUtils_1.5.tgz(r-4.4-any)ETLUtils_1.5.tgz(r-4.3-any)
ETLUtils_1.5.tar.gz(r-4.5-noble)ETLUtils_1.5.tar.gz(r-4.4-noble)
ETLUtils_1.5.tgz(r-4.4-emscripten)ETLUtils_1.5.tgz(r-4.3-emscripten)
ETLUtils.pdf |ETLUtils.html✨
ETLUtils/json (API)
NEWS

# Install 'ETLUtils' in R:
install.packages('ETLUtils', repos = c('https://jwijffels.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/jwijffels/etlutils/issues

On CRAN:

4.72 score 20 stars 26 scripts 273 downloads 11 exports 2 dependencies

Last updated 4 years agofrom:dd24d0c8af. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKNov 12 2024
R-4.5-winOKNov 12 2024
R-4.5-linuxOKNov 12 2024
R-4.4-winOKNov 12 2024
R-4.4-macOKNov 12 2024
R-4.3-winOKNov 12 2024
R-4.3-macOKNov 12 2024

Exports:factorisematchmergenaLOCFPlusoneread.dbi.ffdfread.jdbc.ffdfread.odbc.ffdfrecoderrenameColumnswrite.dbi.ffdfwrite.jdbc.ffdfwrite.odbc.ffdf

Dependencies:bitff