Powerful ETL tool. Imports data into Oracle ,SQL Server, ODBC Databases (Datawarehouses) from flat files or ODBC datasources.
Very fast and reliable. Uses naitive API.
Data targets: Oracle 7-10g database (
using OCI API) SQL server 7- 2005 (
using BCP API) ODBC source (
using ODBC API)Data sources: Multiple Delimited or Fixed width Text files Multiple Excel files + Multiple Excel Spreadsheets Multiple MS Access Databases Multiple DBF Files Any ODBC source Multiple TablesRepository: MS Access Oracle MS Sql Server Interbase MySQL PostgreSQLThis product features:Great performance - hundreds of records per second Comprehensive loggingRejected records file Integrated Expressions builder 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 service.
ODBC
Any ODBC compliant database.
Other features are: Easy Repository switching Data Preview Mapping editor Exports SQL scripts editor Packages editor Integrated Scheduler Logging Lookups Email Notifications File Operations Check Files Compare Files FTP Downloads Applications
Download