Simple wrapper function that establishes a conect to a database
that is suitable for using with dplyr
.
1 2 | connect_illuminate(server, database, port, user, password,
db_type = "warehouse")
|
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). |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.