Key Features

Data targets

  • Oracle 7-12g database (using OCI API)
  • MS SQL Server server 7-2014 (using BCP API)
  • MS SQL server CE
  • ODBC source (using ODBC API)
  • Ole DB
  • BDE
  • Interbase/Firebird
  • MySQL
  • PostgreSQL
  • SQLite
  • Slemma

Data Sources

  • Multiple Delimited or Fixed width Text files
  • Multiple Excel files + Multiple Excel Spreadsheets
  • Multiple MS Access Databases + Multiple Tables
  • Multiple DBF Files
  • Clarion DAT files
  • QlikView QVX and QVD files
  • Multiple Tables
  • Oracle 7-12g database
  • MS SQL Server
  • ODBC source
  • JDBC source
  • Interbase/Firebird
  • MySQL
  • PostgreSQL
  • SQLite
  • Ole DB
  • BDE
  • XML
  • Windows Event log
  • Google Spreadsheets
  • SalesForce
  • BrightPearl
  • Slemma

This product features

  • Great performance - thousands of records per second
  • Comprehensive logging
  • Rejected records file
  • Integrated Expressions builder
  • Filtering Data

Allows the user to perform calculation during the loading process such as splitting fields, concatenations, data formatting, and loading cross/pivot tables.

Oracle

There are two ways of loading available:

  • Oracle direct path loading
  • Conventional path

MS SQL server

This software uses the same API as Microsoft DTS/SSIS service.

ODBC

Any ODBC compliant database.

Data Sources

  • Multiple MS Access Databases + Multiple Tables
  • Multiple DBF Files
  • QlikView QVX and QVD files
  • Multiple Tables
  • Oracle 7-12g database
  • MS SQL Server
  • ODBC source
  • Ole DB
  • BDE
  • Interbase/Firebird
  • MySQL
  • PostgreSQL
  • SQLite
  • Windows Event log
  • Google Spreadsheets
  • SalesForce
  • BrightPearl
  • Slemma

Data Targets

  • Flat files

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

  • dewizard/key_features.txt
  • Last modified: 17/09/2018 09:42
  • by admin