CRAN/E | ETLUtils

ETLUtils

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

Installation

About

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.

github.com/jwijffels/ETLUtils

Key Metrics

Version 1.5
Published 2020-08-03 1361 days ago
Needs compilation? no
License GPL-2
CRAN checks ETLUtils results

Downloads

Yesterday 19 +46%
Last 7 days 75 -23%
Last 30 days 327 +15%
Last 90 days 910 -11%
Last 365 days 3.486 -22%

Maintainer

Maintainer

Jan Wijffels

jwijffels@bnosac.be

Authors

Jan Wijffels

Material

README
NEWS
Reference manual
Package source

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

r-oldrel

x86_64

Windows

r-devel

x86_64

r-release

x86_64

r-oldrel

x86_64

Old Sources

ETLUtils archive

Depends

ff ≥ 4.0.0

Imports

bit ≥ 4.0.0

Suggests

RSQLite
zoo
DBI
RODBC
RJDBC