Key features
Data import
Data targets:
- 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
Data sources:
- 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:
- Oracle direct path loading
- 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