Extracting Asset Data › How to Extract Asset Data › Create a Mapping File (Database)

Create a Mapping File (Database)

You can create a mapping file for a database and define the following mapping file parameters:

Note: All XML files you create, and the sample XML code used in this guide must be well-formed and comply with XML and XSD standards.

Datasource type

Enter datasource type "DataBase or database".

Note: The Datasource tag has subtypes and connection properties tags.

Subtype

Each database is assigned a predefined numeral as a unique code. The CA Asset Converter identifies a particular database on the associated codes and loads the property names required for the connection to the database. You can use any of the following codes:

• 13 (DB2)
• 12 (MYSQL)
• 11 (ORACLE)
• 10 (SQLSERVER)
• 14 (ODBC)

Example: Sample XML for Typical Connection Properties

The following sample XML code illustrates the typical connection properties of a mapping file for a database.

<?xml version="1.0" encoding="UTF-8"?>
<asset-converter>

<datasource type="DataBase">
<subtype>10</subtype>
<connection-properties>

 <property name="Server">MyHost</property>
 <property name="Port">1433</property>
 <property name="Database">AssetDB</property>
 <property name="Username">sa</property>
 <property name="Password">password</property>

</connection-properties>
</datasource>

</asset-converter>