User Guide › Administration › Content Transfer › Service Integration Utilities › UniDB2XML

UniDB2XML

Use the UNIDB2XML command line utility to extract data from a generic database to an XML file using SQL statements provided by user.

Usage:

UniDB2XML.exe <connection_string> <sql_path> <xml_path>

Example:

UniDB2XML.exe "Data Source=(local);Initial Catalog=mdb;Integrated Security=true;" c:\in\query.sql c:\dest\services.xml
UniDB2XML.exe "Data Source=myServer;Initial Catalog=mydb;User Id=sa;Password=sapass;" c:\in\query.sql c:\dest\services.xml 

XML2Excel

Use the XML2EXCEL command line utility to convert Excel file contents to XML format.

Usage

Excel2XML.exe <excel_path> <dest_path> [<xml_template_path>]

Where:

Example

Excel2XML.exe C:\src\BSI-ImportExcel.xlsx C:\dest\service.xml 
Excel2XML.exe C:\src\BSI-ImportExcel.xlsx C:\dest\service.xml 
"C:\Program Files (x86)\CA\Cloud Insight\Utilities\Excel2XML\BSI_XML_Import_Full.xml"

EXCEL2XML

Use the Excel2XML.EXE command line utility to convert Excel files into xml files.

Usage

Excel2XML.exe <excel_path> <dest_path> [<xml_template_path>]

Example

Excel2XML.exe C:\src\BSI-ImportExcel.xlsx C:\dest\service.xml 
Excel2XML.exe C:\src\BSI-ImportExcel.xlsx C:\dest\service.xml "C:\Program Files (x86)\CA\Cloud Insight\Utilities\Excel2XML\BSI_XML_Import_Full.xml"

EXCELIMPORTER

Use the EXCELIMPORTER command line utility to import the contents of Excel files into CA Business Service Insight.

Usage:

ExcelImporter <File_PATH> <UserName> <Password> <Organization> [<Result_File>]
<File_PATH>    The excel file path
<UserName>     The user name who has the import role
<Password>     The user password
<Organization> The user organization
<Result_File>  The import result file destination, which is optional. If ignored, it will output to the current directory.

Examples:

ExcelImporter C:\ImportExcels\Servics.xlsx my_user_name my_pass my_org 
ExcelImporter C:\ImportExcels\Servics.xlsx my_user_name my_pass my_org C:\ImportResultExcels\Servics_Out.xlsx

ExcelExporter

Use the ExcelExporter command line utility to export the CA Business Service Insight entities to Excel files.

Usage:

Usage: ExcelExporter.exe <Dest_PATH> <User_Name> <Password> <Organization> 
<Dest_PATH>    The path to the resulting output file.
<UserName>     The name of the user performing the export.
<Password>     The user password.
<Organization> The user's organization.
Utility Location:  "%WWW_ROOT%\Oblicore\bin\ExcelExporter.exe"

Example:

ExcelExporter C:\dest\Services_Out.xlsx my_user_name my_pass my_org

Entities

CA Business Service Insight entities that can be exported by this utility are:

Batch Job

To schedule a batch job, use these utilities to extract service data from CMDB systems and import it to CA Business Service Insight.

Note: This is an example only and should not be used for actual jobs.

Example:

REM ====Begin of batch==========
@echo off
@echo off
Set UTILITY_ROOT=C:\Program Files (x86)\CA\Cloud Insight\Utilities
Set WEB_BIN=C:\inetpub\wwwroot\Oblicore\bin
Set xml_path=C:\cmdb\service.xml
Set excel_path=C:\cmdb\BSI-ImportExcel.xlsx
Set result_excel_path=C:\cmdb\Servics_Out.xlsx

Set mdb_config="%UTILITY_ROOT%\MDBServiceConverter\MDBServiceConverter.xml"
Set xml_template_path="%UTILITY_ROOT%\XML2Excel\BSI_XML_Import_Full.xml"

Set MDBConvEXE_PATH="%UTILITY_ROOT%\MDBServiceConverter\MDBServiceConverter.exe"
Set XML2EXCELEXE_PATH="%UTILITY_ROOT%\XML2Excel\XML2Excel.exe"
Set ExcelImporter_PATH="%WEB_BIN%\ExcelImporter.exe"

%MDBConvEXE_PATH% %mdb_config%
%XML2EXCELEXE_PATH% %xml_path% %excel_path% %xml_template_path%
%ExcelImporter_PATH% %excel_path% my_name my_pass my_org %result_excel_path%
REM ====End of batch==========