connect_illuminate: connect to illuminat database or warehouse

Description Usage Arguments

Description

Simple wrapper function that establishes a conect to a database that is suitable for using with dplyr.

Usage

1
2
connect_illuminate(server, database, port, user, password,
  db_type = "warehouse")

Arguments

server

the IP address of the data base server

database

the name of the database to be connected to

port

the port number on which the database server listens

user

a user name

password

the user's password

db_type

one of either "warehouse" or "direct". "Warehouse" connects to a SQL server database. "Direct" connects to site specific PostgreSQL instance maintained by Illuminate. You'll need to get our computer's (i.e. the machine running using this R package) IP adress whilelisted by Illuminate. One benefit of the "warehouse" setting is that you can connect other databases (say, a PowerSchool mirror).


chrishaid/illuminater documentation built on May 13, 2019, 6:53 p.m.