This topic describes how to access and configure parameters in these context files.
Before you can run a job in the APM Connect Administration Center, you must specify a set of connection parameters and corresponding values to establish a connection between APM Connect components, GE Digital APM, and your EAM system. Each of these connections is used when running a job, and it is required. The connections are established via context files.
Tip: The SAP Adapters support connections between multiple SAP systems and multiple GE Digital APM databases by using one context file for each SAP system or GE Digital APM database.
Steps
On the APM Connect server, access your context file. If you installed it in the default location, navigate to the following folder: C:\APMConnect\Config
IMPORTANT: Changes made to the context file will override changes made in the Context parameters section of APM Connect Administration Center.
To configure the context file, enter the appropriate values for each parameter into the context file according to the following table.
Parameters | Description | Default or Recommended Value |
---|---|---|
Interface Mode Selection | ||
SAP_CLOUD_ENABLED | Determines whether the Adapter will be used in a cloud environment. | You must enter one of the following values:
|
LOAD_MERIDIUM_APM | Determines whether the data will be loaded into the Meridium database. | You must enter one of the following values:
|
LOAD_DIGITAL_APM
| Determines whether the data will be loaded into the Predix database. | You must enter one of the following values:
|
CMMS_ID | The CMMS ID is used as the identifier for your SAP system, and is <SAP System ID>-<SAP Client ID>. For example, if your SAP System ID is D03 and your SAP Client ID is 001, then your CMMS ID would be DO3-001. | This value is required. Enter a unique value. |
SOURCE_SYSTEM_TYPE | Identifies the type of system connecting with GE Digital APM. | This value is required. You must enter the one of the following values:
|
Intermediate Repository (IR) Connection | ||
IR_HOST | The IP address of the IR. | Enter the host name of the PostgresSQL server. If you installed APM Connect using the default settings, then the value is localhost. |
IR_PORT | The port number of the IR. | Enter your PostgreSQL port. The default value is 5432. |
IR_DATABASE | The database in which the IR data is stored. | Enter a name for the IR database. This value will be used to create the IR database. |
IR_SCHEMA | The schema in which the IR database will be created. | The default value is public. |
IR_USERID | The IR user name. | Enter the user name for the PostgresSQL database. The default user name is postgres. |
IR_PASSWORD | The IR system password. | Enter the password for the PostgresSQL database that was created during installation. |
SAP Connection | ||
SAP_CLIENT | The SAP client from where the data is imported. | Enter a unique value. |
SAP_HOST | The IP address or the host name of the SAP application server. | Enter a unique value. |
SAP_LANGUAGE | The language in which the SAP system sends messages to APM Connect. | The default value is EN. |
SAP_SYSTEM_NUMBER | The instance number of the SAP application server. | Enter a unique value. |
SAP_USERID | The SAP system user ID. | Enter a unique value. |
SAP_PASSWORD | The SAP system password. | Enter a unique value. |
SAP_SYSTEM_TIMEZONE | The SAP Application Server Operating System time zone. | The default value is EST. |
SAP_FILE_ENCODING | Determines the encoding of the source data. | The default value is UTF8. All the character encoding supported by the Java Virtual Machine (JVM) are correct. |
EXTRACT_NUM_PARALLEL_JOBS | Determines the maximum number of SAP background jobs allowed during extraction. | The recommended value is 10. |
IR_LOAD_NUM_PARALLEL_JOBS | Determines the maximum number of SAP background jobs allowed during loading. | The recommended value is 10. |
LOG_REQUEST | Logs the APM web service requests. | You must enter one of the following values:
|
LOG_RESPONSE | Logs the APM web service responses. | You must enter one of the following values:
|
File System | ||
PLSAP_INPUT | The path of the directory you created, which SAP uses to place data files used by APM Connect. | Enter a unique value. |
PLSAP_OUTPUT | The path of the directory used by APM Connect to search for the files created by SAP. This directory should be shared with the SAP server. | Enter a unique value. |
IR_TALEND_OUTPUT | The temporary workspace used when moving files from SAP to APM Connect. | Enter a unique directory path. |
LOG_BASE_DIR | The directory path to the log file. | C:\APMConnect\Logs |
SFTP_STAGING_DIR | The temporary storage location for files that are waiting to be loaded. | Enter a unique value (for example, C:\APMConnect\Staging). |
UNC_FILE_PATH | The path of the directory of the data loader file share. | Enter a unique value. |
APM Connect | ||
APM_CONNECT_HOST | The host name of the machine where APM Connect Administration Center is installed. | Enter a unique value. |
APM_CONNECT_PORT | The port name of the machine where APM Connect Administration Center is installed. | Enter a unique value. |
APM Connection | ||
Note: The APM Connection Parameters are not required for cloud deployment. | ||
APM_API_APP_SERVER | The GE Digital APM API application server name. | Enter the name of your GE Digital APM API server. |
APM_API_USE_SSL | Specifies whether the GE Digital APM API application uses SSL. | The valid values are:
The default value is false. |
APM_APP_SERVER | The GE Digital APM application server name. | Enter the name of your GE Digital APM server. |
APM_DATASOURCE | The GE Digital APM data source to which the data will be exported. | Enter the name of your GE Digital APM data source. |
APM_USERID | The GE Digital APM Framework user ID. | Enter a unique value. |
APM_PASSWORD | The GE Digital APM Framework password. | Enter a unique value. |
Miscellaneous | ||
MANUAL_RUN | Determines how the date parameters will be treated. | You must enter one of the following values:
|
MULTI_OBJECTS_ENABLED | Determines if different types of objects that are logically related to each other can be classified into a single class type. For example, you can use class type 023 to classify both materials and batches. | You must enter one of the following values:
|
TECHNICAL_CHARACTERISTICS_ENABLED | Determines if the technical characteristics of Equipment or Functional Location will be extracted. | You must enter one of the following values:
|
Filter | ||
MAINT_PLANT | The ID(s) of the Maintenance Plant whose data you want to extract. | Plant values cannot exceed four characters. |
LANGUAGE | The SAP code that represents the language of the description to transfer data into GE Digital APM. | The value must be a single character. |
CREATE_DATE_START | The date value that limits the data extracted to records created on or after the specified date. | Date must be entered in the following format: YYYYMMDD. |
CREATE_DATE_END | The date value that limits the data extracted to records created on or before the specified date. | Date must be entered in the following format: YYYYMMDD. |
CHANGE_DATE_START | The date value that limits the data extracted to records changed on or after the specified date. | Date must be entered in the following format: YYYYMMDD. |
CHANGE_DATE_END | The date value that limits the data extracted to records changed on or before the specified date. | Date must be entered in the following format: YYYYMMDD. |
Equipment Filter Criteria | ||
EQUIPMENT_NO | The number that identifies the Equipment record that you want to extract. | Equipment number should not exceed 18 characters. You cannot exceed 500 Equipment numbers. For multiple Equipment records, separate the numbers using commas. |
EQUIPMENT_CATEGORY | The ID of the Equipment category that limits the Equipments extracted. | Equipment category ID must be a single character. For multiple Equipment categories, separate the IDs using commas. |
EQUIPMENT_TYPE | The ID of the Equipment type that limits the Equipments extracted. | Equipment type ID should not exceed 10 characters. For multiple Equipment types, separate the IDs using commas. |
EQUIPMENT_CLASS | The ID of the Equipment classification that limits the Equipments extracted. | Equipment classification ID should not exceed 18 characters. If an Equipment has multiple classifications, as long as you specify one of those classifications, the Equipment record will be extracted. For multiple Equipment classifications, separate the IDs using commas. |
Functional Location Filter Criteria | ||
FLOC_NO | The ID of the Functional Location that limits the Functional Locations extracted. | Functional Location ID should not exceed 40 characters. You cannot exceed 500 Functional Location numbers. For multiple Functional Locations, separate the IDs using commas. |
FLOC_TYPE | The ID of the Functional Location type that limits the Functional Locations extracted. | Functional Location type ID should not exceed 10 characters. For multiple Functional Location types, separate the IDs using commas. |
FLOC_CLASS | The ID of the Functional Location classification that limits the Functional Locations extracted. | Functional Location classification ID should not exceed 18 characters. For multiple Functional Location classifications, separate the IDs using commas. |
FLOC_CATEGORY | The ID of the Functional Location category that limits the Functional Locations extracted. | Functional Location category ID must be a single character. For multiple Functional Location categories, separate the IDs using commas. |
Work History Filter Criteria | ||
NOTIFICATION_NO | The number that identifies the Notification record that you want to extract. | Notification number should not exceed 12 characters. For multiple Notification records, separate the numbers using commas. |
WORK_ORDER_NO | The number that identifies the Work Order record that you want to extract. | Work Order number should not exceed 12 characters. For multiple Work Order records, separate the numbers using commas. |
NOTIFICATION_TYPE | The Notification type that limits the Work Orders that you want to extract. | Notification type should not exceed two characters. For multiple Notification types, separate the Notification types using commas. |
WORK_ORDER_TYPE | The ID of the Work Order type that limits the Work Orders that you want to extract. | Work Order type ID should not exceed four characters. For multiple Work Order types, separate the IDs using commas. |
WORK_ORDER_SYSTEM_STATUS | The Work Order systems status that limits the Work Orders that you want to extract. | Work Order system status should not exceed four characters. |
WORK_ORDER_USER_STATUS | The Work Order user status that limits the Work Orders that you want to extract. | Work Order user status should not exceed four characters. |
NOTIFICATION_SYSTEM_STATUS | The Notification system status that limits the notifications that you want to extract. | Notification system status should not exceed four characters. |
NOTIFICATION_USER_STATUS | Notification user status that limits the notifications that you want to extract. | Notification user status should not exceed four characters. |
CREATE_TIME_START | The time value that limits the data extracted to records created on or after the specified time. | Time must be in the following format: HHMMSS. |
CREATE_TIME_END | The time value that limits the data extracted to records created on or before the specified time. | Time must be in the following format: HHMMSS. |
CHANGE_TIME_START | The time value that limits the data extracted to records changed on or after the specified time. | Time must be in the following format: HHMMSS. |
CHANGE_TIME_END | The time value that limits the data extracted to records changed on or before the specified time. | Time must be in the following format: HHMMSS. |
Work Management | ||
MAINTENANCE_PLAN | The number that identifies the maintenance plan record. | The maintenance plan number must not exceed 12 characters and it should be zero padded. Example: 000000000012. For multiple maintenance plan records, separate the numbers using commas. |
INSPECTION_FAMILY | Determines the family to which the Inspection records are associated. | To use the default association, enter the value MI_TASKINSP. |
INSPECTION_CONDITION | Determines the SAP control key used to identify trigger values for Inspection records. | The parameter requires the following specific syntax: <SAP Table>-<SAP Field> EQ '<Key Value 1>,<Key Value 2>,<Key Value 3>, etc.' To use the default configuration, enter the following value: PLPO-STEUS EQ 'ZMI1' |
CALIBRATION_FAMILY | Determines the family to which the Calibration records are associated. | To use the default configuration, enter the value MI_TASKCALB. |
CALIBRATION_CONDITION | Determines the SAP control key used to identify trigger values for Calibration records. | The parameter requires the following specific syntax: <SAP Table>-<SAP Field> EQ '<Key Value 1>,<Key Value 2>,<Key Value 3>, etc.' To use the default configuration, enter the following value: PLPO-STEUS EQ 'ZMI2' |
Queue | ||
Note: The Queue parameters apply only to cloud deployment. | ||
QUEUE_HOST | The queue host name. | Enter a unique value, which was provided during installation. |
QUEUE_HOST_1 | An additional queue host name. | Enter a unique value, which was provided during installation. |
QUEUE_HOST_2 | An additional queue host name. | Enter a unique value, which was provided during installation. |
QUEUE_PORT | The queue port. | Enter a unique value, which was provided during installation. |
QUEUE_PORT_1 | An additional queue port. | Enter a unique value, which was provided during installation. |
QUEUE_PORT_2 | An additional queue port. | Enter a unique value, which was provided during installation. |
QUEUE_USER | The queue user name. | Enter a unique value, which was provided during installation. |
QUEUE_PASSWORD | The queue password. | Enter a unique value, which was provided during installation. |
CUSTOMER_NAME | The coded customer name. | Enter a unique value, which was provided during installation. |
USE_SSL | Provides for encryption and authentication of the data and its transmission to the server. | Enter a unique value. |
TRUSTSTORE_FILE | Location of the file with all the necessary keys and certificates for data transfer to the server using the active message queue. | Enter a unique value. |
TRUSTSTORE_PASSWORD | Password of the trust store for APM Connect to retrieve the keys. | Enter a unique value. |
SFTP | ||
SFTP Connection is supported only for the SAP Adapters, and configuration is required only if you are using SFTP to transfer information between your systems. IMPORTANT: If you are using an SAP System with the SAPFTP_SERVERS table, you must configure that table to activate SFTP servers according to the SAP Help system. You can refer to SAP OSS 1605054 for more details. Typically, this will apply to any SAP version later than ECC6 EHP5. | ||
PLSAP_FTP_HOST | The SFTP server host name. | Enter a unique value. |
PLSAP_FTP_USERID | The SFTP server user name. | Enter a unique value. |
PLSAP_FTP_PASSWORD | The SFTP server password. | Enter a unique value. |
PLSAP_FTP_PORT | The SFTP server port. | If the default configuration was followed, enter one of the following values:
|
PLSAP_FTP_MODE | The mode by which files are copied. | Enter one of the following values:
|
PLSAP_FTP_SCAN_DIR | The remote SFTP directory used to scan for files. | Enter a unique value. |
PLSAP_FTP_NUM_OF_RETRY | The number of times to scan the SFTP server for files. | 10 |
PLSAP_FTP_SLEEP_TIME | The time in seconds between scans. | 10 |
PLSAP_SFTP_SCP_COMMAND | The command name created when establishing the SFTP transfer in SAP. | Enter a unique value. |
SFTP | ||
Note: The SFTP parameters apply only to cloud deployment. | ||
SFTP_HOST | The SFTP server host name. | Enter a unique value, which was provided during installation. |
SFTP_USERID | The SFTP server user name. | Enter a unique value, which was provided during installation. |
SFTP_PASSWORD | The SFTP server password. | Enter a unique value, which was provided during installation. |
SFTP_PORT | The SFTP server port. | Enter a unique value, which was provided during installation. |
SFTP_LANDING_DIR | The directory path where the shared files are stored. | Enter a unique value, which was provided during installation. |
USE_SSH_KEY | Determines if SSH security configuration will be used by the adapters. | You must enter one of the following values:
|
SSH_PRIVATE_KEY | The directory where the SSH key is stored. | Enter a unique value. The SSH key must be generated by the user in the openSSH format. This key can be stored in any directory on the APM Connect server, but it is recommended to store it in the following directory: C:\APMConnect\Config |
Email Notification | ||
Note: The Email Notification parameters apply only to cloud deployment. | ||
EMAIL_FROM | The email address from which the notification email will be sent. | Enter a unique value. |
EMAIL_TO | The email address(es) to which the email will be sent. | Enter a unique value. |
FAILURE_DETAIL_REPORT_ENABLED | Indicates whether the failure detail report will be sent when a record fails to load. | You must enter one of the following values:
|
FAILURE_DETAIL_REPORT_JRXML_FILE_PATH | Directory where the JasperReport file to generate the failure detail report in PDF will be delivered. | Enter a unique value. |
LOAD_SUMMARY_REPORT_ENABLED | Indicates whether the load complete report will be loaded with each extraction. | You must enter one of the following values:
|
LOAD_SUMMARY_REPORT_JRXML_FILE_PATH | Directory where the JasperReport file to generate the summary detail report in PDF will be delivered. | Enter a unique value. |
REPORT_TARGET_DIR | Directory where the report file will be delivered. | Enter a unique value. |
SMTP_HOST | The host for SMTP installation the APM Connect server. | Enter a unique value. |
SMTP_PORT | The port for SMTP. | The default value is 25. |
Guardrail | ||
EQUIPMENT_THRESHOLD | The maximum number of records that should be transferred from SAP to GE Digital APM in a single run of the Equipment Adapter. | The default value is 100000. |
FLOC_THRESHOLD | The maximum number of records that should be transferred from SAP to GE Digital APM in a single run of the Function Location Adapter. | The default value is 100000. |
WORKHISTORY_THRESHOLD | The maximum number of records that should be transferred from SAP to GE Digital APM in a single run of the Work History Adapter. | The default value is 50000. |
OVERRIDE_GUARDRAILS | Indicates whether the job will continue if the number of records exceeds the defined threshold. | The default value is Y, which means that the job will run regardless of the number of records included. A warning notification will also be sent to the email address specified in the EMAIL_TO parameter within the Email Notification Parameters section of this file. If you set this parameter to N, the job will be terminated when the number of records exceeds the defined threshold, and an error notification will be sent. |
SAP PI | ||
Note: Enter the appropriate values for the following parameters into the context file only if you are deploying the SAP PI Adapters (in which case the parameter SAP_USE_PI should have the value true), which are the SAP Adapters for Process Integration. | ||
SAP_USE_PI | Determines whether the SAP PI connection will be used. | You must enter one of the following values:
|
SAP_SYSTEM_ID | The system IDs of the SAP systems from which you want to extract data. | Enter a unique value. |
SAP_PI_HOST | The SAP PI server host. | Enter a unique value. For example,
|
SAP_PI_PORT | The SAP PI server port. | Enter a unique value. |
SAP_PI_RECEIVER_PARTY | The receiver party configured in the SAP PI ID configurations. | This is optional and unique to the user. |
SAP_PI_RECEIVER_SERVICE | The receiver service configured in the SAP PI ID configurations. | This is optional and unique to the user. |
SAP_PI_SENDER_PARTY | The sender party configured in the SAP PI ID configurations. | This is optional and unique to the user. |
SAP_PI_SENDER_SERVICE | The sender service configured in the SAP PI ID configurations. | The default value is Meridium_APMConnect. The value must match the communication channel value in SAP. |
SAP_PI_USERID | The SAP PI user ID. | Enter a unique value. |
SAP_PI_PASSWORD | The SAP PI password. | Enter a unique value. |
COMPRESS_TYPE | Determines if the files will be compressed and the method of compression that is used. | You must enter one of the following values:
Note: If you do not compress files, large extractions will take a long time. |
COMPRESS_SAP_COMMAND_NAME | The value of the command name created. | You must enter one of the following values:
|
FILE_MOVE_USE_PI | Determines if APM Connect should use SAP-PI to extract and load data. | You must enter one of the following values:
|
MAX_FILE_WAIT_SEC | Defines how long the PI Adapters will wait for the extraction to complete before the job times out. | The recommended value is 1000. |
SAP_PI_AAE | If you are using SAP PI 7.3 or later, you may use the Advanced Adapter Engine (AAE). This parameter allows this functionality to be used during extraction. | You must enter one of the following values:
|
What's Next?
Copyright © 2018 General Electric Company. All rights reserved.