Migrating data mappings to Atrium Integrator

Data mappings in BMC Atrium Integration Engine define how data in the source corresponds to data in the target and which actions to take when transferring the data.

Things to remember about migrating data mappings:

• BMC Atrium Integration Engine enables you to specify multiple data mappings for a data exchange. However, the AIE to AI Migration Tool migrates only the first main data mapping that is defined for a data exchange. You must migrate data mappings one at a time.
• The AIE to AI Migration Tool does not migrate the delete and response fields. It does not migrate queries that are set for data mappings.
• You can only map zero or one to a response field and not to any CMDB field. However, mapping of other CMDB fields as response is possible through BMC Atrium Integrator Spoon by modifying the UpdateResponse step.
• In BMC Atrium Integration Engine data exchange, if the data set ID is not mentioned at the main mapping level, the data set ID specified at the Data Field Mapping level is used. If the data set ID is not mentioned even at the Data Field Mapping level, BMC.SAMPLE is used as the data set ID.

Recommendation

Before you are migrate all your data exchanges from BMC Atrium Integration Engine to Atrium Integrator, BMC recommends to do a test migration.  After migrating rules to Atrium Integrator, verify if rules are migrated correctly.

Migrating data mappings 

The AIE to AI Migration Tool migrates a subset of the rules that can be defined for the data mappings in BMC Atrium Integration Engine. However, if in BMC Atrium Integration Engine the rule is disabled or if the syntax is wrong, then the AIE to AI Migration Tool does not migrate the associated attribute. 

The rules are migrated to Atrium Integrator as Java code. For example, if you have defined a rule that uses the timestamp() function, the AIE to AI Migration Tool creates the following Java code for that rule in Atrium Integrator:

public boolean processRow(StepMetaInterface smi, StepDataInterface sdi) throws KettleException{

Object[] r = getRow();
if (r == null) {
setOutputDone();
return false;
}
if (first){

first = false;
}r = createOutputRow(r, r.length+5);
String o = getData(r);
putRow(data.outputRowMeta, r);
return true;
}
private String getData(Object[] r) throws KettleException{
String rule1 = timestamp();
get(Fields.Out, "AssignedTo_100").setValue(r, rule1);
return null;
}
private static String concat(String[] strArray){
String str = "";
for(int i=0; i<strArray.length; i++){
str = str + strArray[i];
}return str;
}

For more information about the rule and function syntax in BMC Atrium Integration Engine and the corresponding Java code in Atrium Integrator, see Mapping BMC Atrium Integration Engine rules and function syntax with corresponding Java output in Atrium Integrator in the topic Mapping BMC Atrium Integration Engine and Atrium Integrator terminology.

Example of migrating data mappings

The following example shows the process to migrate to Atrium Integrator, a sample ITSM BusinessService data exchange and the associated data mappings. 
The start and end points of the migration process are as shown in the following figure. 

Sample migration of data exchanges to Atrium Integrator

To migrate sample ITSM BusinessService data exchange and the associated data mappings to Atrium Integrator

Perform the following steps to migrate a sample data exchange and associated data mappings to Atrium Integrator:

1. On the BMC Atrium Integration Engine server, verify if the Sample ITSM BusinessService data exchange and the associated data mappings are fit for migration and make the necessary changes if required. For more information data exchanges and data mappings that are migrated to Atrium Integrator see,
   Data exchanges that are migrated to Atrium Integrator
   Migration of data exchange parameters to Atrium Integrator
   The following figure illustrates the Sample ITSM BusinessService data exchange in the BMC Atrium Integration Engine 
   Sample ITSM BusinessService data exchange in the BMC Atrium Integrator
   
   
   
2. On the target server where you have installed Atrium Integrator, open the AIE to AI Migration Tool.
3. In the AIE Server Details area, specify the details about the server on which BMC Atrium Integration Engine is installed.
4. In the Target Server Details area, specify the details about the Atrium Integrator server to which you want to migrate the data exchanges.
5. Click Test Connection to confirm that you can successfully connect to the Atrium Integrator server.
6. Select Sample ITSM BusinessService data exchange to migrate to the Atrium Integrator server.
7. Click Migrate.
   The following figure illustrates the successful migration of Sample ITSM BusinessService data exchange to Atrium Integrator.  
   Successful migration of Sample ITSM BusinessService data exchange
   
   
   
8. Verify if Sample ITSM BusinessService data exchange is now available as a job in Atrium Integrator as shown in the following figure.
   Sample ITSM BusinessService job in Atrium Integrator
   
   
   
9. You can also verify the migration through BMC Atrium Integrator Spoon as shown in the following figure. 
   Sample ITSM BusinessService job in BMC Atrium Integrator Spoon 
   
   

To verify if rules are migrated correctly to Atrium Integrator

1. Open the transformation in Atrium Integrator Spoon.
2. Double-click the Set Rules step.
3. Click Test Class.
   If there are any errors in the migrated rules, an error occurs.