explore (version 0.8.0)

dwh_fastload: write data to a DWH table

Description

write data fast to a DWH table using a ODBC connection Function uses packages DBI/odbc to write data faster than RODBC Connects, writes data and disconnects

Usage

dwh_fastload(data, dsn, table, overwrite = FALSE, append = FALSE, ...)

Value

status

Arguments

data

dataframe

dsn

DSN string

table

table name (character string)

overwrite

Overwrite table if already exist

append

Append data to table

...

Further arguments to be passed to DBI::dbConnect()

Examples

if (FALSE) {
dwh_fastload(data, "DWH", "database.table_test")
}