Default language.

Importing, transforming, and migrating  data by using BMC Atrium Integrator


 provides data management services to enable the following:

  • Integration of external data with data residing in your BMC solution stack
  • Data migration, import, change, and export

Data integration

The Atrium data integration services are available for  through the  adapter, an AR System Database Connectivity (ARDBC) plugin, the  Spoon client, and the  forms — all are installed with the . These services enable you to:

  • Gather, or extract, data from a variety of sources
  • Change and transport, or transform, data
  • Store, or load, data in one or more target locations

You can rapidly extend the scope of your data management capabilities by adding Atrium Integrator, the  suite of applications, and the .

The following diagram illustrates the  interaction with the  adapter, the Spoon client, and the  forms.

 adapter and related components

AR_AtriumSolutionV2.jpg

Component

Description

 adapter

An ARDBC plugin that receives requests for executing and monitoring jobs from the , sends them to the  Carte server, then returns the Carte server results to the . Installed with your .

A GUI used to create and manage data integration jobs and transformations. Installed with your .

A web server for data integration that allows remote job and transformation execution by accepting XML files that contain the job's (or transformation's) execution configuration. Enables remote monitoring as well as starting and stopping of jobs and transformations that run on the server. Installed with your .

 AR and  plugins

A plugin used to import data from and/or export data to an external data store to and/or from the  and/or the . Installed with your  and  installation.

The .

 repository

Forms that store jobs and transformation definitions and log files. The Spoon client can be used to access the repository.

 forms

Forms that are shipped with  or are created by you.

 ARDBC plugin front-end forms that allow job execution and monitoring on the Carte server. Installed with your .

External data

Flat files, spreadsheet files, database files, or other data that is imported or exported to or from your  for data migration.

 permissions scheme

Access to the Spoon client application and all base vendor forms for the ARDBC plug-in is configured in the  permissions interface. To use the Spoon client you must connect to an  repository, which resides on the . The Spoon client requires an  user with administrator permissions to connect. To access the base vendor forms of the ARDBC plug-in, the user's role must be a  UDM administrator or a  UDM user.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*