Right-click the new job, and in the JobВ tab, provide the following information: In the Atrium Integrator Spoon client, select File > New > Job.Log in to BMC Remedy AR System serverВ as anВ AR administrator.You can create multiple transformations in a single job for different Foundation data types, for example, a single Pentaho job that contains a transformation each for extended Person data, extended Organization data, and extended Site data. Task 2: To create a Pentaho job inВ Remedy ITSMД¬reate a custom Pentaho job in Remedy ITSM, so that your custom Foundation data is loaded toВ BMC Helix Platform.For example, create a Pentaho job Initial Sync - Person Additional DetailsВ for loading custom Foundation data for employee, such as Passport InformationВ and SSN. The following image shows an example of custom fieldsВ that are added to CTM: PeopleВ form: Add the custom fields to suit your business needs.ДЇor example, Passport NumberВ and SSNВ fields.Log in toВ BMC Remedy IT Service Management console as anВ ITSM administrator.Add the custom fields to CTM:PeopleВ form, so that these fields are loaded from Remedy ITSM, and displayed as part of the out-of-the-box Foundation record. For example, custom fields for Sites, People, Company, Support group, and category Foundation data. Identify the custom fields that you want to import inВ BMC Helix PlatformВ from Remedy ITSMВ Foundation data. Task 1: To modifyВ CTM:People form to include custom fields Ensure that you have extended the Foundation definitions inВ BMC Helix PlatformВ to include the custom Foundation fields.Ensure that you have Identifying fields added to view overlays that you want to load.When you run the Pentaho job Initial Sync - Person Additional Details, the Passport NumberВ and SSNВ fields are loaded from Remedy ITSM. PersonВ Additional Details toВ define the sequence of data load.PersonВ Additional Details - Header to define the header of Excel spreadsheet.For example, to define the custom Foundation data, you can create a Pentaho job Initial Sync - Person Additional DetailsВ and the following transformations: In such case, you must specify the custom Foundation data in Remedy ITSMВ so that the custom data is identified and loaded toВ BMC Helix Platform. To meet your business requirements, you want to provide additional details like Passport NumberВ and SSNВ for all Employees in your organization. For a complete list of compatible Remedy ITSM versions, see Foundation data load compatibility information. ERROR (version 7.0.0.0-25, build 1 from 2016-11- 05 15.35.36 by buildguy) : Problem while sending message: ception: Could not convert socket to TLS Дў 14:24:46 - success - nested exception is:Дў 14:24:46 - success - : No appropriate protocol (protocol is disabled or cipher suites are inappropriate)Дў 14:24:46 - database_alert - Finished job entry (result=)Дў 14:24:46 - database_alert - Job execution finishedДў 14:24:46 - Kitchen - ERROR (version 7.0.0.0-25, build 1 from 2016-11- 05 15.35.36 by buildguy) : Finished with errorsДў 14:24:46 - Kitchen - Start=2 14:22:02.312, Stop=2 1 4:24:46.You can load Foundation data fromВ Remedy ITSM version 9.1 SP3В or later. The issue is that I cannot get it working. At the end of the job, I am supposed to run the success / failure email. I am to run Pentaho on Digital ocean ubuntu.

Pentaho data integration generate rows