90 likes | 296 Views
RELAIS Installation. Monica Scannapieco – Luca Valentino (ISTAT – Software Development Service). Training on the job in Record linkage, Central Statistical Bureau of Latvia - RIGA, 7-8 July 2011. Overview. Introduction Installation of Java Installation of R Installation of MySQL
E N D
RELAIS Installation Monica Scannapieco – Luca Valentino (ISTAT – Software Development Service) Training on the job in Record linkage, Central Statistical Bureau of Latvia -RIGA, 7-8 July 2011
Overview • Introduction • Installation of Java • Installation of R • Installation of MySQL • Installation of RELAIS Training on the job in Record linkage, Central Statistical Bureau of Latvia -RIGA, 7-8 July 2011
Introduction • RELAIS requires installation of : JAVA, R, MySQL JAVA JRE - JDK RELAIS MySQL MySQL ODBC Driver R Packages: lpSolve – RODBC Training on the job in Record linkage, Central Statistical Bureau of Latvia -RIGA, 7-8 July 2011
Installation of Java • JRE 6 • JDK 1.6 (http://www.oracle.com/technetwork/java/javase/downloads/index.html) • Modify the system variable PATH by adding the bin directory of JRE (for example: “C:\Program Files\Java\jre6\bin”) to modify system variable access to: Start -> Control panel -> System -> Advanced -> Environment variables Training on the job in Record linkage, Central Statistical Bureau of Latvia -RIGA, 7-8 July 2011
Installation of R • R 2.9 (or higher) (http://www.r-project.org/index.html) • Modify the system variable PATH by adding the bin directory of R (for example: “C:\Program Files\R\R-2.9\bin”) • Install packages “lpSolve” and “RODBC” choose item ‘Install packages’ in menu ‘Packages’ Training on the job in Record linkage, Central Statistical Bureau of Latvia -RIGA, 7-8 July 2011
Installation of MySQL database • Install MySQL Server 5.1 (or higher) (http://www.mysql.com/downloads/) • Configure MySQL Server Instance (using the ‘MySQL Server Instance Configuration Wizard) It is necessary to create an anonymous account for instance (in the security setting form) Training on the job in Record linkage, Central Statistical Bureau of Latvia -RIGA, 7-8 July 2011
Creation of OBDC data source • Install MySQL Connector ODBC driver (http://www.mysql.com/downloads/connector/odbc/) • Create a ODBC source named ‘relais’ for MySQL instance (Start -> Control panel -> Administration Tools -> Data Source (ODBC)) to test ODBC connection, creation of ‘relais’ database is required by typing the command: ‘create database relais;’ in mysql prompt Training on the job in Record linkage, Central Statistical Bureau of Latvia -RIGA, 7-8 July 2011
Installation of RELAIS • Execute RELAIS Setup Wizard (Relais-2.2-setup.exe) The directory Relais 2.2 will be created in your program folder with the binary files of the toolkit • It is recommended to check the folder permissions: the read-write permissions must be enabled for all users Training on the job in Record linkage, Central Statistical Bureau of Latvia -RIGA, 7-8 July 2011
Installation of RELAIS • Relais is installed, hence you can run it by executing the Relais.bat file Enjoy RELAIS ! Training on the job in Record linkage, Central Statistical Bureau of Latvia -RIGA, 7-8 July 2011