Managing Configuration Items › Manage Staged Transactions › Populating the TWA › How to Load Data into the TWA Using GRLoader

How to Load Data into the TWA Using GRLoader

The following GRLoader options support the uses of the TWA:

-lttwa

Loads XML data to TWA in initial state.

-lttwar

Loads XML data to TWA in ready state.

-lftwa

Loads transactions to the CMDB from TWA.

-lftwai

Loads transactions to the CMDB from TWA and inactivates successful transactions.

GRLoader input XML documents can be loaded into the CMDB or the TWA without modification.

Loading data into the transaction work area can be accomplished by using GRLoader with the –lttwa (load to TWA) option. In the GRLoader configuration file:

grloader.loadtotwa=yes

In TWA mode, instead of creating CIs and relationships directly, GRLoader inserts the information into the transaction work area tables. Data that has been loaded into the TWA can be edited, changed and verified. After the data modification process is complete, individual transactions can be loaded into the CMDB by using –lftwa or -lftwai.

When loading CI data into the CMDB, CIs undergo automatic reconciliation, which, if successful results in data from a single business object updating a single CI in the CMDB. When loading CI transactions into the TWA, no automatic reconciliation occurs. Multiple transactions with identifying attributes targeting a single CI can appear in the TWA. Existing rows in the TWA are not updated when new rows are added in load to TWA mode, even if they are an identical match to an existing CI. Even identical CI definitions can appear many times in the TWA.

GRLoader validates data values when running in load from TWA mode (-lftwa or -lftwai) to create objects in the CMDB or when running using the simulation mode (-simci or –simrel), see How to Simulate TWA Operations for more details. The data values are not validated when GRLoader is run in load to TWA (-lttwa or -lttwar) mode.

The -lttwai parameter (or configuration option grloader.loadtotwa.inactivate) inactivates successfully loaded TWA transactions. After a successfully loaded transaction has been marked inactive, it can be permanently purged from the TWA by using Archive/Purge.

Example: Load to CMDB

The following command loads data directly into the CMDB:

grloader … -i mydata.xml -a -n

The XML file mydata.xml contains:

<GRLoader>
  <ci>
     <name>server1</name>
     <class>Server</name>
   </ci>
</GRLoader>

Example: Load to TWA

The following command loads the data into the TWA, so that it can be manipulated before loading into the CMDB:

grloader … -i mydata.xml -lttwa

More information:

XML Input

lookup

Date Format

EMPTY