Transcription
OpenEMR Insights Configuration InstructionsOpenEMR Insights provides ETL and Dashboards to enhance your OpenEMR intelligence backedby Pentaho CE and Saiku Analytics CE.To see OpenEMR Insights in action, head over to www.oemr.org . There you will find examplesof ad hoc query output using Saiku Analytics CE. You will also be able to check out theconfiguration details on how you can put this to use on top of your own OpenEMR instanceusing Pentaho CE. Out-of-the-box, you can implement a data mart that unlocks services andreferrals, plus view sample parameterized dashboards .To get started with OpenEMR Insights, follow the instructions on www.oemr.org to access thedownload.Five Steps to Seeing Your Patients in a Whole New Way1. Download the OpenEMR Insights Package2. Setup Pentaho Business Analytics Server3. Configure Connections4. Configure Data Sources5. Build Your CubesThen you can query your data or view sample dashboards !System RecommendationsOS: Linux and Ubuntu - 14.04.1 LTSBrowser: Google Chrome Version 39Database: MySQLInstallation InstructionsInstall Open JDK on a new/existing Ubuntu Instance:1. Setup a Pentaho user and install OpenJDK:a. adduser pentahob. sudo su pentahoc. sudo apt-get install openjdkSetup and configure Pentaho Data Integration and Pentaho Business Analytics server1. Ensure Pentaho Data Integration is installed in /opt:a. cd /opt/b. e-5.2.0.0-209.zip .c. unzip pdi-ce-5.2.0.0-209.zipd. sudo chown -R ubuntu:ubuntu data-integration/Page 1 of 10
OpenEMR Insights Configuration Instructions2. Ensure installation of Pentaho Business Analytics in /opt:a. cd /opt/b. ho/Data%20Integration/5.2/pdi-ce-5.2.0.0-209.zip .c. unzip biserver-ce-5.2.0.0-209.zipd. sudo chown -R ubuntu:ubuntu pentaho/e. cd /opt/pentaho/biserver-ce/f. sh start-pentaho.sh3. Ensure that the Pentaho user owns the files under Data Integration and the BI Servera. chown -R pentaho:pentaho data-integration/ biserver-ce/4. Setup crontab:a. # m h dom mon dow commandb. 00 00 * * * /bin/run build fact client services.shc. 01 00 * * * /bin/run fact product sales.shConfigure Pentaho Data Integration JNDI connections1. Add the following properties to the jdbc.properties file. Modify the properties asneeded based on your MySQL username and password setup for both Source and TargetJNDI connections (and port if necessary).a. vim . #EMR Sourcea. emr source/type javax.sql.DataSourceb. emr source/driver com.mysql.jdbc.Driverc. emr source/url jdbc:mysql://localhost:3306/ source database named. emr source/user source database usere. emr source/password source database password3. #EMR Targeta. emr target/type javax.sql.DataSourceb. emr target/driver com.mysql.jdbc.Driverc. emr target/url jdbc:mysql://localhost:3306/ target database named. emr target/user target database usere. emr target/password target database password4. Ensure the MySQL Driver is available for the Data Integration server:a. cd /opt/data-integration/lib/b. /mysql-connector-java-5.1.35.tar.gz .c. gzip -d mysql-connector-java-5.1.35.tar.gzd. tar -xf mysql-connector-java-5.1.35.tare. mv .1.35-bin.jar .f. rm -r mysql-connector-java-5.1.35/Page 2 of 10
OpenEMR Insights Configuration InstructionsConfigure Pentaho Business Analytics Data Sources1. Login to Pentahoa. In a browser navigate to : http:// your url :8080/pentaho/Homeb. Login with username admin and password passwordc. Note: For security purposes it is recommended to change the password for the‘admin’ user account by navigating to Administration (from the Home dropdown in the upper left). This is also location where you can setup additionaluser roles.2. Manage Data Sourcesa. Select File\Manage Data Sourcesb. In the Manage Data Sources dialog box, click the cog icon and select NewConnection. Note: The SampleData and SteelWheels are example data that areautomatically installed. You can delete these if desired.Page 3 of 10
OpenEMR Insights Configuration Instructionsc. In the Database Connection window, enter the Connection Name, DatabaseType, Access (Native JDBC), Host Name, Database Name, Port Number, UserName, Password for the warehouse databased. Click the Test button to ensure the database parameters work properly beforecontinuing.e. Click Ok to save the connection and return the Manager Data Sources dialogbox.f. In the Manage Data Sources dialog box, click the cog icon and select ImportAnalysis.Page 4 of 10
OpenEMR Insights Configuration Instructionsg. Select the Mondrian schema from mondrian/OpenEMR.xml, select the newlycreated database connection and click Import.h. Click Close to close the Manage Data Sources dialog box.3. Refresh Cachesa. Go to Tools\Refresh\ and clear the following caches:i.Mondrian Schemaii.Reporting Data Cacheiii.CDA Data CacheBuild the Client Services and Product Sales Cubes1. Run the following commands in /home/ubuntu/a. git clone MR-Prototype.gitetlb. Run: cp -r /home/pentaho/etl/bin /home/pentaho/c. Run: mkdir /home/pentaho/log/d. Run: /home/pentaho/bin/e. Run: sh run build fact client services.shf. Run: sh run fact product sales.shCongratulations! Your configuration is now complete! Now you are ready to see your datain a whole new way!Page 5 of 10
OpenEMR Insights Configuration InstructionsQuerying the Data1. Login to your instance of Pentaho Business Analytics2. Select File\New\Saiku AnalyticsPage 6 of 10
OpenEMR Insights Configuration Instructions2. Click “Create a new query” from Quick Links section.3. Select the Client Services cube from the Select a cube drop down list.Page 7 of 10
OpenEMR Insights Configuration Instructions4. Drag and drop the Measures and Dimensions from the left to the appropriate section on theright (Measures, Columns, Rows, Filter) to build your query. You will need to select at leastone dimension in the rows drop down area, and either one measure in the measures dropdown area, or another dimension in the columns drop down area. Once you have done this,the query will execute and the results will be displayed on the query canvas.Page 8 of 10
OpenEMR Insights Configuration Instructions5. Results return by default in Table Mode, but don’t forget that you can always toggle toChart Mode to visualize the data using various chart types.Page 9 of 10
OpenEMR Insights Configuration InstructionsView Sample Dashboards1. Select Tools\OpenEMR Reporting from the menu.2. The Directory of Reports will appear with available sample dashboards.Page 10 of 10
1.Download the OpenEMR Insights Package 2.Setup Pentaho Business Analytics Server 3.Configure Connections . Setup and configure Pentaho Data Integration and Pentaho Business Analytics server 1. Ensure Pentaho Data Integration is installed in /opt: a. cd /opt/ b. wget
