vimp:key_features

Key features

  • Oracle 7-12g database (using OCI API)
  • SQL server 7- 2012 (using BCP API)
  • SQL server CE
  • ODBC source (using ODBC API)
  • Interbase/Firebird
  • MySQL
  • PostgreSQL
  • SQLite
  • OleDB
  • SalesForce
  • Slemma
  • BDE
  • Multiple Delimited or Fixed width Text files
  • Multiple Excel files + Multiple Excel Spreadsheets
  • Multiple MS Access Databases + Multiple Tables
  • Multiple DBF Files
  • Multiple Clarion DAT Files
  • QlikView QVX/QVD files
  • Multiple Tables
  • Oracle 7-12g database
  • MS SQL Server
  • ODBC source
  • JDBC source
  • Interbase/Firebird
  • MySQL
  • PostgreSQL
  • SQLite
  • MongoDB
  • Ole DB
  • XML
  • JSON
  • Windows Event log
  • Google Spreadsheets
  • SalesForce
  • BrightPearl
  • Slemma
  • File System (Directory Metadata)
  • RSS Feed

This product features:

  • Great performance - hundreds of records per second
  • Comprehensive Error log
  • Rejected records file
  • Integrated Expressions builder
  • Data Preview

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

Oracle

There are two ways of loading available:

  1. Oracle direct path loading
  2. Conventional path

SQL server

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

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

  • vimp/key_features.txt
  • Last modified: 17/09/2018 10:46
  • by admin