Professional > Data management scripting > Transferring data using a DMS file > Reading data
 
Reading data
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.
Notes
Opening Microsoft Excel 2007 files via the Microsoft Access Database Engine (Office 2007 and Office 2010) may 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:
32-bit edition: http://www.microsoft.com/download/details.aspx?id=26607
64-bit edition: http://www.microsoft.com/download/details.aspx?id=26605
See also
Reading metadata
Creating an .mdd file from proprietary metadata
Transferring data from a relational MR database (RDB)
Transferring data from a UNICOM Intelligence data file
Transferring data from IBM SPSS Statistics
Transferring data from Quantum
Transferring data from Quanvert
Transferring data from QDI/DRS
Transferring data from log files
Transferring data from Triple-S
Transferring data from Microsoft Office
Transferring data from XML
Reading data using other OLE DB providers
Transferring data using a DMS file