Deploy the Automatic Data Loader Job

Set up the Automatic Data Loader Job

Before You Begin

APM Connect must be installed on premises.

You must make sure port 443 is open for the job to use for file transfers in a cloud environment.

Procedure

  1. Access the APM Connect Administration Center.
  2. In the Menu pane, in the Conductor section, select Job Conductor.
  3. In the Job Conductor toolbar, select Add.

    The Execution task pane is enabled.

  4. In the Execution task pane, in the Label box, enter a label for the job.
  5. In the Description box, enter a description for the job.
  6. Select the Active check box.
  7. In the Job section, select .

    The Import generated code window appears.

  8. Select Browse..., and then navigate to the folder containing the updated jobs package.
  9. Select the job dinokeeper.zip, and then select Launch upload.

    The job is imported into the Job Conductor.

  10. Configure the context file to identify the location of the load directory, the archive directory, and the log file.
  11. Modify the <Context_File_PATH> value in the job conductor context parameters to point to the context file for the job.
  12. Run the job.

Results

The job conductor indicates that the job ran successfully, and the automatic data loader directories will be created if they do not already exist.

You can now place workbooks in the appropriate data loader directory.

Configure the Context File

Before You Begin

The context file provides the automatic data loader job with the information it needs to locate the directories and log the file it requires.

You should have imported the automatic data loader job.

Procedure

  1. Navigate to the following folder: C:\APMConnect\Config\<system>
  2. Modify the file ContextFile.xml to indicate the values for your system.
    ParameterDescriptionDefault or recommended value
    CONFIG_FILE_PATHThe path to the context file used for extraction.

    Enter your unique value (for example, C:\APMConnect\Config\ContextFile.xml).

    SCAN_DIRThe directory that contains the directories from which the job retrieves workbooks to load data.

    Enter your unique value (for example, C:\APMConnect\Dinokeeper).

    Important: Because this job runs with administrative authority, you must control user access to this directory.
    ARCHIVE_DIRThe directory that the facility uses to archive workbooks.

    Enter your unique value (for example, C:\APMConnect\Archives).

    LOG_BASE_DIRThe path that the facility uses to store the generated log files.

    Enter your unique value (for example, C:\APMConnect\Log).

    LOG4J_CONFIG_FILEThe path to the log4j configuration file.

    Enter your unique value (for example, C:\APMConnect\Config\log4j.properties).

    Note: This can be the same log4j configuration file that you use for your Adapters. If you want to use log4j settings that are different from the EAM job, then you must configure the context file with different log4j properties.
    FILE_RECEIVER_TIMEOUTThe amount of time, in seconds, before the receiver reports a timeout condition.

    This is an optional parameter. The default value is 1000ms.

    Enter your unique value.

    FILE_RECEIVER_HOSTThe host name of the cloud file receiver service.This is a required parameter. The value will be provided at the time of installation.

    SAP_CLOUD_ENABLED

    or

    MAXIMO_CLOUD_ENABLED

    		Determines whether the Adapter will be used in a cloud environment.

    This is a required parameter. You must enter one of the following values:

    • true: Adapters will be run in the cloud.
    • false: Adapters will be run on premises.
    CUSTOMER_NAME

    The coded customer name.

    		This is a required parameter. The value will be provided at the time of installation.

    APM_USERID

    		The Predix Essentials user ID.Enter your unique value.
    APM_PASSWORDThe Predix Essentials password.Enter your unique value.
    APM_DATASOURCEThe name of the Predix Essentials data source to which the data will be exported.

    This is a required parameter only for the on-premises implementation.

    Enter your unique value.

    APM_API_APP_SERVERThe name of the Predix Essentials server

    This is a required parameter only for the on-premises implementation.

    Enter your unique value.

    APM_API_USE_SSLUse Secured Socket layer to transfer data

    You must enter one of the following values:

    • true: To use SSL.
    • false: To not use SSL.
    Note: For cloud implementation, you must enter the value true.
    VALIDATE_SERVERValidate the server certificate
    You must enter one of the following values:
    • true: To validate server certificates
    • false: To not to validate the server certificates

    Default value is false.

    TRUSTSTORE_FILELocation of the truststore file with all the necessary keys and certificates, which are required for validating the serverEnter your unique value.
    TRUSTSTORE_PASSWORDPassword of the truststoreEnter your unique value.

Use the Automatic Data Loader

Use the Automatic Data Loader job to manually or programmatically load asset data to Predix Essentials.

About This Task

By default, the Automatic Data Loader job processes the files in the directories based on the alphanumeric directory name and then the time stamp of the files from oldest to most recent.

Procedure

  1. Identify the directory that corresponds to the data loader you are using.
  2. Move the data loader files (either a correctly formatted .xlsx or a .zip file that contains correctly formatted .csv files) into the identified directory.