The Dbase connector is an object that is used to get data from DBase III, DBase IV and DBase 5 or VFPOLEDB.1 files (*.dbf).
After adding the connector to the ETL task workspace, set basic properties and import options. The connector output can also be edited and data filtering options can also be set.
The Import Options page is used to specify a file with imported data and parameters used to determine data range.
Specify path to the directory that contains Dbase files, and a driver for corresponding Dbase version.
Unsuccessful import with all available drivers is possible. It depends on the fact that the file with the *.dbf extension was created using the Visual FoxPro driver version. In this case, use the Visual FoxPro provider for data import.
IMPORTANT. To import data by means of the VFPOLEDB.1 driver, use 32-bit version of Foresight Analytics Platform because this driver does not support the work with 64-bit applications.
Enter the query text, in accordance with which the data is selected, in the Query input box.
The Settings button enables the user to determine advanced settings used on identifying data.
The Browse Data button shows data selected by a query.
NOTE. Only the first hundred of the provider lines will be displayed during the data preview.
See also: