Deploy Data Loaders

If you want to use SSL for connections from APM Connect, this step is required.

1. Log in to your application, and then access the certificate information from your browser.
   Note: Typically, you can access certificate information by selecting the lock icon in the address bar.
   The Certificate window appears.
2. Select Details, and then select Copy to File....
   The Certificate Export Wizard window appears.
   
   
3. Select Next.
4. In the Export File Format window, select DER encoded binary X.509 (.cer), and then select Next.
5. In the File to Export window, select Browse….

   The Save As window appears.

6. Save the file to your Desktop under the name certificate.cer.
7. Select Next.
8. Select Finish.

   The Certificate Export Wizard window appears.

   
   
   
9. Select OK.
10. Copy the certificate.cer file, and then paste it into the folder that contains the Java files for your machine.
    Tip: For example, if your Java files are located at C:\Program Files\Java\jre7\bin, copy the certificate.cer file to that bin folder.
11. On the APM Connect server, access the Command Prompt window as an Administrator, and then navigate to the location of the Java files on your machine.
12. Enter keytool.
    Commands for the Key and Certificate Management Tool appear in the Command Prompt.
13. In the last line, C:\Program Files\Java\jre7\bin>, enter keytool –importcert –alias test –file certificate.cer –keystore publickey.store.
14. Enter a password, and confirm the password by reentering it.
    In the Command Prompt window, you are asked if you want to trust the certificate.
15. For yes, enter y.
    The keystore file is created.
16. For the Karaf service, navigate to the location of the Karaf JDK, and then repeat steps 12 through 15 using the path and password for the Karaf service JDK.
    • For the value of the keystore argument, use the file path of the Karaf JDK, (for example, C:\Program Files\Java\<JDK version>\jre\lib\security\cacerts).
    • The default password for keytool is changeit. Enter your unique value.
17. Access the context file, and then enter the following values for the corresponding parameters:

    • TRUSTSTORE_FILE: The location of the truststore file you created.

    • TRUSTSTORE_PASSWORD: The password you entered in the Command Prompt window when you installed the certificate.
    • USE_SSL: true.
    • APM_API_USE_SSL: true, if you are using SSL on the GE Digital APM Server.

This topic describes the steps for setting up the permissions required to enable the file share.

• To create a domain user for the APM Container:
  1. On the machine on which you installed APM Connect, from your desktop, select the Windows Start button to open the Windows Start Menu.
  2. In the Search programs and files box, search for Run.
     Run appears in the Programs list.
  3. Open Run.
     The Run window appears.
  4. In the Open box, enter: services.msc.
     
     
  5. Select OK.
     The Services window appears.
  6. Right-click APM-CONTAINER, and then select Properties.
     The APM-CONTAINER Properties window appears.
  7. Select the Log On tab, and then select This account.
  8. Enter the credentials for a user within your network, designated to run APM Connect services.
     [email protected]
     
     
  9. Select Apply, and then select OK.
  10. Repeat Steps 6-8 for the service Apache Tomcat 7.0 APMConnect_Tomcat.
      A domain user has been assigned to run the APM Container service and the Tomcat service.
• To create a Data Loaders file share:
  Important: If you are employing a load-balancing setup using multiple servers, before you proceed, you must first configure the APM Server file share. If you are employing a standalone server, you may proceed with the following steps.
  1. On your APM Connect Server, navigate to the APM Connect directory at the following file path: <root:>\APMConnect\.
  2. In the directory window, select New folder, and then name the folder with the recommended name: DataLoaderFiles.
  3. Right-click the folder DataLoaderFiles.
  4. Point to Share with, and then select Specific people....
  5. In the File Sharing window, select the domain user that you indicated in Step 8.
  6. In the Permission Level column for that user, select the drop-down arrow, and then select Read/Write, and then select Share.
     Note: Users running the APM-CONTAINER service and the APM Server must have Read/Write access to this folder.
• Grant Read/Write Access to the APMConnect folder:
  1. Navigate to the APMConnect folder.
     If you installed APM Connect in the default location the folder is C:/APMConnect.
  2. Right-click on the folder APMConnect, and then select Properties.
  3. In the APMConnet Properties window, select the Security tab, and then select Edit.
  4. In the Permissions for APMConnect window, select Add....
     The appears.
  5. In the Select Users, Computers, Service Accounts, or Groups window, in the Enter the object names to select(examples): box, enter the name of the APM Connect user that you indicated in Step 8, and then selectCheck Names.
     The APMConnect user's name is validated.
  6. Select OK.
     The APM Connect user is populated in the Group or user names box.
  7. Select the APM Connect user.
  8. In the Permissions for <Username> box, on the Full Control row, select Allow, and then select Ok.
  9. In the APMConnect Properties window, select OK.

1. On your GE Digital APM Server, navigate to the folder where the localized workbooks are stored. If you had installed GE Digital APM in the default location, navigate to C:\Program Files\Meridium\Templates\DataLoaders.

   The DataLoaders folder appears.

2. Select the folder containing the workbook in the language you want according to the following table:

   Folder	Language
   de	German
   Default	English
   es	Spanish
   fr	French
   it	Italian
   ja	Japanese
   nl	Dutch
   pl	Polish
   pt-BR	Portuguese (Brazilian)
   ru	Russian
   zh-CHS	Chinese (Simplified)

This topic describes how to access and configure parameters in the context file.

1. Access the APM Connect installation package, and then copy the file RunDataLoaderRoute.cfg.
2. Navigate to <root>\APMConnect\Utilities\runtime\etc, and then paste the copied file in that location.
3. Open the file to edit, and then configure the following parameters:

   Parameter	Description	Default or Recommended Value
   context	Defines what Talend context environment is used.	Default.
   TRUSTSTORE_FILE	The directory path to the dinoloader SSL configuration file.	Value is unique to the user.
   TRUSTSTORE_PASSWORD	The password for the keystore files.	Value is unique to the user.
   USE_SSL	Determines if SSL is used.	true: will use SSL. false: will not use SSL.
   IR_HOST	Intermediary Repository host name.	Value is unique to the user.
   IR_DATABASE	Database for the dinoloader job.	Value is unique to the user.
   IR_USERID	Intermediary Repository username.	Value is unique to the user.
   IR_PASSWORD	Intermediary Repository password.	Value is unique to the user.
   IR_SCHEMA	The schema in which the IR database will be created.	The default value is public.
   IR_PORT	Intermediate Repository port.	Default value is 5432.
   LOG4J_CONFIG_FILE	Log4j directory path.	C:/APMConnect/Config/log4j.properties
   IS_LINUX	Indicates if the machine on which the Data Loaders are deployed is a POSIX-compliant operating system (for example, Linux, UNIX, AIX, HPUX etc.) or another operating system.	true: Enter true if you are deploying the Data Loaders on a POSIX-compliant operating system. false: Enter false if you are not deploying the Data Loaders on a POSIX-compliant operating system.
   LINUX_BASE_PATH	The directory path where the data loader file share is mounted.	This parameter is required only if you are deploying the Data Loaders on a Linux machine. This path is defined by system administrator for the Linux machine, and the value is unique to the user.
   ROW_LEVEL_LOGGING	Used for debugging, specifies whether or not data rows are written to the log.	The default is false. true: Writes data rows to the log. false: Suppresses data rows from the log.
   org.apache.karaf.features.configKey	Karaf web console configuration tie-in is used to associate this configuration file with the RunDataLoaderRoute class.	RunDataLoaderRoute.talendcontext.Default Important: Do not modify this parameter.

4. Save the file.
5. In the installation package, copy the file RunDataloaderRoute.kar.
6. On your APM Connect server, navigate to <root>\APMConnect\Utilities\runtime\deploy, and then paste the copied file in that location.
   Note: If new configuration is not automatically applied, restart the APM_CONTAINER service. This will force the changes to be applied.

The APM_UPDATE_LOGIC webservice manages the temporary tables GE Digital APM uses to load the database. Correct configuration is required for the system to operate correctly.

1. Access the APM Connect installation package, and then copy the file APM_UPDATE_LOGIC.cfg.
2. Navigate to <root>\APMConnect\Utilities\runtime\etc, and then paste the copied file in that location.
3. Open the file to edit, and then configure the following parameters:

   Parameter	Description	Default or Recommended Value
   context	Defines what Talend context environment is used.	Default. Do not change.
   CONFIG_FILE_PATH	The directory path to the context file used for extractions.	C:/APMConnect/Config/ContextFile.xml
   LOG4J_CONFIG_FILE	The directory path to the log4j.properties file used for extractions.	C:/APMConnect/Config/log4j.properties
   SAP_CLOUD_ENABLED	Specifies whether the installation is in the cloud or on premises.	true: the installation is in the cloud. false: the installation is on premises.

   Note: All file paths must use / in this configuration as a directory separator or errors will occur.
4. Save the file.
5. In the installation package, copy the file APM_UPDATE_LOGIC.jar.
6. On your APM Connect server, navigate to <root>\APMConnect\Utilities\runtime\deploy, and then paste the copied file in that location.
   Note: If new configuration is not automatically applied, restart the APM_CONTAINER service. This will force the changes to be applied.

This topic describes how to set up a repository in preparation to run your first job.

1. Log in to the APM Connect Administration Center web application.
   Note: The user logging in must have access to the Job Conductor by being designated the Operations Manager role. By default, users designated as administrators do not have Job Conductor permissions.
2. In the Job Conductor workspace, in the appropriate project, select the CreateIntermediateRepository job.
3. Select Context parameters.

   The Context parameters section appears.

4. Configure the following parameter.

   Context Parameter	Description
   CONFIG_FILE_PATH	The file path to context files for the jobs. Important: You must change the default value to reflect the actual path to your configuration file. CMMS_ID and SOURCE_SYSTEM_TYPE must be set in the context file.

5. Select Run.
   If you are configuring a single system, you have completed your configuration.
   The intermediate repository database is created for the project.

If you are configuring multiple EAM systems, perform the remaining steps in this topic.

6. In the Job Conductor workspace, in the appropriate project, select the addSourceSystem job.
7. Configure the following parameter.

   Context Parameter	Description
   CONFIG_FILE_PATH	The file path to context files for the jobs. Important: You must change the default value to reflect the actual path to your configuration file. CMMS_ID and SOURCE_SYSTEM_TYPE must be set in the context file.

8. Select Run.
9. Repeat steps 6 through 8 for all adapters.