Demo Data

In order to provide a flavor of the types of data the Advanced ETL Processor can handle, a number of different file types have been provided for demonstration purposes.

A range of different types of data files have been provided, in addition to SQL scripts to create database tables in Oracle, and MS SQL Server.

Text files

Examples provided are using text files in

 “C:\Users\Public\Documents\DBSL\Demo\Buffer” and  
 “C:\Users\Public\Documents\DBSL\Demo\Text Files”

Access Databases

 “C:\Users\Public\Documents\DBSL\Demo\MS Access”

DBF Files

 “C:\Users\Public\Documents\DBSL\Demo\DBF”

Excel Files

 “C:\Users\Public\Documents\DBSL\Demo\Excel”

Note:

If you want to use other locations please amend Directories properties.

Demo Tables

Use SQL Scripts provided to create demo tables for Oracle and MS SQL Server. Please adjust connection details before executing these scripts.

Most of the SQL Server Imports use DEMO database. You have to create demo tables within this database first before executing import scripts.

ODBC connections

During the setup process, the following ODBC DSN is created during the installation:

  • ODBC_FOXPRO
  • ODBC_ACCESS_SOURCE
  • ODBC_ACCESS_TARGET
  • ODBC_MS
  • ODBC_ORACLE
  • ODBC_EXCEL

These ODBC connections provide the basis for the ETL Processor to perform its tasks and process different types of data, while ensuring that the automation of these processes is completely transparent.

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • aetl/demo_data.txt
  • Last modified: 12/07/2015 17:41
  • by admin