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:
- 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.
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.