Warning: Undefined array key 1 in /home/tools/www/www/wiki/lib/plugins/note/syntax.php on line 103
Key features
Data import
Data targets:
- Oracle 7-12g database (using OCI API)
- SQL server 7- 2017 (using BCP API)
- ODBC source (using ODBC API)
- Interbase/Firebird
- MySQL
- PostgreSQL
- SQLite
- Ole DB
- BDE
- SalesForce
- 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
- QlikView QVX files
- QlikView QVD files
- Clarion DAT files
- Multiple Tables
- ODBC source
- JDBC source
- Ole DB
- BDE
- Oracle 7-11g database
- MS SQL Server
- Interbase/Firebird
- MySQL
- PostgreSQL
- SQLite
- MongoDB
- XML
- Windows Event log
- Google Spreadsheets
- SalesForce
- BrightPearl
- Slemma
- Google Spreadsheet
Repository:
- MS Access
- Oracle
- MS Sql Server
- Interbase
- MySQL
- PostgreSQL
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.
Other features are:
- SQL Scripts
- Email Templates
- Report Designer
- Integrated Scheduler
- Logging
- Email Notifications
- POP3 Email Receiver
- IMAP4 Email Receiver
- File Operations
- Check Files
- Check Disk Space
- Compare Files
- Full range of FTP operations
- ZIP
- Applications
- SQL Data Check
- Automatic Backups
- Mass Data Export
- Http Download
- SOAP
- XSLT
- Encryption/Decryption
- Ping Server
- Check Database Connection
- Post Twitter Messages
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