This documentation supports the 20.08 version of BMC CMDB, which is available only to BMC Helix subscribers (SaaS).

To view an earlier version, select the version from the Product version menu.

Editing Atrium Integrator transformation properties

Transformation settings are the collection of properties that describe the transformation and configure its behavior.

To edit transformation properties

  1. In the Atrium Integrator Spoon window, open the transformation that you want to edit.
  2. Select Edit > Settings.
    The Transformation properties window appears. 
    Transformation properties window in Atrium Integrator Spoon 
  3. In the Transformation tab, edit the Transformation nameTransformation filenameDescription, and Extended description as required.
  4. Specify the StatusVersion, and Directory of the transformation.
    The Created by and Created at fields display the user name of the person who created the transformation in the Integration Builder wizard and the date and time at which it was created.
    The Last modified by and Last modified at fields display the user name of the person who is editing the transformation and the date and time it was last modified.
  5. Click the Logging tab.


    The Performance and Logging channels options on the left panel are not supported.

  6. To view the logging options for the transformation, click Transformation on the left panel:
    • The Log Connection field displays the host name of the Remedy Action Request System database.
    • The Log table name field displays the name of the table (UDM:TransformationLog) in which the logs are stored.
    • The Fields to log area displays the list of fields for which you can enable logging.
    • In the Step name field, select the step
    • In the Line input field select the source step.
    • In the Line updateLine returnLine read, and Line output field, select the output step name.
    • In the Line rejected field select the error logging step name.
  7. To view the logging options for the steps, click Step on the left panel.
    • The Log Connection field displays the host name of the Remedy Action Request System database.
    • The Log table name field displays the name of the table (UDM:StepLog) in which the logs are stored.
    • The Fields to log area displays the list of fields for which you can enable logging
  8. In the Transformation Properties window, click the Dates tab.
  9. Specify the date setting.
  10. Click the Dependencies tab.
  11. Enter the dependencies for the transformation.
    For example, if a transformation depends on three lookup tables, ensure that the lookup tables have not changed. If the values in these lookup tables have changed, extend the date range to force a full refresh of the transformation. Dependencies allow you to determine if a table has changed when you have a "data last changed" column in the table. Click Get dependencies to detect dependencies automatically.
  12. Click the Miscellaneous tab.
  13. In the Number of rows in rowsets field, change the size of the buffers between the connected steps in a transformation.
    Do not change this parameter unless you are running low on memory, for example.
  14. If you want to add a feedback entry into the log file while the transformation is running, select the Show a feedback row in transformation steps check box.
    By default, this feature is enabled and configured to display a feedback record every 5000 rows.
  15. In the Feedback size field, enter the number of rows to process before entering a feedback entry into the log.


    Set this to a higher value when processing large amounts of data to reduce the amount of information in the log file.

  16. If you want to open one unique connection per defined and used database connection in the transformation, select the Make the transformation database transactional check box.
    Enabling this option is required to allow a failing transformation to be rolled back completely. Enabling this option is also necessary when trying to alter connection settings before a query using an Execute SQL script step.
  17. In the Shared objects field, specify the location of the XML file used to store shared objects like database connections or clustering schemas.
  18. If you want to enable the internal logic for changing the Java thread priorities based on the number of input and output rows in the rowset buffers, select the Manage thread priorities check box.
    This can be useful in some situations where the cost of using the logic exceeds the benefit of the thread prioritization.
  19. Click the Partitioning tab. The available database partitions are displayed.
  20. To create a new partition, click the New button.
  21. Click the Monitoring tab.
  22. If you want to monitor each step of the transformation as it is running, select the Enable step performance monitoring check box.
  23. To generate the SQL code necessary for creating the logging table, click the SQL button.
    The Simple SQL Editor appears, which allows you to execute an SQL statement against the logging connection.
  24. Click OK.
    The selected transformation is updated according to the options that you set.
Was this page helpful? Yes No Submitting... Thank you