This documentation supports the 19.02 version of BMC Atrium Core.

To view the latest version, select the version from the Product version menu.

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 parametersYesYesYesYes
NoYes

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

  1. In the BMC Remedy AR System Home Page, select BMC Atrium Integrator > Atrium Integrator
    The Atrium Integrator console opens.
  2. In the Atrium Integrator console, click Manage Data Store Connections.
    The Manage Data Stores window opens and displays a list of defined data sources. 

  3. Click New Data Store.
  4. The New Data Store section appears on the right side of the Manage Data Stores window.



  5. 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.

  6. Specify the remaining information to create a connection.
  7. Click Test Connection to verify the source data store connection parameters, 
  8. Click Save.



To create a target data store connection

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


Was this page helpful? Yes No Submitting... Thank you

Comments