Setting Up R

After installing R, set up the R script to connect directly to STARUSER and calculates the predicted outcome for pre-selected projects as follows:

Create table etl_aa, which contains the project_object_id for the projects that will be calculated.
CREATE TABLE etl_aa(project_object_id number(19));
Insert the project_object_id for the selected project.
INSERT INTO etl_aa(project_object_id) values (4351);

INSERT INTO etl_aa(project_object_id) values (4352);

INSERT INTO etl_aa(project_object_id) values (4354);

INSERT INTO etl_aa(project_object_id) values (3577);

INSERT INTO etl_aa(project_object_id) values (4049);

INSERT INTO etl_aa(project_object_id) values (4301);

commit;
Open R Studio.
1. Install the following packages: rJava, RJDBC, glm2
  install.packages("rJava")
  
  install.packages("RJDBC")
  
  install.packages("glm2")
2. Set the working directory to a folder that contains ojdbc6.jar.
Open the attached R script.
1. Change the database connection.
2. Run the script.
  The results will be in W_UDF_PROJECT_D