User Guide › Administration › Content Transfer › Service Integration Utilities

Service Integration Utilities

CA Business Service Insight provides several utilities that you can use to import data from other system, such as CMDB, automatically.

• The utilities are located on the Web Server under "%BSI_Installation_Folder%\Utilities".
• The Excel importer is located under "%WWW_ROOT%\Oblicore\bin\ExcelImporter.exe"

64 Bit Web Servers

If the Business Service Insight Web Server is running under a 64-bit OS, run the file corflags.exe using the /32bit+ option to force the utility to run in 32-bit mode as shown here.

corflags.exe /32bit+ ExcelImporter.exe

Note: The corflags.exe utility is available by installing the .NET Framework Tools component of the Microsoft Windows® SDK.

MDBServiceConverter

Use the MDBServiceConverter command line utility to extract data from CMDB and produce XML files compliant with our xml template file.

Usage

MDBServiceConverter.exe <config path>

<config path> is an xml file in which you can config the parameters such as connection string and CMDB related filter conditions, service name columns and the output target.

MDBServiceConverter.exe "C:\Program Files (x86)\CA\Cloud Insight\bin\MDBServiceConverter.xml"

Example: MDBServiceConverter.xml

<?xml version="1.0" encoding="utf-8" ?>
<ConverterConfig xmlns="http://www.ca.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ca.com MDBServiceConverter.xsd">
<ConnectionString>Data Source=cheda16-win7-1;Initial Catalog=mdb;User Id=sa;Password=caworld1!;</ConnectionString>
<Inactive>0</Inactive>
<Is_ci>1</Is_ci>
<Is_asset>0</Is_asset>
<resource_familyS>
<resource_family id="1">Enterprise Service</resource_family>
<resource_family id="2">Service</resource_family>
</resource_familyS>
<resource_classeS forId="2">
<resource_class>IT Service</resource_class>
</resource_classeS>
<serviceNameS>
<serviceName>Resource_name</serviceName>
<serviceName>Host_name</serviceName>
</serviceNameS>
<target_file>c:\cmdb\service.xml</target_file>
</ConverterConfig>