Creating a data store connection for the data transfer

The first step is to create a data store connection in Atrium Integrator to communicate with the external CSV data store, which is the source of the discovery data. You must then create a connection to communicate with the AR system server, which is the destination for the data.

The following diagram illustrates the steps involved in creating a datastore connection for the data transfer.

Creating a data store connection

Before you begin

Consider the following when creating data store connections:

For XML and CSV connection, if there are too many files in the folder, check if the fields from these files are populated in NGIE:FileMetaData file before you create a job.
For XML and CSV connection, do not add files under root folder.
For database connection, if you plan to create a transformation with Response enabled, ensure that user has permissions to access the associated tables in the data base.
You can create a CSV or XML datastore connection with a remote Atrium Integrator Carte server.
To support this capability, Job_FileMetaLoader job is added to Atrium Integrator sample jobs. Do not delete this job or you will not be able to create CSV or XML datastore connection with Atrium Integrator Carte server. For more information, see Atrium Integrator sample jobs.

Atrium Integrator supported data types

If a BMC CMDB attribute of the currency data type is mapped to an integer field in the external data store, the default allowable currency type (USD) in BMC CMDB is populated along with the integer field. However, if a BMC CMDB attribute of the currency data type is mapped to a varchar field in the external data store, Atrium Integrator sets the currency type based on the value that you have specified in the varchar field. For example, if the varchar field value is 2134 EUR, Atrium Integrator sets the currency type as EUR.

Each value that is defined for a BMC CMDB attribute of the enum data type has an associated ID. A varchar field in the external data store can be mapped to the selection value that is defined for the attribute of the enum data type. An integer field in the external data store can be mapped to the associated ID that is defined for the attribute of the enum data type.

The following table lists the data types supported for each external database.

BMC Atrium CMDB attribute data types and corresponding supported data types in external data stores

	Data store type
	BMC CMDB attribute data type	Oracle	SQL	DB2	Sybase	XML and CSV	MySQL
Requires specific connection parameters	Yes	Yes	Yes	Yes		No	Yes
	character	number char varchar float date	varchar int float char date/time decimal real	int varchar decimal char date time real	varchar int float char date/time numeric time real	string int number	int Varchar float char date/time integer time Real date decimal timestamp
	currency	number varchar	number varchar	number varchar	number varchar	string int number	int varchar float char integer real decimal
	date	date	date/time real	date time	date/time time	date	date/time time date timestamp
	date/time	char varchar	date/time	date time	varchar char	date	varchar char
	decimal	Not applicable	int float decimal real	int decimal real	int float numeric real	int	varchar float integer time real date decimal
	diary	number char varchar float date	varchar int float char date/time decimal real	int varchar decimal char date time real	varchar int float char date/time numeric time real	string int number	int varchar float char date/time integer time real date decimal timestamp
	integer	number float	int float decimal real	int decimal real	int float numeric real	number int	int float integer real decimal
	real	number float	int float decimal real	int decimal real	int float numeric real	number int	int float integer real decimal
	selection	char varchar number	int decimal number varchar	int varchar decimal char number	varchar int float char numeric real	string int strings	int varchar char integer
	time	char varchar	varchar char	varchar char	varchar char	date	varchar char

To create a source data store connection

In the BMC Remedy AR System Home Page, select BMC Atrium Integrator > Atrium Integrator.
The Atrium Integrator console opens.
In the Atrium Integrator console, click Manage Data Store Connections.
The Manage Data Stores window opens and displays a list of defined data sources.
Click New Data Store.
The New Data Store section appears on the right side of the Manage Data Stores window.
Select the Data Store Type.
The fields below the Data Store Type change depending on the data store that you selected.
Note

You must specify only the server name, and not the fully qualified domain name, in the Database Host Name field.
Specify the remaining information to create a connection.
Click Test Connection to verify the source data store connection parameters,
Click Save.

To create a target data store connection

Click New Data Store .
In the New Data Store section on the right side of the Manage Data Stores window, select AR System as the Data Store Type.
Type a name for the Datastore in the Data Store Name field.
In the AR Server Name field, type the name of your BMC Remedy AR System server.
(optional ) Type the port number.
Specify the remaining information for the target data store.
Click Test Connection to ensure that you can connect to BMC CMDB,
Click Save.

Creating a data store connection for the data transfer

Before you begin

Atrium Integrator supported data types

To create a source data store connection

To create a target data store connection

Comments