Adding a Data Mashup to a Process

BDNA Data Platform 5.5

A data mashup allows the import of an external data source to the Normalize database. Add a data mashup when you want to input data from any data sources that are accessible from your BDNA Normalize server. For example, you can input warranty data from an Accounting database or Human Resource data from a Human Resources database. A data mashup is added as a separate data source to an existing process.

The following items are prerequisites to creating a data mashup:

Your activation key must grant access to the Data Mashup feature
Create at least one IT Discovery Tool, Fingerprint, and/or Normalize CM process
Determine your data source
Create a mashup configuration file with instructions for retrieving data from the specified data source

Note • A data mashup can only be added to an existing IT Discovery Tool or Normalize CM process.

There are three types of data sources you can use as a mashup source:

Database Connection—Obtains data from your MSSQL, Oracle, DB2, MySQL, PostgreSQL, or Sybase database. For more information, see Adding a Data Mashup Using a Database Connection
File (csv, txt)—Obtains data from a CSV or TXT file located on a network or local server. For more information, see Adding a Data Mashup Using a CSV File
Zip File—Obtains data from a BDNA Normalize zip file located on a network or local server. For more information, see Adding a Data Mashup Using a Normalize Zip File

Example of a Data Mashup Using CSV Files