Adding a Data Mashup to a Process

Data Platform

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 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 Data Platform 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