Importing, transforming, and migrating data by using BMC Atrium Integrator
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
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.