Dear R Forum members,
I am wondering of anyone has used R to pull data from an Ingres SQL database?
My initial thoughts would be to use the RJDBC package and Ingres's JDBC
driver.
Before I get this thing together, has anyone used this combination and can
verify that it works, or can forewarn me of any "gotchas" that may be
lurking in the shadows? One uncomfortable feature with JDBC and similar
mechanisms is the need to expose the database user authentication details
in the clear. Our data is quite sensitive; while the systems upon which
this will run are well protected with firewalls, etc, etc I hesitate to
employ a scheme which exposes cleartext passwords...
I am thinking to employ a nested call in the JDBC interface which pulls the
authentication data from a severely (permission) restricted file. All I
then need to worry about is whether that authentication data is cached :-)
The alternative I suppose might be to create an R package using say C or
C++ which interfaces via Ingres's embedded SQL commands. Once compiled it
may offer a level of security against cracking? Thoughts appreciated.
Kind regards,
Denis
