Running the Extractor from the Command Line

The command line extractor uses a specific configuration file for your database.

Note:Although the database connection can be defined in either the command line or in the header of the xml configuration file. the command line always takes precedence over the xml configuration settings.

Use the following command to run the Extractor from a command line:

extractor <option1> <option2> ...

Extractor Command Options

Option

Description/Example

[-X] <fullpath_xml_config_file>

Full path and file name for the configuration file.

C:\sms2.extractor.config

[-O] <fullpath_output_directory>

Full path to the output directory.

C:\test

[-O] <fullpath_output_directory>

Name for the .zip file.

BDNA.zip

[-H] <database_host_name>

Host name or IP address of asset inventory database server.

192.168.8.8

[-PT] <database_port>

Port number for asset inventory database server.

1433

[-C] <database_catalog_name>

Catalog name for Microsoft SQLServer or MySQL database.

SMS_EUR

[-U] <database_user_name>

Username of the asset inventory database owner.

User

[-P] <database_user_password>

Password of the asset inventory database owner.

Password

[-I] <use_windows_authentication>

Specifies whether or not to use Windows credentials.

true | false

[-RS]

Download all the files in your directory on the BDNA FTP site.

[-UZ]

Extracts the files from the .zip file.

[-T] <FTP_transport_available>

Specifies to use FTP or SFTP.

Note: The address of the B>DNA SFTP site is ftp://ftp01.bdna.com, port:22. Verify that the address and the port can pass your firewall.

FTP | SFTP

[-TU] <FTP_username>

Username for the FTP site.

[-TP] <FTP_password>

Password for the FTP site user.

[-?] <Help>

Outputs command help.

Configuration File Headers

Database

Header

MSSQL

<?xml version="1.0" encoding="utf-8" ?>

<configuration LoaderConfig="" Disc_Source="">

 

<Connection Type="MSSQLSERVER">

<Property Name="Data Source" Value=""/>

<Property Name="Initial Catalog" Value=""/>

<Property Name="Persist Security Info" Value="True"/>

<Property Name="User ID" Value=""/>

<Property Name="Password" Value=""/>

<Property Name="Integrated Security" Value="false"/>

</Connection>

Oracle

<?xml version="1.0" encoding="utf-8" ?>

<configuration LoaderConfig="" Disc_Source="">

 

<Connection Type="ORACLE">

<Property Name="Host" Value=""/>

<Property Name="Service Name" Value=""/>

<Property Name="User ID" Value=""/>

<Property Name="Password" Value=""/>

<Property Name="Port" Value="1521"/>

</Connection>

DB2

><?xml version="1.0" encoding="utf-8" ?>

<configuration LoaderConfig="" Disc_Source="">

 

<Connection Type="DB2">

<Property Name="Data Source" Value=""/>

<Property Name="Initial Catalog" Value=""/>

<Property Name="Persist Security Info" Value="True"/>

<Property Name="User ID" Value=""/>

<Property Name="Password" Value=""/>

<Property Name="Integrated Security" Value="false"/>

</Connection>

MySQL

<?xml version="1.0" encoding="utf-8" ?>

<configuration LoaderConfig="" Disc_Source="">

 

<Connection Type="MYSQL">

<Property Name="Data Source" Value=""/>

<Property Name="Initial Catalog" Value=""/>

<Property Name="User ID" Value=""/>

<Property Name="Password" Value=""/>

<Property Name="Port" Value=""/>>

<Property Name="Connect Timeout" Value="3600"/>

</Connection>

Sybase

<?xml version="1.0" encoding="utf-8" ?>

<configuration LoaderConfig="" Disc_Source="">

 

<Connection Type="SYBASE">

<Property Name="Provider" Value="SAOLEDB"/>

<Property Name="Data Source" Value=""/>

<Property Name="Initial Catalog" Value=""/>

<Property Name="User ID" Value=""/>

<Property Name="Password" Value=""/>

<Property Name="Port" Value="43455"/>

</Connection>