Demo Data
In order to provide a flavor of the types of data the Visual Importer ETL 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”
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. User 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 Visual Importer ETL to perform its tasks and process different types of data, while ensuring that the automation of these processes is completely transparent.