Configuring and deploying SSIS Package

  1. Click HRCM SSIS.sln link in theInfor\HRCM Analytics group in the Start Menu. If you don’t have Administrative permissions, you will be prompted to restart the application with elevated permissions.
  2. In the Connection Managers pane, click HRCM_DataMart Data Source and update the connection to the Revenue Cycle Management Data Mart that you specified during the HRCM Analytics – Core installation process. The default name is HRCM_BI.
  3. In the Connection Managers pane, click HRCM_Source Data Source and update the server location to reflect your installation. Specify this information:
    Server or file name
    Specify the TNSNAMES connection alias for your HRCM application database.
    Username
    Specify HRCM database schema.
    Password
    Specify HRCM database password.
  4. Test the Connection to the database. If the entries are correct, then a message "Test connection succeeded” is displayed.
    Note: The default schema for the HRCM_Source is HRCM, if you want to use a different schema, then you will must update the variable HRCMSchema. The variable is defined at the package level. To access the variables, select SSIS > Variables. You can change the default setting for the variable to adjust the queries to use your desired schema. All variable must be specified in upper case.
  5. To save the oracle password in the package, you must provide a level of encryption through a password on the project and package. Right-click HRCMSSIS project and select Properties. Set ProtectionLevel to Encrypt all data with password and then specify the password. In package properties, set ProtectionLevel to EncryptAllWithPassword, and then set the PackagePassword.
  6. To deploy SSIS Project, right-click HRCMSSIS project, then select Deploy and follow Integration Services Deployment Wizard steps.
  7. On Select Destination step specify the SQL Server Name or click Browse to select it from the list of servers. Specify the project Path or click Browse to select it from the list.
  8. Click Next to review the settings and then click Deploy.