Data Extraction Jobs

Data Extraction Jobs

Data extractions, also referred to as jobs, are orchestrated through the different adapters. Depending on the type of data (i.e., Equipment, Functional Location, Work History) you want to extract, there is a corresponding job. SAP extractions are facilitated by the APM Connect Administration Center and a corresponding context file. The context file contains filter parameters that are applied to each extraction adapter Job. The filter parameters define the scope of the data extraction.

More Details

The following SAP and SAP PI adapters are available for data extractions:

  • Static Data Adapter: Extracts Master data from the source system code descriptions so that they can be used within transformations. ASI Static Data Adapter is a specialized adapter in which the data is sent to APM for internal reference in ASI workflows.
  • Equipment Adapter: Extracts records that are used to store information about physical pieces of equipment, such as pumps, motors, and compressors.
  • Functional Location Adapter: Extracts records that are used to store information about locations in your organization including, but not limited to, the locations at which the physical pieces of equipment are installed.
  • Work History Adapter: Extracts records that are used to store data about work that was performed against your locations and equipment, as well as failures that occurred for those locations and equipment. Additionally, it allows you to transfer Notifications and Orders from SAP to APM.
  • Notification Management Adapter: Allows you to transfer Recommendation records from APM to SAP in the form of Notifications.
  • Technical Characteristics Adapter: Allows you to transfer Functional Location characteristics and Equipment characteristics from SAP to APM.

  • Work Management Adapter: Allows you to manage scheduled work in SAP and APM.

  • PWORK Adapter: The Planned Work Adapter job allows you to retrieve information about the work planned for your assets.
  • EAM Extractions should be filtered such that the load does not exceed 10 MB or more than 10,000 records in a single load. Proper batching should be applied in all cases.

About Time Zone Data

APM stores the dates and times of transactions in Universal Coordinated Time (UTC) format. This enables the data to flow through the system in a single time zone format. APM Connect supports the time zones defined in https://docs.microsoft.com/en-us/previous-versions/windows/embedded/gg154758(v=winembedded.80).

To provide information with the time stamp relevant to your operations, the system converts UTC to your time zone by using the time zone information configured in your user definition.

Important: If you change the time zone information configured in your user definition, all the records will reflect the new time zone.

The following sections contain the time zone considerations relevant to specific systems.

Maximo

APM stores the time stamp associated with the data extracted from Maximo in UTC and displays the time stamp based on your configured time zone.

SAP

SAP provides a set of baseline time zone codes, which contain most of the standard time zones across the world. SAP also provides the ability for administrators to define their own custom time zone, as needed. Before you use a customized time zone, you must configure the timezone_control table in APM Connect to include the customized time zone.

SAP defines two types of time zones:

  • System: This time zone is based on SAP Application Server Operating System and is derived from the context file. You cannot modify this type of time zone.
  • User: This time zone is based on the user who created the SAP record. You can modify and store this type of time zone in the SAP user interface.

APM stores the time stamp associated with the data extracted from SAP in UTC and displays the time stamp based on the time zone configured for the user who created the SAP record.

Note: If the data extracted from SAP contains only the date, then APM will assign the time 00:00:00 and adjust the assigned time with the SAP system or user time zone. This may lead to a date mismatch when you choose to display the data in APM. To prevent this, APM stores the assigned reference time stamp as a string within the data, which is hidden by default. If you need this information, you can configure APM to display the data.

Update Existing Jobs

Occasionally, changes will be made to the .zip files associated with an adapter Job. When changes are made to the adapter through a .zip file, the existing Job must be updated by reimporting the .zip file. This topic describes how to update an existing Job.

Procedure

  1. In the Job Conductor workspace, select the Job for which the file has been updated.
  2. On the Job Conductor toolbar, select Delete.
    Note: If you do not delete the existing Job, the Job will not update properly, and the Job cannot be executed.
  3. On the Job Conductor toolbar, select Add.

    The Execution task pane is activated.

  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 to navigate to the file containing the adapter Jobs that have been updated.
  9. Select the appropriate file.
  10. On the Import generated code window, select Launch upload.
  11. The Project, Branch, Name, Version, and Context text boxes are automatically populated with appropriate values.
  12. In the Execution Server list, select the server on which the Job should be executed.
  13. Select Save.

    The updated adapter Jobs are imported into the APM Connect Administration Center.