ETLUtils | easily loading big data from relational databases | Database library

by jwijffels R Version: Current License: No License

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | ETLUtils Summary

ETLUtils is a R library typically used in Database, Oracle applications. ETLUtils has no bugs, it has no vulnerabilities and it has low support. You can download it from GitHub.

ETLUtils provides utility functions to execute standard ETL operations (using package ff) on large data. Currently the following functions might be useful to you if you have some large dataset in SQL and want to import it immediately in an ffdf object. An example can be found at and at For users who want to store data from an ffdf back in a database, the package also provides. This is the development version of the package which is available at CRAN. To install the latest version from github remotes::install_github("jwijffels/ETLUtils").

Support

Quality

Security

License

Reuse

Support

ETLUtils has a low active ecosystem.

It has 18 star(s) with 6 fork(s). There are 5 watchers for this library.

It had no major release in the last 6 months.

There are 2 open issues and 3 have been closed. On average issues are closed in 0 days. There are 1 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of ETLUtils is current.

Quality

ETLUtils has 0 bugs and 0 code smells.

Security

ETLUtils has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

ETLUtils code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

ETLUtils does not have a standard license declared.

Check the repository for any license declaration and review the terms closely.

Without a license, all rights are reserved, and you cannot use the library in your applications.

Reuse

ETLUtils releases are not available. You will need to build from source code and install.

Installation instructions are not available. Examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of ETLUtils

Get all kandi verified functions for this library.

ETLUtils Key Features

No Key Features are available at this moment for ETLUtils.

ETLUtils Examples and Code Snippets

No Code Snippets are available at this moment for ETLUtils.

Community Discussions

Trending Discussions on ETLUtils

Query SQL Server from R with ETLUtils for big tables

QUESTION

Query SQL Server from R with ETLUtils for big tables

Asked 2017-Jan-07 at 02:11

Normally to query a sql-server database from R, I'd use:

...

ANSWER

Answered 2017-Jan-07 at 02:11

Currently you are passing what seems to be the previous RODBC connection object, con, into read.odbc.ffdf() but remember the method is attempting to create an ODBC connection and call a query. The R docs mention the proper assignment of odbcConnect.args:

odbcConnect.args a list of arguments to pass to ODBC's odbcConnect (like dsn, uid, pwd)

Consider passing your original DSN and credentials like you did in regular RODBC connection:

Source https://stackoverflow.com/questions/41509097

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install ETLUtils

You can download it from GitHub.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: