Loading Data from DBF or FoxPro files

Advanced ETL Processor Reader Object is capable of extracting data from DBF or FoxPro files .

Note:

To change Reader Object properties double click on it. Type in Description than select appropriate Data Source Type.

Select source directory than select DBF Foxpro table(s) to load data from

One of the benefits of using Advanced ETL Processor is ability to extract data from several tables in one go. Provided that the tables have same structure all you need to do is specify mask and they will be loaded automatically.

Another way to extract data is to use select statement as a data source.



Note:
It is also possible to use Query builder to design queries 

 Data View

  Once all the parameters are set we can open it and see the actual data.

Data View Toolbar

1. Reader Properties
2. Refresh Data
3. Switch to Data View
4. Switch to Data Definition View

Data Definition View

Data Definition View Toolbar

1. Reader Properties
2. Refresh Data
3. Print Data Definition
4. Print Preview Data Definition
5. Find
6. Switch to Data View
7. Switch to Data Definition View

About Advanced ETL Processor

Advanced ETL Processor is a Codeless ETL Tool.
It is designed to automate extracting data from ANY database, transform, validate it and load into ANY database .

Users can create Data transformations and Sql scripts add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis

By combining simple Package actions together Advanced ETL Processor helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.

Feel free to try Advanced ETL Processor today. All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

Watch Online Flash Demo
Download Advaced ETL Processor now