一款数据库汇入工具。可将文本格式或任何 ODBC 文件使用 OCI API 或 BCP API 或 ODBC API 的转换技术，将其源数据转换後汇入 Oracle数据库、MS Sql server 、ODBC source 等。

File size: 77.4 MB

Design Import, Export and SQL scripts, add them to the Package and schedule it for execution on regular basis. Unlike SSIS and Oracle Warehouse builder Visual Importer ETL Professional can receive emails and process attachments as well. All FTP operations also supported. By combining simple Package Items together Visual Importer ETL Professional helps small businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.

Features :

LOAD DATA FROM:

Multiple Delimited or Fixed width Text files

Multiple Excel files + Multiple Excel Spreadsheets

Multiple MS Access Databases

Multiple Foxpro/DBF Files

Clarion

Oracle

MS SQL Server 6.5, 7.0, 2000, 2005, 2008, CE, Express

Firebird/Interbase

MySQL

PostgreSQL

SQLite

Any ODBC source

OLE DB

JDBC

BDE

Windows Event Log

XML Files

QVX Files

QVD Files

SalesForce

Brightpearl

Google Spreadsheets

Slemma

RSS Feed

Into:

Oracle

MS SQL Server

MySQL

PostgreSQL

SQLite

Interbase/Firebird

Any ODBC Compliant Database

OLE DB

JDBC

BDE

SalesForce

Slemma

Supported Repository Types:

MS Access (Default Repository).

Oracle

MS Sql Server

Interbase

MySQL

PostgreSQL

DATA LOADING AND AUTOMATION TASK:

Add Records

Update Records

Delete Records

Add New and Update existing Records

Apply Functions to Database Fields

Apply user defined Date format

Run calculations during import

Run Sql script before and after loading data

Filter Source Data

Use Select Statement as a Data Source

Export All Data from any database

Create or Delete directories on FTP server

Rename or delete files on FTP server

Send Emails with attachments

Receive Emails with attachments

Save attachments

Compress files

Decompress zip files

Copy, move, rename, merge, delete files

Compare files using MD5, size or creation date

Check if file exist

HTTP downloads

HTTP forms submissions

Post Twitter messages

Generate reports

Send SMS messages

Encrypt and decrypt files

Check database connections

Ping servers

Schedule packages for execution

Run bat files or execute any windows application

Edit and run SQL Scripts

Execute Packages from the command line

Whats New:

Updates: official site does not provide any info about changes in this version

.rar.html

.rar.html