...
By default, users will have the following installed on their workstations:
· Python
· Cyberduck
· 7-zip
· Javelin PDF Reader
· Notepad++
· Git
· Git Extensions
· Meld
· Google Chrome
· JDK (JAVA)
· LibreOffice
· Putty
· R
· RStudio Desktop
· SQL Workbench
· Anaconda
· KeePass
Connecting to the Data Warehouse
...
Credentials to access the Waze Redshift database are communicated from the SDC Support (sdc-support@dot.gov)•
In R, it is possible to connect to Redshift using multiple packages. The RPostgreSQL
package provides a simple method. This package requires the PostgreSQL library to be
installed at the system level; if it is not installed, it would be necessary to install as root in
the terminal:
$ sudo yum install postgresql-devel
•
In R, you may need to install.packages(“RPostgreSQL”, dep=T) if you
do not already have the package installed.
...
Connect to Redshift using the following code as a guide:
| Code Block |
|---|
library(RPostgres)
# Specify username and password manually, once:
if(Sys.getenv("sdc_waze_username")==""){
cat("Please enter SDC Waze username and password
manually, in the console, the first time accessing the
Redshift database, using: \n Sys.setenv('sdc_waze_username'
= <see email from SDC Administrator>) \n
Sys.setenv('sdc_waze_password' = <see email from SDC
Administrator>)")
}
redshift_host <- "(details provided by SDC Support to
registered SDC Redshift Users)"
redshift_port <- "5439"
redshift_user <- Sys.getenv("sdc_waze_username")
redshift_password <- Sys.getenv("sdc_waze_password")
redshift_db <- "dot_sdc_redshift_db"
#drv <- dbDriver("PostgreSQL")
conn <- dbConnect(
RPostgres::Postgres(),
host=redshift_host,
port=redshift_port,
user=redshift_user,
password=redshift_password,
dbname=redshift_db)
|
...
A database can then be queried using the dbGetQuery() function.
Accessing Jupyter Notebook and RStudio Server
Linux users can access their Jupyter Notebook and RStudio Server using the Firefox web
browser through windows workstation using below URLs.•
...
Jupyter Notebook – http://<username>-workspace.internal.sdc.dot.gov:8888/
Windows users can click on the “RStudio” shortcut icon present on the desktop to open
RStudio console.
...