You define the location and format of the data you want to transfer in the InputDataSource section of the Data Management Script (DMS) file. If you want to transfer a subset of the data only, you also define the filters in this section. For more information, see Filtering data in a DMS file.

When you read the data using the UNICOM Intelligence Data Model, you generally need a metadata source for the transfer. This can be a Metadata Document (.mdd) file or a proprietary data format for which an MDSC is available. However, for some data types you do not need to specify a metadata source, although it is usually preferable to do so. For more information, see Reading metadata.

Each DSC that you can use to read data behaves differently and has different requirements. This section provides information on reading data using some of the read-enabled DSCs that come with the UNICOM Intelligence Data Model.

For information about transferring data using an OLE DB provider that is not part of the UNICOM Intelligence Data Model, see Reading data using other OLE DB providers.

Opening Microsoft Excel 2007 files via the Microsoft Access Database Engine (Office 2007 and Office 2010) might result in application errors. The errors can occur when opening Excel files with mrADODsc, or when opening Excel files in UNICOM Intelligence Reporter. The issue can be resolved by downloading and installing the Microsoft Access Database Engine Service Pack 1: